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 replays the delete
• B.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• C.The second ROLLBACK command does nothing
• 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: *

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_limit * .15, 'Not Available') FROM customers;
• B.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• C.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• D.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
• E.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle database? (Choose three.)

• A.Views can be updated without the need to re-grant privileges on the view
• B.Data Manipulation Language (DML) can always be used on views
• C.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• D.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• E.The WITH CHECK clause prevents certain rows from being updated or inserted
• F.Tables in the defining query of a view must always exist in order to create the view
• G.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

• A.TIMESTAMP WITH LOCAL TIMEZONE
• B.TIMESTAMP WITH TIMEZONE
• C.TIMESTAMP
• D.INTERVAL YEAR TO MONTH
• E.INTERVAL DAY TO SECOND

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