Oracle Database SQL Certification Exam - DBExam Practice Questions (mini)

Which one of the following is a DML statement?

(Data Manipulation Language) INSERT UPDATE DELETE CALL EXPLAIN CALL LOCK

You can use a substitution variable to replace:

A floating-point value in a WHERE clause The name of a table in a SELECT statement

Which two statements are true about Oracle synonyms?

A synonym can have a synonym. A synonym has an object number.

What can an INSERT statement do?

Add data into more than one column in a table Add rows into more than one table.

Now you have changed the purpose of the PIER column in the MARINA table and want to remove the comment you just created in the previous question. Which of the following statements will remove the comment?

COMMENT ON COLUMN MARINA.PIER IS '';

No-user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)?

COMMIT erases all the transaction's save points and releases its locks. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks and erases its savepoints. COMMIT ends the transaction and makes all its changes permanent.

To list all the currently defined variables, use:

DEFINE

What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

OODB incorporates methods with data structure definition, whereas RDB does not allow this.

Which of the following is true about ROLES?

Roles are in the same namespace as USERS.

Assume you have a table ITEMS that includes a column STATUS. Which of the following statements is syntactically correct?

SELECT * FROM ITEMS FETCH NEXT 20 ROWS WITH TIES; SELECT * FROM ITEMS FETCH NEXT 20 PERCENT ROWS ONLY; SELECT * FROM ITEMS ORDER BY STATUS FETCH NEXT 20 ROWS WITH TIES;

What can you use to submit SQL statements for execution?

SQL*Plus

You can add your own comments to the data dictionary with the COMMENT statement using which of the following?

TABLE COLUMN

You need to determine the day of the week for a particular date in the future. Which function will reveal this information?

TO_CHAR

If you want to display a numeric value with dollar signs and commas, which of the following is the best approach to take?

The TO_CHAR function with a format model.

The LEAD function returns data from:

The row specified by the LEAD function's offset.

Your user account owns an updatable view, BACKLOG, which is based on the table PROJECTS. You are tasked to give SELECT and UPDATE capabilities to another user account named MARINO. Currently, MARINO has no privileges on either the table or the view. You want for MARINO to have the ability to grant SELECT on the view to other users as well. Examine the following SQL code: GRANT SELECT ON BACKLOG TO MARINO WITH GRANT OPTION; GRANT UPDATE ON BACKLOG TO MARINO; Which of the following statements is true?

The statements will execute successfully and perform as intended.

Which two methods are supported for migrating your on-promises Oracle database to an Oracle Autonomous transaction Processing (ATP) database in Oracle cloud Infrastructure?

Transfer the physical database files and re-create the database Use oracle data Pump

Which three are key components of an Entity Relationship Model?

an entity an attribute a relationship