单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group?()AV$LOGBV$LOFHISTCV$LOGFILEDV$LOG_HISTORY
单选题
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
A
V$LOG
B
V$LOFHIST
C
V$LOGFILE
D
V$LOG_HISTORY
参考解析
解析:
暂无解析
相关考题:
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?()A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG
Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers?()A.V$LOGB.V$LOGFILEC.DBA_LOG_GROUPSD.V$LOG_HISTORY
WhichofthefollowingdynamicviewwouldyouquerytoidentifytheonlineCURRENTredologgroup?() A.V$LOGB.V$LOFHISTC.V$LOGFILED.V$LOG_HISTORY
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()A、ALTER DATABASE DROP LOGFILE GROUP 1;B、ALTER DATABASE CLEAR LOGFILE GROUP 1;C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager (RMAN) to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups?() A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
You executed the following command to start the database: SQL STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205: error in identifying controlfile, check alert log for more info Which view would you query at this stage to investigate this missing control file?()A、V$INSTANCEB、V$CONTROLFILEC、DBA_CONTROL_FILESD、V$DATABASE_PROPERTIESE、V$CONTROLFILE_RECORD_SECTION
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()A、the V$LOG viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control
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
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()A、V$COPY_CORRUPTB、V$COPY_CORRUPTIONC、V$BACKUP_CORRUPTD、V$BACKUP_CORRUPTION
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()A、V$LOGB、V$LOFHISTC、V$LOGFILED、V$LOG_HISTORY
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()A、 SQLALTER DATABASE DROP LOGFILE GROUP 1;B、 SQLALTER DATABASE CLEAR LOGFILE GROUP 1;C、 SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D、 SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
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 are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()A V$DATABASEB V$FLASHBACK_DATABASE_STATC V$FLASHBACK_DATABASE_LOGD V$RECOVERY_FILE_DEST
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members?()A V$LOGB V$LOGFILEC DBA_LOG_GROUPSD V$LOG_HISTORY
单选题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
单选题As a result of a media failure, the current online redo log group is corrupted. The database crashes, as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform? ()ACancel-basedBRecovery using a backup control fileCTime-basedDChange-based
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()AALTER DATABASE DROP LOGFILE GROUP 1;BALTER DATABASE CLEAR LOGFILE GROUP 1;CALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;DALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
单选题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 required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A Query the V$FLASHBACK_DATABASE_LOG view.B Query the V$FLASHBACK_DATABASE_STAT view.C Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D Query the V$RECOVERY_FILE_DEST view.
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()A SQLALTER DATABASE DROP LOGFILE GROUP 1;B SQLALTER DATABASE CLEAR LOGFILE GROUP 1;C SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group?()AV$LOGBV$LOFHISTCV$LOGFILEDV$LOG_HISTORY
单选题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups?()A V$SYSSTATB V$SESSSTATC V$RSRC_PLAND V$RSRC_CONSUMER_GROUP
多选题In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT