CMS专题

单选题One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）A drop and re­c

题目
单选题
One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）
A

drop and re­create the read­only tablespaces

B

rename the read­only data files to their correct file names

C

change the tablespace status from read/write to read­only

D

re­create the read­only tablespace because it is automatically removed

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database


参考答案：C, D

第2题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  • A、The database is in mount state.
  • B、One of the tablespaces is offline.
  • C、One of the tablespaces is read only.
  • D、The database operates in ARCHIEVELOG mode. 
  • E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第3题：

You are managing a 24*7 database. The backup strategy for the database is to perform user－managed backups. Identify two prerequisites to perform the backups.()

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup


参考答案：B, C

第4题：

What does it mean if a backup is expired?（）

  • A、The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. 
  • B、The backup set has one or more invalid blocks in it and is not usable for recovery. 
  • C、The backup set contains one or more tablespaces no longer in the database.  
  • D、The backup set contains one or more missing backup set pieces.
  • E、The backup set is from a previous version of RMAN and was not upgraded. 

正确答案:D

第5题：

Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

  • A、 undo tablespace
  • B、 index tablespace
  • C、 read-only tablespace
  • D、 temporary tablespace

正确答案:D

第6题：

Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database


参考答案：A, B

第7题：

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）

  • A、SYSTEM
  • B、SYSAUX
  • C、EXAMPLE
  • D、UNDO
  • E、TEMP
  • F、USERS

正确答案:A,B,E

第8题：

Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database


参考答案：A, B

第9题：

Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

  • A、The data files of the read-only tablespaces in the target database are not duplicated
  • B、The read-only tablespaces in the target database are still defined in new the database
  • C、The read-only tablespaces in the target database are changed to online after duplication
  • D、The data files of the read-only tablespaces in the target database get duplicated
  • E、The read-only tablespaces in the target database are not defined in the new database

正确答案:A,B

第10题：

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

  • A、One tablespace has only one datafile
  • B、Many tablespaces can share one datafile
  • C、One tablespace can have many datafiles
  • D、One datafile can contain many tablespaces

正确答案:C

更多相关问题
相关内容