MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To drop a private synonym in another user's schema, you must have which system privilege? |
| A. | DROP SYNONYM |
| B. | DROP ANY SYNONYM |
| C. | DROP PUBLIC SYNONYM |
| D. | All mentioned above |
| Answer» C. DROP PUBLIC SYNONYM | |
| 2. |
Which is a database objects from which multiple users can generate unique integers? |
| A. | Views |
| B. | Sequences |
| C. | Synonyms |
| D. | None of the above |
| Answer» C. Synonyms | |
| 3. |
Which view Shows all columns in all tables and views accessible to the user that are modifiable in the UPDATABLE_COLUMNS VIEWS? |
| A. | DBA_UPDATABLE_COLUMNS |
| B. | ALL_UPDATABLE_COLUMNS |
| C. | USER_UPDATABLE_COLUMNS |
| D. | None of the above |
| Answer» C. USER_UPDATABLE_COLUMNS | |
| 4. |
What are the following guidelines used for?1) Be sure the sequence cache can hold all the sequences used concurrently by your applications2) Increase the number of values for each sequence held in the sequence cache |
| A. | Slow access to all sequence numbers |
| B. | Fast access to all sequence numbers |
| C. | Neutral |
| D. | All mentioned above |
| Answer» C. Neutral | |
| 5. |
Which privilege from the following is used to create a private synonym in another user's schema? |
| A. | CREATE SYNONYM |
| B. | CREATE ANY SYNONYM |
| C. | CREATE PUBLIC SYNONYM |
| D. | None of the above |
| Answer» C. CREATE PUBLIC SYNONYM | |
| 6. |
You cannot use an ALTER VIEW statement to change the definition of a view but you can replace views in which of the following ways? |
| A. | You can drop and recreate the view |
| B. | You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 7. |
What is / are the rules for updatable join views in which rule any INSERT, UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time? |
| A. | UPDATE Rule |
| B. | INSERT Rule |
| C. | DELETE Rule |
| D. | GENERAL Rule |
| Answer» E. | |
| 8. |
A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, what can be used in the following places?1) VALUES clause of INSERT statements2) The SELECT list of a SELECT statement3) The SET clause of an UPDATE statement |
| A. | CURRVAL |
| B. | NEXTVAL |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 9. |
What is a Sequence with each new sequence number that is generated by a reference to the sequence pseudocolumn called? |
| A. | CURRVAL |
| B. | NEXTVAL |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |