Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

A、 You cannot perform the TSPITR with the constraints enabled.

B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.

C、 You can perform TSPITR only on the USERS tablespace.

D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.

E、 The TSPITR will only be successful if the constraint is enabled.

相关问题推荐

• our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

  A、Oracle Net Manager

  B、Listener Control utility

  C、Database Configuration Assistant

  D、Oracle Net Configuration Assistant

  查看答案

• You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）  

  A、 A different procedure is required to restore a database from compressed backups

  B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.

  C、 Using this command to create backups minimizes the bandwidth consumed

  D、 Using this command to create backups improves the performance of the backup process

  查看答案

• Which three elements can a job chain process involve？（）

  A

   an event

  B

   a schedule

  C

   a program

  D

   another chain

  E

   a lightweight job

  查看答案

• You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）  

  A、 Run Segment Advisor

  B、 Run the SQL Tuning Advisor （STA）

  C、 Run the Automatic Workload Repository （AWR） report

  D、 Run the SQL Access Advisor with a hypothetical workload

  查看答案

• How many individual archive-log destination directories are supported by Oracle Database11g?（）

  A、7

  B、1

  C、10

  D、11

  E、21

  查看答案