Q1. Which three statements are true regarding the data types?

A. Only one LONG column can be used per table.

B. ATIMESTAMP data type column stores only time values with fractional seconds.

C. The BLOB data type column is used to store binary data in an operating system file.

D. The minimum column width that can be specified for a varchar2 data type column is one.

E. The value for a CHAR data type column is blank-padded to the maximum defined column width.

View Answer

Q2. Which statement correctly grants a system privilege?

A. GRANT EXECUTE

ON prod

TO PUBLIC;

B. GRANT CREATE VIEW

ON tablel TO used;

C. GRANT CREATE TABLE

TO used ,user2;

D. GRANT CREATE SESSION TO ALL;

View Answer

Q3. Examine the structure of the members table:

Which query can be used to display the last names and city names only for members from the states MO and MI?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

View Answer

Q4. Which two statements are true regarding roles? (Choose two.)

A. A role can be granted to itself.

B. A role can be granted to PUBLIC.

C. A user can be granted only one role at any point of time.

D. The REVOKE command can be used to remove privileges but not roles from other users.

E. Roles are named groups of related privileges that can be granted to users or other roles.

View Answer

Q5. You want to display 5 percent of the rows from the sales table for products with the lowestAMOUNT_SOLD and also want to include the rows that have the sameAMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows.

Which query willprovide the required result?

A. SELECT prod_id, cust_id, amount_sold FROM sales

ORDER BY amount_sold

FETCH FIRST 5 PERCENT ROWS WITH TIES;

B. SELECT prod_id, cust_id, amount_sold FROM sales

ORDER BY amount_sold

FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

C. SELECT prod_ id, cust_id, amount_sold FROM sales

ORDER BY araount_sold

FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;

D. SELECT prod_id, cust_id, amount_sold FROM sales

ORDER BY amount sold

FETCH FIRST 5 PERCENT ROWS ONLY;

View Answer

Q6. Which statement is true about transactions?

A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.

B. Each Data Definition Language (DDL) statement executed forms a single transaction.

C. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.

D. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.

View Answer

Q7. Which two statements are true about sequences created in a single instance database? (Choose two.)

A. CURRVAL is used to refer to the last sequence number that has been generated

B. DELETE <sequencename> would remove a sequence from the database

C. The numbers generated by a sequence can be used only for one table

D. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement

E. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted

View Answer

Q8. Examine thestructure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.

Which SQL statement must you execute? 

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

View Answer

Q9. Examine the structure of the employees table.

There is a parent/child relationship betweenEMPLOYEE_IDandMANAGER_ID.

You want to display the last names and manager IDs of employees who work for the same manager asthe employee whoseEMPLOYEE_ID123.

Which query provides the correct output? 

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

View Answer

Q10. You are designing the structure of a table in which two columns have the specifications:

COMPONENT_ID - must be able to contain a maximum of 12 alphanumeric characters and uniquely identify the row

EXECUTION_DATETIME - contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components.

Which two options define the data types that satisfy these requirements most efficiently?

A. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.

B. The EXECUTION _DATETIME must be of TIMESTAMP data type.

C. The EXECUTION_DATATIME must be of DATE data type.

D. The COMPONENT_ID must be of ROWID data type.

E. The COMPONENT_ID must be of VARCHAR2 data type.

F. The COMPONENT_ID column must be of CHAR data type.

View Answer