Which three statements are true regarding single row subqueries?

• A.They must be placed on the left side of the comparison operator or condition.
• B.A SQL statement may have multiple single row subquery blocks.
• C.They can be used in the having clause.
• D.They must return a row to prevent errors in the SQL statement.
• E.They can be used in the where clause.
• F.They must be placed on the right side of the comparison operator or condition.

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Unset REMOTE_LOGIN_PASSWORDFILE
• B.Have the OS administrator add KING to the OSDBA group
• C.Set OS_AUTHEN_PREFIX to OPS$
• D.Grant DBA to KING
• E.Alter user KING to be IDENTIFIED EXTERNALLY

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A.AUTOEXTEND is possible for the datafile
• B.It will be a dictionary-managed tablespace by default
• C.It must be bigger than the largest SMALLFILE tablespace
• D.Additional data files may not be added
• E.It will always have a 32K blocksize

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

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR.
h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?

• A.TO_date(PROMO_ BEGIN_DATE * 5| will return a date.
• B.PROMO_ BEGIN_DATE - sysdate will return a number.
• C.to_numberipromo_begin_date) - s will return a number.
• D.PROMO_ BEGIN_DATE - sysdate will return an error.
• E.PROMO_ BEGIN_DATE - 5 will return a date.

Comment: *

Name: *

Email: *

Verification: *