MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 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. |
Which type of table is a group of tables that share the same data blocks because they share common columns and are often used together? |
| A. | Ordinary table |
| B. | Partitioned table |
| C. | Clustered table |
| D. | Index-organized table |
| Answer» D. Index-organized table | |
| 2. |
Which privileges are required for directory objects containing bad, log, or discard files for external tables? |
| A. | READ |
| B. | WRITE |
| C. | READ & WRITE |
| D. | None of the above |
| Answer» C. READ & WRITE | |
| 3. |
In which mode Oracle Database performs full redo logging for instance and media recovery. If the database is in ARCHIVELOG mode, then you can archive redo logs to tape. If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures? |
| A. | Direct-path INSERT without Logging |
| B. | Direct-Path INSERT with Logging |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 4. |
In the error Logging Table format, which set of columns contain data from the row that caused the error and the column names match the column names from the table being inserted into (the "DML table")? |
| A. | Optional set |
| B. | Mandatory set |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Mandatory set | |
| 5. |
Which method enables you to add rows to a table, either by specifying the column values or by specifying a subquery that selects data from another existing table? |
| A. | INSERT statement |
| B. | MERGE statement |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. MERGE statement | |
| 6. |
Which INSERT operation does the database reuses free space in the table, interleaving newly inserted data with the existing data and during such operations, the database also maintains referential integrity constraints? |
| A. | Direct-path INSERT |
| B. | Conventional Insert |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 7. |
In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin? |
| A. | USER_RECYCLEBIN |
| B. | DBA_RECYCLEBIN |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 8. |
Which tables in the Tables schema cannot be redefined? |
| A. | SYS |
| B. | SYSTEM |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |