> > Oracle MCQs > Managing Tables MCQs

Managing Tables MCQ

1. 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?

INSERT statement

MERGE statement

MERGE statement And INSERT statement

None

Answer

Correct Answer: INSERT statement

Note: This Question is unanswered, help us to find answer for this one

2. 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?

Index-organized table

Ordinary table

Partitioned table

Clustered table

Answer

Correct Answer: Clustered table

Note: This Question is unanswered, help us to find answer for this one

3. 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?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

4. If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

5. In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?

None

DBA_RECYCLEBIN

USER_RECYCLEBIN And DBA_RECYCLEBIN

USER_RECYCLEBIN

Answer

Correct Answer: DBA_RECYCLEBIN

Note: This Question is unanswered, help us to find answer for this one

6. For external tables which privileges are required for directory objects containing bad, log, or discard files?

Write

READ

None

READ And WRITE

Answer

Correct Answer: Write

Note: This Question is unanswered, help us to find answer for this one

7. The NOLOGGING clause causes minimal redo information to be generated during the table creation this has which of the benefits?

Performance does not improves for parallel creation of large tables

None

Space is not saved in the redo log files

The time it takes to create the table is increased

Answer

Correct Answer: None

Note: This Question is unanswered, help us to find answer for this one

8. All data in a database is stored in a table to include user data and the Data Dictionary?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

9. 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?

Conventional Insert

None

Direct-path INSERT

Conventional Insert And Direct-path INSERT

Answer

Correct Answer: Conventional Insert

Note: This Question is unanswered, help us to find answer for this one

10. 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?

False

True

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs