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

题目内容 (请给出正确答案)
单选题
You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()
A

Image of the control file

B

Location of the control file

C

Contents of the control file in text format

D

SQL command to re-create the database

E

SQL command to re-create the control file

F

Contents of the control file in binary format


参考答案

参考解析
解析: 暂无解析
更多 “单选题You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()A Image of the control fileB Location of the control fileC Contents of the control file in text formatD SQL command to re-create the databaseE SQL command to re-create the control fileF Contents of the control file in binary format” 相关考题
考题 Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?() A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion

考题 View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

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

考题 You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN REPORT NEED BACKUP days 3;What would be the output of this command?()A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days

考题 In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

考题 You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format

考题 What RMAN command must you use before you can back up a database using the recovery catalog?()A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

考题 You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files, after you lost all the control files in your database

考题 You executed the following command in Recovery Manager (RMAN): RMAN RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD、set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

考题 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_DESTB、CORE_DUMP_DESTC、TRACE_DUMP_DESTD、BACKUP_DUMP_DESTE、BACKGROUND_DUMP_DEST

考题 You performed a backup of the flash recovery area by using the following command for the first time: RMAN BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up?()A、flashback logsB、current control fileC、control file autobackupsD、incremental backup sets

考题 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 tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces

考题 You create a mobile Web application. You need to use a Command control to post user input from the UI elements back to the server. What are two possible ways to achieve this goal?()A、Place the Command control within an instance of the System.Web.UI.MobileControls.SelectionList control.B、Place the Command control within an instance of the System.Web.UI.MobileControls.ObjectList control.C、Place the Command control within an instance of the System.Web.UI.MobileControls.Form control.D、Place the Command control within an instance of the System.Web.UI.MobileControls.Panel control.

考题 You are the network administrator for your company. The network consists of a single Active Directory domain. All domain controllers run Windows Server 2003, and each one has a locally attached tape device. You need to back up each domain controller. Your backup process must fulfill the following requirements: System recovery must be possible in the event of server failure. The system configuration and all current dynamic disk configurations must be backed up. Other data partitions do not need to be backed up. What should you do?()A、Use the Backup utility to back up the system files and to create an Automated System Recovery (ASR) disk.B、Use the Backup utility to back up the contents of all mounted drives.C、Use the Backup utility to back up only the System State data.D、Use the Copy command to copy C:/windows and its subfolders to a shared folder on the network.E、Use the Xcopy command to copy C:/windows and its subfolders to a shared folder on the network.

考题 多选题You performed a backup of the flash recovery area by using the following command for the first time: RMAN BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up?()Aflashback logsBcurrent control fileCcontrol file autobackupsDincremental backup sets

考题 多选题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?()AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.

考题 单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A renaming the control filesB dropping a user in your databaseC enabling or disabling redo log archivingD dropping a tablespace in your databaseE re-creating the control files, after you lost all the control files in your database

考题 单选题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_DESTB CORE_DUMP_DESTC TRACE_DUMP_DESTD BACKUP_DUMP_DESTE BACKGROUND_DUMP_DEST

考题 多选题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? ()Aall the data files belonging to the USERS tablespaceBpassword fileConline redo log filesDthe current control fileEarchived redo log filesFthe current server parameter fileGdata files belonging to the USERS tablespace and all the default tablespaces

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A  back up the control file to traceB  bring database to the MOUNT stateC  open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD  set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()A Because row IDs may change during the flashback operationB Because the object number changes after the flashback operationC Because the rows are retrieved from the recycle bin during the flashback operationD Because the table is moved forward and back to a temporary during the flashback operation

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

考题 单选题Before a Flashback Table operation,you execute the following command:   ALTER TABLE employees ENABLE ROW MOVEMENT;   Why would you need this to be executed?()A  Because row IDs may change during the flashback operationB  Because the object number changes after the flashback operationC  Because the rows are retrieved from the recycle bin during the flashback operationD  Because the table is moved forward and back to a temporary during the flashback opertion

考题 单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace:   RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M;  Which statement is true about executing this command?()A  The command generates an error.B  The command backs up the tablespace and creates a backup set of size 200 MBC  The command backs up the tablespace and creates two backup sets of size 100 MB each.D  The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.