网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 tablespacesB rename the read­only data files to their correct file namesC change the tablespace status from read/write to read­onlyD re­create the read­only tablespace because it is automatically removed” 相关考题
考题 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

考题 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 duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

考题 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 catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database

考题 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 duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

考题 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.

考题 You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()A、SYSTEMB、SYSAUXC、EXAMPLED、UNDOE、TEMPF、USERS

考题 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 tablespaceB、 index tablespaceC、 read-only tablespaceD、 temporary tablespace

考题 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 duplicatedB、The read-only tablespaces in the target database are still defined in new the databaseC、The read-only tablespaces in the target database are changed to online after duplicationD、The data files of the read-only tablespaces in the target database get duplicatedE、The read-only tablespaces in the target database are not defined in the new database

考题 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. 

考题 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 datafileB、Many tablespaces can share one datafileC、One tablespace can have many datafilesD、One datafile can contain many tablespaces

考题 单选题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 datafileB Many tablespaces can share one datafileC One tablespace can have many datafilesD One datafile can contain many tablespaces

考题 多选题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.)AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

考题 多选题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.()AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup

考题 单选题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. 

考题 单选题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 tablespaceB  index tablespaceC  read-only tablespaceD  temporary tablespace

考题 多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS

考题 单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?()A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTERVAL D LOG_CHECKPOINT_TIMEOUT

考题 单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation?()A Shut down the database, restore the two data files and then start up the database. B Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

考题 单选题You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider?()A drop the read­only tablespace and re­create the tablespace after recoveryB take data files from the read­only tablespace offline before performing a recoveryC perform a recovery; status of the tablespace in control file will be changed automaticallyD recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database

考题 单选题Your composition _________beautifully. Is it the one I saw you rite yesterday?A readsB readC is readD was read

考题 单选题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?()A  drop and re-create the read-only tablespacesB  rename the read-only data files to their correct file namesC  change the tablespace status from read/write to read-onlyD  re-create the read-only tablespace because it is automatically removed

考题 多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups.  Which two backups would you be able to perform when the database is being accessed by users?()Abackup of offline tablespacesBbackup of read­only tablespacesCbackup of system­critical tablespacesDbackup of online, locally managed tablespacesEbackup of read/write dictionary­managed tablespaces

考题 多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()ABackup of offline tablespaces.BBackup of read-only tablespaces.CBackup of system-critical tablespaces.DBackup of online, locally managed tablespaces.EBackup of read/write dictionary-managed tablespaces.

考题 多选题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?()AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database

考题 单选题Your boss at Certkiller .com 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.

考题 多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production 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 you want them to be included in backups.  Identify two options for completing this task.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

考题 单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()A Open the database in NORMAL modeB Open the database in read-only modeC Open the database in RESTRICTED modeD Open the database with the RESETLOGS option