READ Free Dumps For Oracle- 1z0-047
| 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 |
| 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 |