Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）

A . The command restores only the missing control file. B . The command restores all the control files. C . The command fails because the database is running. D . This is the correct way to address this problem. E . This is not the correct way to address this problem.

时间：2022-11-03 22:37:30 所属题库：1Z0-053题库

相似题目

You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）

A . Event Viewer gives more details on the failure. B . The alert log file gives detailed information about the failure. C . PMON rolls back the transaction and releases the locks. D . SMON rolls back the transaction and releases the locks. E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

查看最佳答案
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

A . log writer B . archival C . process monitor D . system monitor E . change tracking writer F . database writer

查看最佳答案
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

A . only the control file, the current SPFILE, and data files B . only the current SPFILE and data files if autobackup is disabled C . only the data files and the archived redo logs D . the control file, current SPFILE file, data files, and archived redo log

查看最佳答案
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）

A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started.

查看最佳答案
You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct？（）

A . Undo data becomes obsolete after 1，000 seconds. B . Undo data gets refreshed after 1，000 seconds. C . Undo data will be stored permanently after 1，000 seconds. D . Committed undo data would be retained for 1，000 seconds if free undo space is available. E . Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.

查看最佳答案
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?（）

A . They are able to perform only queries. B . They are not affected and continue to function normally. C . They are terminated and the active transactions are rolled back. D . They are not allowed to perform any operations until the listener LISTENER is started

查看最佳答案
Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）

A . backup database B . backup database and archivelogs C . backup database plus archivelogs D . backup database plus archivelog delete input E . backup database and archivelog delete input

查看最佳答案
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）

A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

查看最佳答案
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）

A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

查看最佳答案
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

A . All control files are opened B . All redo files are opened C . The password file is opened D . The parameter file is opened E . All online data files are opened

查看最佳答案
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）

A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started

查看最佳答案
In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？（）

A . Undo data is retained until the next full database backup. B . No committed undo data will be overwritten for 10 minutes. C . Committed undo data will be kept forever if not overwritten within 600 seconds. D . Guarantees that requested undo information are available until the instance is shut down.

查看最佳答案
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

查看最佳答案
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 tablespace

查看最佳答案
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）

A . BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container B . BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container C . BACKUP DATABASE while connected to the PDB1 container D . BACKUP DATABASE while connected to the boot container E . BACKUP PLUGGABLE database PDB1 while connected to PDB2

查看最佳答案
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

查看最佳答案
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

A . Undo data becomes obsolete after 1，000 seconds. B . Undo data gets refreshed after every 1，000 seconds. C . Undo data will be stored permanently after 1，000 seconds. D . Committed undo data would be retained for 1，000 seconds if free undo space is available. E . Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

查看最佳答案
You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）

A . USER_DUMP_DEST B . CORE_DUMP_DEST C . TRACE_DUMP_DEST D . BACKUP_DUMP_DEST E . BACKGROUND_DUMP_DEST

查看最佳答案
Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified？（）

A . only the control file， the current SPFILE， and data files B . only the current SPFILE and data files if autobackup is disabled C . only the data files and the archived redo logs D . the control file，current SPFILE file，data files，and archived redo log

查看最佳答案
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

查看最佳答案
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）

A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

查看最佳答案
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

A . configure the database to run in ARCHIVELOG mode B . configure the Flash Recovery Area to enable automatic database backup C . schedule the database backup using DBMS_JOB package after creating the database D . schedule the database backup using Recovery Manager （RMAN）commands after creating the database E . schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

查看最佳答案
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

A . User process B . Server process C . System Monitor (SMON) D . Process Monitor (PMON) E . Checkpoint process (CKPT)

查看最佳答案
Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use？（）

A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB) B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60) C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘ D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE

查看最佳答案

推荐题目