V$LOG
V$LOFHIST
V$LOGFILE
V$LOG_HISTORY
第1题:
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?()
第2题:
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?()
第3题:
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?()
第4题:
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?()
第5题:
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?()
第6题:
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?()
第7题:
V$DATABASE
V$FLASHBACK_DATABASE_STAT
V$FLASHBACK_DATABASE_LOG
V$RECOVERY_FILE_DEST
第8题:
the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
the column of the V$INSTANCE_RECOVERY view
the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
第9题:
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
第10题:
Query the V$FLASHBACK_DATABASE_LOG view.
Query the V$FLASHBACK_DATABASE_STAT view.
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
Query the V$RECOVERY_FILE_DEST view.
第11题:
V$LOG
V$LOFHIST
V$LOGFILE
V$LOG_HISTORY
第12题:
the V$LOG view
the V$DBFILE view
the V$LOGFILE view
the V$INSTANCE_RECOVERY view
Oracle Enterprise Manager Database Control
第13题:
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?()
第14题:
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?()
第15题:
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?()
第16题:
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()
第17题:
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
第18题:
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? ()
第19题:
V$LOG
V$LOGFILE
DBA_LOG_GROUPS
V$LOG_HISTORY
第20题:
Cancel-based
Recovery using a backup control file
Time-based
Change-based
第21题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第22题:
SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
第23题:
V$SYSSTAT
V$SESSSTAT
V$RSRC_PLAN
V$RSRC_CONSUMER_GROUP
第24题:
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_STAT
V$DATABASE
V$UNDOSTAT