Question 1

Which two are true about the WITH GRANT OPTION clause?

Options :

A :

The grantee can grant the object privilege to any user in the database, with of without including this option.

B : The grantee must have the GRANT ANY OBJECT PRIVILEGE system prvilege to use this option.

C : It can be used when granting privileges to roles.

D : It can be used for system and object privileges.

E : It cannot be used to pass on privileges to PUBLIC by the grantee.

F : It can be used to pass on privileges to other users by the grantee.

Answer: E,F

Question 2

Examine the data in the PRODUCTS table:

Examine these queries:

1. SELECT prod name, prod list

FROM products

WHERE prod 1ist NOT IN(1020) AND category _id=1;

2. SELECT prod name, | prod _ list

FROM products

WHERE prod list < > ANY (1020) AND category _id= 1;

SELECT prod name, prod _ list

FROM products

WHERE prod_ list < > ALL (10 20) AND category _ id= 1;

Which queries generate the same output?

Options :

A : 1 and 3

B : 1, 2 and 3

C : 2 and 3

D : 1 and 2

Answer: A

Question 3

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

Options :

A : SELECT * FROM customers WHERE TO_ CHAR (customer_ id) = '0001';

B : SELECT * FROM customers WHERE customer id = '0001';

C : SELECT * FROM customers WHERE customer_ id = 0001;

D : SELECT FROM customers WHERE insert date = '01-JAN-19';

E : SELECT. FROM customers WHERE insert_ date = DATE *2019-01-01';

F : SELECT. FRON customers WE TO DATE (Insert _ date) = DATE ‘2019-01-01’;

Answer: B,D,E

Question 4

Examine this SQL statement:

SELECT cust_id, cus_last_name 'Last Name'

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_nam

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

Options :

A : ORDERBY 2, 1

B : ORDER BY 'CUST_NO'

C : ORDER BY 2,cust_id

D : ORDER BY CUST_NO

E : ORDER BY 'Last Name'

Answer: A,C

Question 5

Examine this statement:

SELECT cust_id, cust^last_ndma "Last Name"

FROM customers

WHERE country_id — 10 UNION

SELECT cust_ID_CUST_NO, cust_last_name

PROM customers

WHERE country__id = 30

Identify three order by clauses, any one of which will complete the query successfully

Options :

A : ORDER BY 2. cust _id

B : ORDER BY 2,

C : ORDER BY "CUST^NO

D : ORDER BY 'Last Name

E : ORDER BY CUST_NO

Answer: A,B,D