Examine the description of the BOOKS_TRANSACTIONS table:

• A.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101', 'A102');
• B.WHERE borrowed_date = SYSDATE AND {transaction_type = 'RM* AND (raeraber_id = 'A101' OR member_id = 'A102));
• C.WHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR member_id = 'A102');
• D.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101', 'A102'));

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about single row functions? (Choose two.)

• A.TRUNC : can be used with NUMBER and DATE values
• B.FLOOR : returns the smallest integer greater than or equal to a specified number
• C.MOD : returns the quotient of a division operation
• D.CONCAT : can be used to combine any number of values
• E.CEIL : can be used for positive and negative numbers

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A.Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• B.Rolling back to a SAVEPOINT can undo a DELETE statement
• C.Only one SAVEPOINT may be issued in a transaction
• D.Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• E.A SAVEPOINT does not issue a COMMIT

Comment: *

Name: *

Email: *

Verification: *

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

• A.It can be accessed only by the SYS user
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows but only a single column
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can display multiple rows and columns

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

• A.UNION ALL
• B.UNION
• C.SUBTRACT
• D.MINUS
• E.INTERSECT

Comment: *

Name: *

Email: *

Verification: *