网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 three statements about dynamic filtering are true? ()
A. Dynamic filtering creates a query statement.B. Dynamic filtering has an option to save query.C. Dynamic filtering can select any log field to filter.D. Dynamic filtering permanently removes other log entries.E. Dynamic filtering redraws the log when you select a variable link.
考题
Which of the following devices would allow a technician using a packet sniffer to view all the dataon a network?()
A.GBICB.HubC.BridgeD.Modem
考题
Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?()
A. enable cdpB. cdp enableC. cdp runD. run cdp
考题
Which of the following statements best describes Flashback Versions Query？（） A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
考题
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?（）A、enable cdpB、cdp enableC、cdp runD、run cdp
考题
Which of the following devices would allow a technician using a packet sniffer to view all the dataon a network?（）A、GBICB、HubC、BridgeD、Modem
考题
Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control
考题
Which three statements about dynamic filtering are true? （）A、Dynamic filtering creates a query statement.B、Dynamic filtering has an option to save query.C、Dynamic filtering can select any log field to filter.D、Dynamic filtering permanently removes other log entries.E、Dynamic filtering redraws the log when you select a variable link.
考题
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）A、The optimizer used a dynamic plan for the query.B、The optimizer chose different plans because automatic dynamic sampling was enabled.C、The optimizer used re-optimization cardinality feedback for the query.D、The optimizer chose different plan because extended statistics were created for the columns used.
考题
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
考题
You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）A、use enterprise managerB、use DBMS_SQL packageC、use DBMS_AWR packageD、use PRVT_WORKLOAD packageE、query the AWR snapshot repository objectsF、use DBMS_WORKLOAD_REPOSITORY package
考题
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）A、 To recover a dropped table.B、 To recover a dropped schema.C、 To recover data from a truncated table.D、 To view changes made by all the transactions during a given period of time.E、 To view changes made by a single transaction during a given period of time.
考题
You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
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 executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（） A、It would return information regarding only the last committed transaction.B、It would return only the active transactions in all the undo segments in the database.C、It would return only the committed transactions in all the undo segments in the database.D、It would return both active and committed transactions in all the undo segments in the database.E、It would return information regarding the transactions that began and were committed in the last 30 minutes.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time. So in the options below, which dynamic management view should you choose to use?（） A、sys.dm_os_wait_stats B、sys.dm_exec_requests C、sys.dm_exec_sessions D、sys.dm_exec_query_stats
考题
单选题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
考题
多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.
考题
单选题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
考题
单选题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 manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）A
sys.dm fts index populationB
sys.dm exec query statsC
sys. dm db index usage statsD
sys.dm db index physical stats
考题
单选题You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
考题
单选题You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）A
It would return information regarding only the last committed transaction.B
It would return only the active transactions in all the undo segments in the database.C
It would return only the committed transactions in all the undo segments in the database.D
It would return both active and committed transactions in all the undo segments in the database.E
It would return information regarding the transactions that began and were committed in the last 30 minutes.
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题Which version of a view would you use if you just want a quick， easy view within your XPage？（）A
Data Table ControlB
View ControlC
Repeat ControlD
Filter by category View Control
考题
单选题Which of the following system utilities would be used to change a drive type from dynamic tobasic?（）A
System Partition ManagerB
NTBACKUPC
Device ManagerD
Disk Management
考题
单选题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.
热门标签
最新试卷
