Chat with us

Read online free dumps for Oracle- 1z0-047

Here you can read online questions and answers for Oracle Exam 1z0-047 (Oracle Database SQL Expert ) 100% free...

Question ID 6377

Evaluate the CREATE TABLE statement:

Option A

. It would be created only if a unique index is manually created first

Option B

. It would be created and would use an automatically created unique index.

Option C

It would be created and would use an automatically created nonunique index

Option D

. It would be created and remains in a disabled state because no index is specified in the command.

Correct Answer B
Description
Update Date and Time 2017-06-09 09:48:10

Question ID 6379

Which two statements are true? (Choose two.)

Option A

. The USER_SYNONYMS view can provide information about private synonyms

Option B

The user SYSTEM owns all the base tables and user-accessible views of the data dictionary

Option C

All the dynamic performance views prefixed with V$ are accessible to all the database users

Option D

. The USER_OBJECTS view can provide information about the tables and views created by the user only.

Option E

. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

Correct Answer AE
Description
Update Date and Time 2017-06-09 09:50:39