Managing Tables MCQs
Managing Tables MCQs
These Managing Tables multiple-choice questions and their answers will help you strengthen your grip on the subject of Managing Tables. You can prepare for an upcoming exam or job interview with these Managing Tables MCQs.
So scroll down and start answering.
1: Oracle Database provides a mechanism to make table structure modifications with significantly affecting the availability of the table. The mechanism is called online table redefinition?
A. False
B. True
2: In which INSERT operation the database reuses free space in the table, interleaving newly inserted data with existing data. During such operations, the database also maintains referential integrity constraints?
A. Conventional Insert
B. None
C. Direct-path INSERT
D. Conventional Insert And Direct-path INSERT
3: All data in a database is stored in a table to include user data and the Data Dictionary?
A. True
B. False
4: The NOLOGGING clause causes minimal redo information to be generated during the table creation this has which of the benefits?
A. Performance does not improves for parallel creation of large tables
B. None
C. Space is not saved in the redo log files
D. The time it takes to create the table is increased
5: For external tables which privileges are required for directory objects containing bad, log, or discard files?
A. Write
B. READ
C. None
D. READ And WRITE
6: In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?
A. None
B. DBA_RECYCLEBIN
C. USER_RECYCLEBIN And DBA_RECYCLEBIN
D. USER_RECYCLEBIN
7: If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail?
A. False
B. True
8: A Synonym is another name for an object. It is used to simplify access to objects such as tables owned by another user or to shorten lengthy object name?
A. True
B. False
9: 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. Index-organized table
B. Ordinary table
C. Partitioned table
D. Clustered table
10: 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. MERGE statement And INSERT statement
D. None
List of Managing Tables MCQs M...
Available in:
Managing Tables MCQs
