Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Examine the description of the employees table:

Which query requires explicit data type conversion?

A.

SELECT join_date FROM employees WHERE join_date > '10-02-2018';

B.

SELECT join_date I I ' ' II salary FROM employees;

C.

SELECT SUBSTR

D.

SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

Which three statements are true regarding indexes? (Choose three.)

A.

A UNIQUE index can be altered to be non-unique

B.

A SELECT statement can access one or more indices without accessing any tables

C.

A table belonging to one user can have an index that belongs to a different user

D.

An update to a table can result in updates to any or all of the table’s indexes

E.

When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

F.

An update to a table can result in no updates to any of the table’s indexes