In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• B.It must be the name of the database to whose instance HR wishes to connect
• C.It must be the value of the SERVICE_NAMES parameter on the client side
• D.It must be the name of the server running the database to whose instance HR wishes to connect
• E.It must resolve to a valid connect descriptor in the client's tnsnames.ora file

Comment: *

Name: *

Email: *

Verification: *

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

• A.Statement 1 returns only one row of output.
• B.Statement 2 returns only one row of output.
• C.Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
• D.Both the statements give the same output.
• E.Statement 2 may return multiple rows of output.

Comment: *

Name: *

Email: *

Verification: *

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

• A.dump files
• B.input files
• C.control files
• D.bad files
• E.password files

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.You can no longer monitor it
• B.You can reattach to it and monitor it
• C.It is paused and can be resumed
• D.It continues to run in the background
• E.It terminates

Comment: *

Name: *

Email: *

Verification: *

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

• A.ORDER BY CUST_NO
• B.ORDER BY 2, 1
• C.ORDER BY "CUST_NO"
• D.ORDER BY 2, cust_id
• E.ORDER BY "Last Name"

Comment: *

Name: *

Email: *

Verification: *