View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

A

 all the data files belonging to the USERS tablespace

B

 password file

C

 online redo log files

D

 the current control file

E

 archived redo log files

F

 the current server parameter file

G

 data files belonging to the USERS tablespace and all the default tablespaces

相关问题推荐

• Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

  A

  The database opens normally.

  B

  The database prompts for a database recovery.

  C

  The database writer writes to a trace file， indicating that the temporary file is not found.

  D

  The database gets mounted and throws an error indicating that the temporary file requires recovery.

  查看答案

• 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

  查看答案

• 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.

  查看答案

• In which scenario will you create a sorted hash cluster？ （）

  A、 if the application uses queries joining tables only occasionally

  B、 if the full table scan is executed often on only one table of the clustered tables

  C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

  D、 when you want the data to be returned automatically in the chronological order

  查看答案

• The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

  A、 time-based recovery

  B、 log sequence recovery

  C、 cancel-based recovery

  D、 change-based recovery

  查看答案