Examine these commands:

Which two statements are true about the sqlldrexecution? (Choose two.)

• A.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• B.It overwrites data in EMP with data in EMP.DAT
• C.It uses the database buffer cache to load data
• D.It generates a sql script that it uses to load data from EMP.DAT to EMP
• E.It appends data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

• A.SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
• B.SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
• C.SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
• D.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• E.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using SQL*Plus?

• A.It can run Recovery Manager (RMAN) commands.
• B.It can run scripts passed to it by a shell script.
• C.It can run scripts entered at the SQL prompt.
• D.It has its own commands that are separate from any SQL statements.
• E.It has both command-line and graphical user interfaces (GUI).
• F.It must be downloaded from the Oracle Technology Network (OTN).

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

• A.The second ROLLBACK command does nothing
• B.The second ROLLBACK command replays the delete
• C.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• D.The second ROLLBACK command undoes the insert
• E.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Comment: *

Name: *

Email: *

Verification: *

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

• A.The command succeeds and HR will be connected to the orcl and abc.sql databases
• B.The command fails and reports an error because @ is used twice
• C.The command fails because the script must refer to the full path name
• D.The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

Comment: *

Name: *

Email: *

Verification: *