Which three data components are needed for point-in-time recovery?（）A、The error logB、The backup logC、The general query logD、Binary logsE、The data backupF、Configuration files
Which three data components are needed for point-in-time recovery?（）
- A、The error log
- B、The backup log
- C、The general query log
- D、Binary logs
- E、The data backup
- F、Configuration files
相关考题：
Which options must you configure while performing an automated Tablespace Point－in－Time Recovery (TSPITR) by using Recovery Manager (RMAN)?() A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Auxiliary destinations for an auxiliary set of data files
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 logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure
Which three data components are needed for point－in－time recovery?() A.The error logB.The backup logC.The general query logD.Binary logsE.The data backupF.Configuration files
A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true（）。A.The General Query Log records more data than the Binary LogB.The binary Log records more data than the General Query LogC.The Slow Query Log records more data than the General Query LogD.The General Query Log records more data than the Slow Query LogE.The Slow Query Log records more data than the Binary LogF.The Binary Log records more data than the Slow Query Log
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 logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure
The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）A、data filesB、backup setsC、control filesD、archived redo log files
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 logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure
What is the default local location for syslog and trace files?（）A、/logB、/home/logC、/var/logD、/etc/log
A system administrator had a disk failure on an HMC. The disk was replaced and the HMC was loaded from the Product Recovery CD. The system administrator had performed a backup to DVD of the HMC data before the system failed. After restoring the backup files, it was noticed that no profile files were restored. What is the most likely cause of this problem?（）A、The profile data was not initialized after restoring the backup CDB、The profile data was not backed up before doing the Critical Console Data backupC、A Critical Console Data backup was performed which backs up user data， but not profile dataD、A Save Upgrade data was done instead of a backup Critical Console Data and the profile files were not included
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 logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.
Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。A、The General Query Log records more data than the Binary LogB、The binary Log records more data than the General Query LogC、The Slow Query Log records more data than the General Query LogD、The General Query Log records more data than the Slow Query LogE、The Slow Query Log records more data than the Binary LogF、The Binary Log records more data than the Slow Query Log
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）A、Only the data files.B、Only the data files and the online logs.C、The data files， control files， and the online logs.D、The data files and control files， but not the online logs.
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）A、Complete Recovery with online redo logB、Complete Recovery with archived redo logC、Tablespace Point-in-Time Recovery (TSPITR)D、Incomplete Recovery with system change number (SCN)
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）A、New channels for restore and recovery tasksB、New name for the data files of the tablespaceC、Auxiliary name for the data files of the tablespaceD、Auxiliary destinations for an auxiliary set of data files
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）A、Restore the data file and perform incomplete recovery.B、Restore the data file and perform point-in-time recover.C、Drop the tablespace and lose all data in the tablespace.D、Restore the database and lose all data since the last backup.
Which step is required for recover from an instance failure？ （）A、Start up only.B、Restore needed data files， then start up.C、Complete restore from backup， then start up.D、Perform point in time recovery， then start up.
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 filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs
Data files of which three tablespaces can be recovered by performing an open recovery？（）A、TEMPB、UNDOC、INDEXD、SYSAUXE、SYSTEM
多选题Data files of which three tablespaces can be recovered by performing an open recovery？（）ATEMPBUNDOCINDEXDSYSAUXESYSTEM
多选题A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。AThe General Query Log records more data than the Binary LogBThe binary Log records more data than the General Query LogCThe Slow Query Log records more data than the General Query LogDThe General Query Log records more data than the Slow Query LogEThe Slow Query Log records more data than the Binary LogFThe Binary Log records more data than the Slow Query Log
单选题You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）AOnly the data files.BOnly the data files and the online logs.CThe data files， control files， and the online logs.DThe data files and control files， but not the online logs.
单选题A system administrator had a disk failure on an HMC. The disk was replaced and the HMC was loaded from the Product Recovery CD. The system administrator had performed a backup to DVD of the HMC data before the system failed. After restoring the backup files, it was noticed that no profile files were restored. What is the most likely cause of this problem?（）AThe profile data was not initialized after restoring the backup CDBThe profile data was not backed up before doing the Critical Console Data backupCA Critical Console Data backup was performed which backs up user data， but not profile dataDA Save Upgrade data was done instead of a backup Critical Console Data and the profile files were not included
多选题Which three data components are needed for point-in-time recovery?（）AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files
单选题In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）A Complete Recovery with online redo logB Complete Recovery with archived redo logC Tablespace Point-in-Time Recovery （TSPITR）D Incomplete Recovery with system change number （SCN）
多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace