网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files?()
A
Oracle Enterprise Manager
B
The V$LOG view
C
The V$LOGFILE view
D
The V$FLASHBACK_DATABASE_LOGS view
参考答案
参考解析
解析:
暂无解析
更多 “单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files?()A Oracle Enterprise ManagerB The V$LOG viewC The V$LOGFILE viewD The V$FLASHBACK_DATABASE_LOGS view” 相关考题
考题
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode, and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature? ()A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.
考题
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.
考题
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?() A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start, and the undo segment will contain the undo data for at least one hour.D、 The database will start, and the undo segment will retain the undo data for at least 15 minutes.
考题
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16?() A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
考题
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
考题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()A、 ZeroB、 One or moreC、 NONED、 DEFAULT
考题
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A、 0B、 1C、 NONED、 DEFAULT
考题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
考题
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file
考题
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A、 redo log filesB、 password fileC、 control fileD、 change tracking file
考题
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace?()A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace
考题
You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility
考题
You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement: SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400; What is the outcome of this statement? ()A、 The statement will not execute successfully.B、 The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.
考题
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A
VERSIONS_STARTSCNB
VERSIONS_STARTTIMEC
VERSIONS_XIDD
VERSIONS_OPERATION
考题
单选题You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A
incomplete recoveryB
complete recoveryC
recovery using the Flashback Database featureD
recovery using the export/import utility
考题
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A
online redo log filesB
alert log filesC
control fileD
datafiles associated with the SYSTEM tablespace
考题
单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A
redo log filesB
password fileC
control fileD
change tracking file
考题
单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace?()A
by using the Flashback Database featureB
by using RMAN incomplete recoveryC
by performing a user-managed incomplete recoveryD
by dropping and re-creating the index tablespace
考题
单选题You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A
Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B
Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C
Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D
Increase the value of the SGA_TARGET initialization parameter.
考题
单选题You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use?()A
LIST commandB
CROSSCHECK commandC
REPORT commandD
SHOW command
考题
单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?()A
The database will not start.B
The database will start but will not retain the undo data in the undo segment.C
The database will start, and the undo segment will contain the undo data for at least one hour.D
The database will start, and the undo segment will retain the undo data for at least 15 minutes.
考题
单选题You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A
0B
1C
NONED
DEFAULT
考题
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16?()A
by using the RMAN utilityB
by using the export/import utilityC
by using the ALTER DATABASE commandD
by enabling the change tracking feature
考题
单选题You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A
DatafilesB
Current control fileC
Server parameter file (spfile)D
Password file
考题
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()A
the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB
the column of the V$INSTANCE_RECOVERY viewC
the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD
the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
考题
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()A
ZeroB
One or moreC
NONED
DEFAULT
热门标签
最新试卷