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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
