单选题You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）A The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.B The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.C The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.D The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
单选题
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）
A
The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
B
The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
C
The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
D
The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
参考解析
解析：
暂无解析
相关考题：
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）A. 1,6,5,4,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；
You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）A、The command must be issued in MOUNT state.B、The command succeeds only if the data file is offline.C、The command must be issued when the database is in the archivelog mode.D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued
After the recovery is complete， which command should you execute？（）A、ALTER DATABASE OPEN；B、ALTER DATABASE CLEAR LOGFILE；C、ALTER DATABASE OPEN RESETLOGS；D、ALTER DATABASE OPEN NORESETLOGS；
You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
What command would you issue to enable automated backups of control files? （）A、alter database controlfile autobacku onB、alter system controlfile autobackup on C、configure controlfile autobackup on D、enable controlfile autobackup
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）A、You should perform a log switchB、You should make a backup of the databaseC、You should switch the database to the NONARCHIVELOG modeD、You should shut down the database instance and perform a complete database recovery
Identify three valid methods of opening, pluggable databases (PDBs).（）A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootB、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbC、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seedD、ALTER DATABASE PDB OPEN issued from the rootE、ALTER DATABASE OPEN issued from that pdbF、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbG、ALTER PLUGGABLE DATABASE OPEN issued from that pdb
You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（） A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
Which is the correct command to put the database in ARCHIVELOG mode？（） A、 alter database archivelogB、 alter system enable archivelog modeC、 alter database enable archiveD、 alter database archivelog enableE、 None of the above
多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery
单选题You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）AThe command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B The command will not execute successfully because resumable space allocation is enabled at the session level.C The command will execute successfully and resumable space will be allocated at the session level.D The command will execute successfully and resumable space will be allocated at the instance level.
多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
单选题What command would you issue to enable automated backups of control files？（）A alter database controlfile autobackup onB alter system controlfile autobackup onC configure controlfile autobackup onD enable controlfile autobackup
单选题Which is the correct command to put the database in ARCHIVELOG mode？（）A alter database archivelogB alter system enable archivelog modeC alter database enable archiveD alter database archivelog enableE None of the above
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（）A You should perform a log switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery
单选题You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）AThe command must be issued in MOUNT state.BThe command succeeds only if the data file is offline.CThe command must be issued when the database is in the archivelog mode.DThe command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
单选题You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature？（）A ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging
多选题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？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
单选题You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（）A ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；B ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；C ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；D ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；