网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which view will you use to view information regarding the jobs that are currently running in a database？（）
A
DBA_SCHEDULER_RUNNING_JOBS
B
DBA_SCHEDULER_JOB_RUN_DETAILS
C
DBA_SCHEDULER_JOBS
D
DBA_SCHEDULER_JOB_LOG
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）A DBA_SCHEDULER_RUNNING_JOBSB DBA_SCHEDULER_JOB_RUN_DETAILSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG” 相关考题
考题
Which Scheduler view(s) can be queried to see which jobs are currently executing? ()
A. DBA_SCHEDULER_JOB_RUN_DETAILSB. DBA_SCHEDULER_RUNNING_JOBS DBAC. DBA_SCHEDULER_CURRENT_JOBSD. DBA_SCHEDULER_JOBS DBAE. DBA_SCHEDULER_EXECUTING_JOBS
考题
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
You would like to view all Fast Ethernet interfaces currently using VLAN tagging and the specific VLANs each interface is using.Which CLI command displays this information?()
A.AB.BC.CD.D
考题
You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）A、Update the view to use an outer join between the Customers and Sales tables.B、Create a clustered index on the v CustomerSales view.C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.D、Create a stored procedure for the business analysts that uses the v CustomerSales 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 view will you use to view information regarding the jobs that are currently running in a database？（）A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
考题
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A、Execute the query and view Active Session History (ASH) for information about the query.B、Enable SQL trace for the query.C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
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
考题
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 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 created.) How do you obtain the definition of the view?（）A、Use the DESCRIBE command on 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.
考题
You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）A、runtime () B、runtimeMbeanServer ()C、connectRuntime ()D、beginRuntime ()E、serverRuntime ()
考题
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
考题
Which Scheduler view（s） can be queried to see which jobs are currently executing？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_CURRENT_JOBSD、 DBA_SCHEDULER_JOBSE、 DBA_SCHEDULER_EXECUTING_JOBS
考题
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 Scheduler view(s) can be queried to see which jobs are currently executing? （）A、DBA_SCHEDULER_JOB_RUN_DETAILSB、DBA_SCHEDULER_RUNNING_JOBS DBAC、DBA_SCHEDULER_CURRENT_JOBSD、DBA_SCHEDULER_JOBS DBAE、DBA_SCHEDULER_EXECUTING_JOBS
考题
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（） A、 Use a Dynamic Management View to check for locks.B、 Use a Dynamic Management View to check for blocked queries.C、 Use a Dynamic Management View to check for long-running queries.D、 Use a Dynamic Management View to check the size and maximum size of the database.
考题
单选题You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）A
Update the view to use an outer join between the Customers and Sales tables.B
Create a clustered index on the v CustomerSales view.C
Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.D
Create a stored procedure for the business analysts that uses the v CustomerSales view.
考题
单选题A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A
Execute the query and view Active Session History (ASH) for information about the query.B
Enable SQL trace for the query.C
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）A
DBA_SCHEDULER_RUNNING_JOBSB
DBA_SCHEDULER_JOB_RUN_DETAILSC
DBA_SCHEDULER_JOBSD
DBA_SCHEDULER_JOB_LOG
考题
多选题Which Scheduler view（s） can be queried to see which jobs are currently executing？（）ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBSCDBA_SCHEDULER_CURRENT_JOBSDDBA_SCHEDULER_JOBSEDBA_SCHEDULER_EXECUTING_JOBS
考题
单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A
DBA_SCHEDULER_JOB_RUN_DETAILSB
DBA_SCHEDULER_RUNNING_JOBSC
DBA_SCHEDULER_JOBSD
DBA_SCHEDULER_JOB_LOG
考题
单选题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 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
考题
单选题You are analyzing the performance of a SQL Azure database. You need to recommend an approach for identifying the indexes that should be added to improve database performance. What should you recommend？（）A
Use SQL Server Profiler to identify missing indexes.B
Use the Database Engine Tuning Advisor to identify missing indexes.C
Use a Dynamic Management View to analyze query plans.D
Use a DynamicManagement View to ascertain the number of pending I/O requests.
考题
单选题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 Scheduler view(s) can be queried to see which jobs are currently executing? （）ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBS DBACDBA_SCHEDULER_CURRENT_JOBSDDBA_SCHEDULER_JOBS DBAEDBA_SCHEDULER_EXECUTING_JOBS
考题
单选题You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）A
runtime () B
runtimeMbeanServer ()C
connectRuntime ()D
beginRuntime ()E
serverRuntime ()
考题
单选题A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）A
Use a Dynamic Management View to check for locks.B
Use a Dynamic Management View to check for blocked queries.C
Use a Dynamic Management View to check for long-running queries.D
Use a Dynamic Management View to check the size and maximum size of the database.
热门标签
最新试卷