In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A.It succeeds and the generated undo is stored in SYSTEM.
• B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
• C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• D.It succeeds and the generated undo is stored in SYSAUX.
• E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the results of using the INTERSECT operator in compound queries?
(Choose two.)

• A.Column names in each SELECT in the compound query can be different
• B.INTERSECT returns rows common to both sides of the compound query
• C.The number of columns in each SELECT in the compound query can be different
• D.INTERSECT ignores NULLs
• E.Reversing the order of the intersected tables can sometimes affect the output

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: *

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.SYSDATE can be queried only from the DUAL table
• B.CURRENT_DATE returns the current date and time as per the session time zone
• C.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• D.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• E.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• F.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT NVL2(cust_credit_linit * .15, 'Not Available') FROM customers;
• B.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• C.SELECT NVL(cust_credit_linit * .15, 'Not Available') FROM customers;
• D.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• E.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

Comment: *

Name: *

Email: *

Verification: *