题目内容（请给出正确答案）

[主观题]

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of t

he DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“Your database is running in AR…”相关的问题

第1题

Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.The steps to recover the damaged data files are follows:1. Mount the database2. Open the database3. Recover the data file4. Restore the data file5. Make the data file offline6. Make the data file onlineWhich option identifies the correct sequence that you must use to recover the data files?（）

A.2，4，3

B.1，4，3，2

C.2，5，4，3，6

D.5，2，4，3，6

E.1，5，4，3，6，2

点击查看答案

第2题

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure

点击查看答案

第3题

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure

点击查看答案

第4题

Examinethefollowingscenario：-DatabaseisrunninginARCHIVELOGmode.-CompleteconsistentbackupistakeneverySunday.-OnTuesdaytheinstanceterminatesabnormallybecausethediskonwhichcontrolfilesarelocatedgetscorruptedThediskhavingactiveonlineredologfilesisalsocorrupted.Thehardwareisrepairedandthepathsforonlineredologfilesandcontrolfilesarestillvalid.Whichoptionwouldyouusetoperformtherecoveryofdatabasetillthepointoffailure？（）

A.Restorethelatestwholebackup，performcompleterecovery，andopenthedatabasenormally

B.Restorethelatestwholebackup，performincompleterecovery，andopenthedatabasewiththeRESETLOGSoption.

C.Restorethelatestbackupscontrolfile，performcompleterecovery，andopenthedatabasewiththeRESETLOGSoption.

D.Restorethelatestbackupcontrolfile，performincompleterecoveryusingbackupcontrolfile，andopenthedatabasewiththeRESETLOGoption.

点击查看答案

第5题

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED

点击查看答案

第6题

YourdatabaseisrunninginARCHIVELOGmode.Oneofthedatafiles，USERDATA01.dbf，intheUSERStablespaceisdamagedandyouneedtorecoverthefileuntilthepointoffailure.Thebackupforthedatafileisavailable.Whichthreefileswouldbeusedintheuser-managedrecoveryprocessperformedbythedatabaseadministrator（DBA）？（）

A.Redologs

B.Controlfile

C.Thelatestbackupofonlythedamageddatafile

D.ThelatestbackupofallthedatafileintheUSERStablespace

E.Temporaryfilesoftemporarytablespace

F.ArchiveLogssincethelatestbackuptopointoffailure

点击查看答案

第7题

Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted-The disk having active online redo log files is also corrupted.-The hardware is repaired and the paths for online redo log files and control files are still valid.Which option would you use to perform the recovery of database till the point of failure?（）

A. Restore the latest whole backup, perform complete recovery, and open the database normally

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option

点击查看答案

第8题

YourdatabaseisrunninginARCHIVELOGmode.TheSCOTT.EMPtablebelongstotheDATA1tablespace.ThejuniorDBAerroneouslyrunsascriptthatexecutesthefollowingstatement：SQL>DROPTABLESCOTT.EMPPURGE；Afteronehour，youareperformingtheusermanagedincompleterecovery.Whichdatafileswillyourestorefromthelastfullbackup？（）

A.thedatafilesassociatedwiththeSYSTEMtablespace

B.thedatafilesassociatedtotheDATA1tablespace

C.thedatafilesassociatedtotheSYSTEMandDATA1tablespaces

D.allthedatafilesinthedatabase

点击查看答案

第9题

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）

A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.

B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

D. Take the USERDATA tablespace offline in ACCOUNTS_PDb.

点击查看答案

第10题

YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：

01578：ORACLEdatablockcorrupted（file#5，block#51）ORA-01110：datafile5：

’/u01/app/oracle/oradata/orcl/example01.dbf’

Youneedtorectifythecorruptionwhileensuringthefollowing：Thedatafileshouldremainonline.

Themeantimetorecover（MTTR）shouldbeminimal.

Youarenotusingabackupcontrolfile，andallthearchivedlogsareaccessible.

Whichoptionwouldyouchoose？（）

点击查看答案