网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）
A
V$DATAFILE
B
V$TEMPFILE
C
V$DBFILE
D
V$DATAFILE_HEADER
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A V$DATAFILEB V$TEMPFILEC V$DBFILED V$DATAFILE_HEADER” 相关考题
考题
WhichdynamicperformanceviewdisplaystheinformationaboutthefilesassociatedwiththelocallymanagedtemporarytablespacesinOracle9i?()
A.V$DATAFILEB.V$TEMPFILEC.V$DBFILED.V$DATAFILE_HEADER
考题
Whichdatadictionaryviewsdisplaystheerrorinformationrelatedtoadatafile,whenaninternalreadfailsonthatfile?()
A.V$DATAFILEB.V$DATAFILE_HEADERC.DBA_DATA_FILESD.V$DBFILEE.V$DATAFILE_ERRORS
考题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.
考题
Which of the following versions of AIX provide both multi-path I/O and dynamic LPAR？（）A、AIX V5.2B、AIX V4.2C、AIX V4.3D、AIX V5.1
考题
Which command is used to list information about each physical volume in volume group testvg？（）A、lsvg -p testvgB、lspv -v testvgC、lslv -l testvgD、lsattr -v testvg
考题
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 are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
考题
Which statement regarding the contents of the V$PARAMETER view is true？（）A、displays only the list of default valuesB、displays only the list of all basic parametersC、displays the currently in effect parameter valuesD、displays only the list of all advanced parametersE、displays the list of all the parameter files of a database
考题
Which view provides information on the backup status of the datafiles in the database？（） A、 V$BACKUPB、 V$BACKUP_STATUSC、 V$BACKUP_DATAFILED、 V$DATAFILE_BACKUPE、 V$TABLESPCE_BACKUP
考题
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
考题
These are the details about V$FLASHBACK_DATABASE_STAT： SQL DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）A、BEGIN_TIME is the time at which Flashback logging is enabled.B、END_TIME is the time at which the query is executed on the view.C、REDO_DATA is the number of bytes of redo data written during the interval.D、This view contains information about flashback data pertaining to the last 24 hours.E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
考题
Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）A、V$DATAFILEB、V$DATAFILE_HEADERC、DBA_DATA_FILESD、V$DBFILEE、V$DATAFILE_ERRORS
考题
Which view provides information on the backup status of the datafiles in the database?（）A、V$BACKUPB、V$BACKUP_STATUS C、V$BACKUP_DATAFILE D、V$DATAFILE_BACKUP E、V$TABLESPCE_BACKUP
考题
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（） A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
考题
Which dynamic view displays the status of block-change tracking?（）A、V$BLOCK_CHANGE B、V$BLOCK_CHANGE_TRACKING C、V$BLOCKCHANGE D、V$BLOCK_TRACKING
考题
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.
考题
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?（）A、V_CONTROLFILE_RECORD_SECTION B、V_CONTROLFILE C、V$PARAMETER D、init.ora file
考题
Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A、V$DATAFILEB、V$TEMPFILEC、V$DBFILED、V$DATAFILE_HEADER
考题
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
考题
单选题Which view provides information on the backup status of the datafiles in the database？（）A
V$BACKUPB
V$BACKUP_STATUSC
V$BACKUP_DATAFILED
V$DATAFILE_BACKUPE
V$TABLESPCE_BACKUP
考题
单选题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
考题
单选题Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A
V$DATAFILEB
V$TEMPFILEC
V$DBFILED
V$DATAFILE_HEADER
考题
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A
The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB
The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC
The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD
The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
考题
单选题Which command is used to list information about each physical volume in volume group testvg？（）A
lsvg -p testvgB
lspv -v testvgC
lslv -l testvgD
lsattr -v testvg
考题
单选题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.
考题
单选题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
考题
单选题Which of the following versions of AIX provide both multi-path I/O and dynamic LPAR？（）A
AIX V5.2B
AIX V4.2C
AIX V4.3D
AIX V5.1
考题
单选题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A
V$BACKUP_CORRUPTIONB
V$COPY_CORRUPTIONC
V$DATABASE_BLOCK_CORRUPTIOND
RC_BACKUP_CORRUPTION
热门标签
最新试卷