AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-047





Question ID 6431

Which statements are correct regarding indexes? (Choose all that apply.)

Option A

When a table is dropped, the corresponding indexes are automatically dropped

Option B

For each DML operation performed, the corresponding indexes are automatically updated.

Option C

Indexes should be created on columns that are frequently referenced as part of an expression.

Option D

A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.

Correct Answer ABD
Explanation


Question ID 6432

User OE, the owner of the ORDERS table, issues the following command: GRANT SELECT ,INSERT ON orders TO hr WITH GRANT OPTION; The user HR issues the following command: GRANT SELECT ON oe.orders TO scott; Then, OE issues the following command: REVOKE ALL ON orders FROM hr; Which statement is correct?

Option A

The user SCOTT loses the privilege to select rows from OE.ORDERS

Option B

The user SCOTT retains the privilege to select rows from OE.ORDERS.

Option C

The REVOKE statement generates an error because OE has to first revoke the SELECT privilege from SCOTT.

Option D

The REVOKE statement generates an error because the ALL keyword cannot be used for privileges that have been granted using WITH GRANT OPTION.

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!