Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）

A、 It would result in an error because the template cannot be used along with the disk group.

B、 It would result in an error because the path cannot be specified while creating a tablespace in a disk group.

C、 It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.

D、 It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

相关问题推荐

• You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）

  A、 RMAN would use the current operating system location to place the backup.

  B、 RMAN would use the control file of the target database to maintain the backup.

  C、 RMAN would use the recovery catalog of the target database to maintain the backup.

  D、 RMAN would use the control file of the target database to maintain the backup metadata.

  E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

  查看答案

• View the Exhibit and examine the Flashback SCNs.  A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery， you chose 2004343 as the Flashback SCN.  Which two statements are correct in this scenario？（）

  A

  Only the row with DEPARTMENT_ID 290 would be flashed back.

  B

  The rows with DEPARTMENT_ID 290 and 300 would be flashed back.

  C

  The rows with DEPARTMENT_ID 290 and 280 would be flashed back.

  D

  You would have taken the USERS tablespace offline before starting the Flashback Table operation.

  E

  You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.

  查看答案

• Which view will you use to view information regarding the jobs that are currently running in a database？（）

  A、DBA_SCHEDULER_RUNNING_JOBS

  B、DBA_SCHEDULER_JOB_RUN_DETAILS

  C、DBA_SCHEDULER_JOBS

  D、DBA_SCHEDULER_JOB_LOG

  查看答案

• 与语句cout＜＜endl；不等价的是()。

  A．cout＜＜‘’；

  B．cout＜＜‘12’；

  C．cout＜＜‘xA’；

  D．cout＜＜‘’；

  查看答案

• Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  A、mount the new disk group in the ASM instance

  B、restart the ASM instance and the production database instance

  C、register the new disk groups in the production database instance

  D、restart the ASM instance without restarting the production database instance

  E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

  查看答案