AUse the Data Block Wizard and base the relation on a REF pointer.
BIn the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
CUse the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database.
DThis task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file?()
单选题查看答案
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?()
单选题查看答案
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
单选题查看答案
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
单选题查看答案
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
单选题查看答案
What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?()
单选题查看答案
Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature?()
多选题查看答案
As an alternative to setting the Visible property to No for the ORDERS_WINDOW, which built-in could you use to achieve the same result? ()
单选题查看答案
You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
单选题查看答案