V$SESSION
V$SYSSTAT
DBA_SEGMENTS
V$SORT_USAGE
第1题:
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?()
第2题:
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?()
第3题:
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?()
第4题:
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?()
第5题:
What view might you use to try to determine how long a particular backup will take?()
第6题:
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
第7题:
V$DATABASE
DBA_TABLES
SYSAUD$
EMP
第8题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第9题:
V$SESSION_EVENT
V$SESSION
V$WAITS
V$WAITSTAT
V$SESSION_LONGOPS
第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题:
the V$LOG view
the V$DBFILE view
the V$LOGFILE view
the V$INSTANCE_RECOVERY view
Oracle Enterprise Manager Database Control
第12题:
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_STAT
V$DATABASE
V$UNDOSTAT
第13题:
What view might you use to try to determine how long a particular backup will take?()
第14题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第15题:
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
第16题:
From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()
第17题:
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()
第18题:
V$DATABASE
V$FLASHBACK_DATABASE_STAT
V$FLASHBACK_DATABASE_LOG
V$RECOVERY_FILE_DEST
第19题:
Enable Flashback Data Archive for the tables.
Specify undo retention guarantee for the database.
Enable supplemental logging for the database.
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
Create Flashback Data Archive on the tablespace on which the tables are stored.
第20题:
set the CPU time per call in the users profile
set the CPU time per session in the users profiles
set the CPU levels for the users’ group using Resource Manager
set the TIMED_STATISTICS parameter to TRUE in the parameter file
第21题:
V$DATABASE
V$UNDOSTAT
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_STAT
第22题:
V$SYSSTAT
V$SESSSTAT
V$RSRC_PLAN
V$RSRC_CONSUMER_GROUP
第23题:
SYSTEM
OUTLN
INTERNAL
SYS