多选题When a check point occurs the (). (). and () are synchronized.Adata filesBcontrol filesCredo log filesDparameter filesEarchive log files

多选题
When a check point occurs the (). (). and () are synchronized.
A

data files

B

control files

C

redo log files

D

parameter files

E

archive log files


参考解析

解析: 暂无解析

相关考题:

You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?() A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

When a check point occurs the (). (). and () are synchronized.A、data filesB、control filesC、redo log filesD、parameter filesE、archive log files

The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring instance recovery()A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files

Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

When a problem occurs in an HACMP cluster,which log file will show the high level overview of the cluster operation?()  A、 /tmp/hacmp.outB、 /tmp/clstrmgr.debugC、 /usr/es/adm/cluster.logD、 /var/hacrmp/clverify/clverify.log

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format?() A、to uniquely identify the archived log files with the restore operationB、to uniquely identify the archived log files with the redo log group numberC、to uniquely identify the archived log files for each incarnation of the databaseD、to uniquely identify the archived log files with the number of recovery operations performed

You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance?()A、Increase the size of redo log filesB、Increase the size of redo log bufferC、Increase the number of redo log filesD、Place the redo log files on a separate diskE、Decrease the number of redo log groups to twoF、Increate the number Log Writer (LGWR) process

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()  A、the value of the UNDO_RETENTION initialization parameterB、the value of the optimal redo log file size provided by the Redo Logfile Size AdvisorC、the online redo log files sizeD、the number of redo log members in a group

The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.

Examine the command:   ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;   What does the command accomplish?()A、Creates an additional copy of the database online redo log files. B、Stores the primary key column values of each row involved in a DML operation in the online redo log files. C、Stores the primary key column values of each row involved in a DML operation in the supplemental log files. D、Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.

You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A、 The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B、 Before the instance starts, you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true? ()A、Transactions are rolled back using redo log files.B、Transactions are rolled forward using redo log files.C、Transactions are rolled back using redo log files and archived log files.D、Transactions are rolled forward using redo log files and rolled back using redo log files.

In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()A、 when all the online redo log groups are multiplexed and one of the members of a group is missingB、 when all the online redo log groups are not multiplexed and one log group is missingC、 when all the control files are missingD、 when some important tables are deleted from the database and purged from the Recycle Bin

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?()A、On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.B、On SQL1,change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.C、On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.D、On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.

多选题An administrator receives an error when attempting to execute a WebSphere Commerce command and decides to take the following steps to troubleshoot the problem:   Check to see if the request was processed by the WebSphere plug-in but was never received by the WebSphere Application Server  Check for Java errors from EJBs and servlets  Trace WebSphere Commerce Server subsystems and commands  Which of the following files should the administrator check to accomplish these steps?()Aerror.logBtrace.logChttp_plugin.logDservlet.logESystemOut.log

单选题You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A The archived redo log files will be overwritten.B The archived redo log files are deleted automatically.C The archived redo log files should be moved to some other location.D The archived redo log files are still maintained because the file names are unique.

多选题You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance?()AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer (LGWR) process

单选题Which of the following files cannot be cataloged using the CATALOG command?()AData filesBControl filesCArchived log filesDFiles storing RMAN scripts

多选题Which three statements are true about the stages of database startup?()AData files and redo log files can be renamed at the MOUNT stage.BControl files are read at the OPEN stage for the location of data files.CControl files are required to bring the database to the NOMOUNT stage.DData files and redo log files are made available to users at the OPEN stage.EData files and online redo log files are checked for consistency while opening the database

单选题You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B Before the instance starts, you receive an error about the missing redo log files of a group.C The instance starts and the database opens with an error message written to the alert log file.D The instance starts and the database opens because two redo log groups still exist.E The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

多选题On which three can you use Recovery Manager (RMAN) to perform incremental backup?()Adata filesBcontrol filesCtablespacesDpassword fileEparameter fileFwhole databaseGflashback log fileHarchived log filesIchange tracking file

多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file

多选题Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()AData filesBControl filesCParameter fileDOnline redo log filesEServer parameter file

单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()A when all the online redo log groups are multiplexed and one of the members of a group is missingB when all the online redo log groups are not multiplexed and one log group is missingC when all the control files are missingD when some important tables are deleted from the database and purged from the Recycle Bin

单选题You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()Athe value of the UNDO_RETENTION initialization parameterBthe value of the optimal redo log file size provided by the Redo Logfile Size AdvisorCthe online redo log files sizeDthe number of redo log members in a group

单选题You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format?()Ato uniquely identify the archived log files with the restore operationBto uniquely identify the archived log files with the redo log group numberCto uniquely identify the archived log files for each incarnation of the databaseDto uniquely identify the archived log files with the number of recovery operations performed