niusouti.com

单选题For 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 s

题目
单选题
For 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？（）
A

 Set the CPU time per call in the users profile.

B

 Set the CPU time per session in the users profile.

C

 Set the CPU levels for the user’s group using Resource Manager.

D

 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

相似考题

1.You will find as you read this book that you just can't keep some of these stories to ___. You will want to share them with a friend.A、itselfB、yourselfC、himselfD、themselves

2.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.

3.You can find it in our____brochure, along with some of our other models.A.last B.late C.lately D.latest

4.We are confident that you will find _____ ready market for the item ______ your end.A、/; atB、a; byC、a; atD、some; by

参考答案和解析
正确答案： B
解析： 暂无解析
更多“For the V$SESSION_LONGOPS view， you find that some of the da”相关问题

  • 第1题：

    What view might you use to try to determine how long a particular backup will take?（）

    • A、V$SESSION_EVENT 
    • B、V$SESSION 
    • C、V$W0041ITS
    • D、V$WAITSTAT 
    • E、V$SESSION_LONGOPS 

    正确答案:E

  • 第2题：

    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.

    正确答案:B

  • 第3题：

    What view might you use to try to determine how long a particular backup will take？（）  

    • A、 V$SESSION_EVENT
    • B、 V$SESSION
    • C、 V$WAITS
    • D、 V$WAITSTAT
    • E、 V$SESSION_LONGOPS

    正确答案:E

  • 第4题：

    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

    • A、 recover lost blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第5题：

    单选题
    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_DETAILS

    B

     DBA_SCHEDULER_RUNNING_JOBS

    C

     DBA_SCHEDULER_JOBS

    D

     DBA_SCHEDULER_JOB_LOG


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    What view might you use to try to determine how long a particular backup will take？（）
    A

     V$SESSION_EVENT

    B

     V$SESSION

    C

     V$WAITS

    D

     V$WAITSTAT

    E

     V$SESSION_LONGOPS


    正确答案： E
    解析： 暂无解析

  • 第7题：

    单选题
    For 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？（）
    A

     Set the CPU time per call in the users profile.

    B

     Set the CPU time per session in the users profile.

    C

     Set the CPU levels for the user’s group using Resource Manager.

    D

     Set the TIMED_STATISTICS parameter to TRUE in the parameter file.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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 view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You’d better find some information about Nike’s “Chamber of Fear” advertisement, _____?
    A

    wouldn’t you

    B

    had you

    C

    hadn’t you

    D

    should you


    正确答案： D
    解析：
    you’d better即you had better，其反意疑问用hadn’t，故选C。

  • 第10题：

    单选题
    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective？（）
    A

    create a plan directive in the SYS_GROUP

    B

    create the pending area for the consumer group

    C

    activate the provided SYSTEM_PLAN in Resource Manager

    D

    set the TIMED_STATISTICS parameter to TRUE in the parameter file

    E

    set the execution time limit for all users， except SYS and SYSTEM， in their profiles


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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？（）
    A

    set the CPU time per call in the users profile

    B

    set the CPU time per session in the users profiles

    C

    set the CPU levels for the users’ group using Resource Manager

    D

    set the TIMED_STATISTICS parameter to TRUE in the parameter file


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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_DETAILS
    • B、 DBA_SCHEDULER_RUNNING_JOBS
    • C、 DBA_SCHEDULER_JOBS
    • D、 DBA_SCHEDULER_JOB_LOG

    正确答案:C

  • 第14题：

    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

    正确答案:A

  • 第15题：

    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

    正确答案:A

  • 第16题：

    You are an Administrator at Cer-tech .com. you manage a member server that runs Windows Server 2008.The Terminal Server Gateway （TS Gateway） is also installed on the member server. You want to find outwhether a group of users have ever connected to their workstations remotely through TS Gateway server. What should you do to achieve this task？（）

    • A、Open the TS gateway console and view the events in the monitoring field
    • B、View the Windows Server 2008 Event Viewer for TS Gateway connections
    • C、View Event Viewer security log
    • D、View the Event Viewer Terminal Services-gateway log

    正确答案:D

  • 第17题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）
    A

     V$LOG

    B

     V$LOGFILE

    C

     DBA_LOG_GROUPS

    D

     V$LOG_HISTORY


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     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 Management

    D

     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


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
    A

     recover lost blocks

    B

     recover corrupt blocks

    C

     recover media corrupt blocks from list

    D

     recover corrupt blocks from list

    E

     recover corruption list


    正确答案： E
    解析： 暂无解析

  • 第21题：

    单选题
    What view might you use to try to determine how long a particular backup will take?（）
    A

    V$SESSION_EVENT 

    B

    V$SESSION 

    C

    V$W0041ITS

    D

    V$WAITSTAT 

    E

    V$SESSION_LONGOPS 


    正确答案： A
    解析： 暂无解析

  • 第22题：

    问答题
    Nowadays more young people can enjoy university education than in the past, but they are faced with another problem: job hunting. Most graduates find it hard to find a satisfactory job, and some have to stay jobless for several years. What do you think may have caused this problem? Write a composition of about 400 words to explain your point of view. The title has been provided for you.Problems in university students' job hunting　　In the first part of your writing you should present your thesis statement, and in the second part you should support the thesis statement with appropriate details. In the last part you should bring what you have written to a natural conclusion or a summary.　　Marks will be awarded for content, organization, grammar and appropriateness. Failure to follow the above instructions may result in a toss of marks.

    正确答案：
    Problems in university students' job hunting Many years ago, most young people could not go to university because university only accepted a small amount of students. To their delight, young people now find it easier to go to university, but to their dismay, they also find it harder to find jobs. How come university students, who are intelligent, ambitious and knowledgeable, have difficulty in finding jobs? There are several reasons to account for this problem.
    One important reason is that nowadays university students pursue too high a goal. Most of them dream to work in office buildings, and hold contempt for jobs in places where things are made or sold. Some care too much about some minor factors, such as salary, location or comfortableness of the working place. Because of these, students usually narrow down their selections, thus making it harder to find a proper job. For example, most students want to work in cities or in coastal areas, such as Shanghai, Beijing or Guangzhou. Although talents are badly needed in some western provinces, the graduates are unwilling to go there. This naturally makes it hard to find a job in some areas and hard to find a talent in some other areas.
    Another reason is that the majors some students study in universities do not fit in with the demands of the vacant jobs. As the society is developing so quickly, university cannot catch up with it and offer courses to satisfy all requirements. Besides, there are some majors where not many graduates are needed but are admitting many students each year. When these students graduate, they may find that there are almost no vacancies that really need their knowledge. Majors like history or philosophy are examples of this type.
    The last reason is that some employers raise too strict requirements on graduates. Because students stay on campus, most of them do not have time to work. But most companies just want to employ people with at least two-year working experience. This can keep many students from applying for the jobs. Some employers also just want boys, and then the girls will lose the chance of applying for the jobs.
    From the above discussion, we can see that students, universities, and employers should all be responsible for the problems in the job market. To solve the problem, graduates should hold reasonable expectations, university should offer courses to meet the latest requirements of the society and flexibly adjust admission policy, and employers should raise sensible requirements on candidates. If all these three parties make joint efforts, university students will soon find that finding a job is not as hard as they expected.
    解析：
    　　这道题要求谈论原因，即why it is hard for university students to find a job。作者从学生个人的期望值过高、学校课程陈旧和雇主要求太高三个方面进行了阐述，要点合理恰当。引言段采用对照法开头，用一个问题引出讨论主题，保证了文章中心思想的清晰明了。正文段中，作者按照个人、学校、社会三个方面的顺序安排要点，符合由小到大的顺序，保证了文章的通顺。论据方面，除了推理以外，我们还可以发现很多例子，这就增强了文章的说服力。

  • 第23题：

    单选题
    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. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?（）
    A

    SQLServer:Buffer Manager 

    B

    SQLServer:Access Methods 

    C

    SQLServer:General Statistics 

    D

    SQLServer:Exec Statistics


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

相关内容