单选题You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A LOGICAL_READS_PER_SESSION B CONNECT_TIME C COMPOSITE_LIMIT D CPU_PER_SESSION E PRIVATE_SGA

题目
单选题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）
A

LOGICAL_READS_PER_SESSION 

B

CONNECT_TIME 

C

COMPOSITE_LIMIT 

D

CPU_PER_SESSION 

E

PRIVATE_SGA

相似考题

1.CSports can help you keep fit and get in touch with nature. However, whether you are on the mountains, in the waves, or on the grassland, you should be aware that your sport of choice might have great influence on the environment.Some sports are resource-hungry. Golf, as you may know, eats up not only large areas of countryside, but also tons of water. Besides, all sorts of chemicals and huge amounts of energy are used to keep its courses (球场) in good condition. This causes major environmental effects. For example, in the dry regions of Portugal and Spain, golf is often held responsible for serious water shortage in some local areas.There are many environment-friendly sports. Power walking is one of them that you could take up today. You don’t need any special equipment except a good pair of shoes; and you don’t have to worry about resources and your purse. Simple and free, power walking can also keep you fit. If you walk regularly, it will be good for your heart and bones. Experts say that 20 minutes of power walking daily can make you feel less anxious, sleep well and have better weight control.Whatever sport you take up, you can make it greener by using environment-friendly equipment and buying products made from recycled materials. But the final goal should be “green gyms”. They are better replacements for traditional health clubs and modern sports centers. Members of green gyms play sports outdoors, in the countryside or other open spaces. There is no special requirement for you to start your membership. And best of all, it’s free.64. Which of the following is the author most probably in favor of?A. Cycling around a lake.B. Motor racing in the desert.C. Playing basketball in a gym.D. Swimming in a sports center.

2.When verifying the OSPF link state database, which type of LSAs should you expect to see within the different OS PF area types?()A. All OSPF routers in stubby areas can have type 3 LSAs in their database.B. All OSPF routers in stubby areas can have type 7 LSAs in their database.C. All OSPF routers in totally stubby areas can have type 3 LSAs in their database.D. All OSPF routers in totally stubby areas can have type 7 LSAs in their database.E. All OSPF routers in NSSA areas can have type 3 LSAs in their database.F. All OSPF routers in NSSA areas can have type 7 LSAs in their database.

3.回答 64 ~ 67 题： C Sports can help you keep fit and get in touch with nature． However, whether you are on the mountains, in the waves, or on the grassland, you should be aware that your sport of choice might have great influence on the environment.Some sports are resource-hungry.Golf, as you may know, eats up not only large areas of countryside, but also tons of water. Besides, all sorts of chemicals and huge amounts of energy are used to keep its courses（球场） in good condition. This causes major environmental effects.For example, in the dry regions of Portugal and Spain, golf is often held responsible for serious water shortage in some local areas.There are many environment-friendly sport. Power walking is one of them that you could take up today.You don’t need any special equipment except a good pair of shoes；and you don’t have to worry about resources and your purse.Simple and free, power walking can also keep you fit.If you walk regularly, it will be good for your heart and bones.Experts say that 20 minutes of power walking daily can make you feel less anxious, sleep well and have better weight control.Whatever sport you take up, you can make it greener by using environment-friendly equipment and buying products made from recycled materials.But the final goal should be “green gyms”.They are better replacements for traditional health clubs and modern sports centers.Members of green gyms play sports outdoors, in the countryside or other open spaces.There is no special requirement for you to start your membership.And best of all, it’s free第9题：Which of the following is the author most probably in favor of?A． Cycling around a lakeB． Motor racing in the desertC． Playing basketball in a gymD． Swimming in a sports center

4.You need to describe the various types of flow control to your co-workers. Which of the following are types of flow control that can be used in a network? (Choose three)A. Congestion avoidanceB. WindowingC. Cut-throughD. BufferingE. Load BalacingF. Fast Forward

更多“单选题You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A LOGICAL_READS_PER_SESSION B CONNECT_TIME C COMPOSITE_LIMIT D CPU_PER_SESSION E PRIVATE_SGA”相关问题

  • 第1题：

    Which of these can not be used in defining policies？（）

    • A、time of day
    • B、user agent
    • C、proxy port
    • D、usage quotas

    正确答案:D

  • 第2题：

    You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

    • A、Clone 
    • B、Copy 
    • C、Template 
    • D、Terminal 

    正确答案:C

  • 第3题：

    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

    • A、Oracle Flashback uses undo information to construct consistent data. 
    • B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
    • C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
    • D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

    正确答案:A,B

  • 第4题：

    You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

    • A、LOGICAL_READS_PER_SESSION 
    • B、CONNECT_TIME 
    • C、COMPOSITE_LIMIT 
    • D、CPU_PER_SESSION 
    • E、PRIVATE_SGA

    正确答案:C

  • 第5题：

    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

    • A、Library cache 
    • B、Row cache
    • C、Dictionary cache 
    • D、Large area 
    • E、Buffer cache

    正确答案:B

  • 第6题：

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

    • A、control file
    • B、password file
    • C、listener controller file
    • D、control file and password file

    正确答案:B

  • 第7题：

    多选题
    When verifying the OSPF link state database, which type of LSAs should you expect to see within the different OS PF area types?（）
    A

    All OSPF routers in stubby areas can have type 3 LSAs in their database.

    B

    All OSPF routers in stubby areas can have type 7 LSAs in their database.

    C

    All OSPF routers in totally stubby areas can have type 3 LSAs in  their database.

    D

    All OSPF routers in totally stubby areas can have type 7 LSAs in their database.

    E

    All OSPF routers in NSSA areas can have type 3 LSAs in their database.

    F

    All OSPF routers in NSSA areas can have type 7 LSAs in their database.


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

  • 第8题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第9题：

    单选题
    Which one of these statements is true of OSPF type 5 LSAs？（）
    A

    They are used to summarize area routes to other areas.

    B

    They are used in not-so-stubby areas to propagate external routes.

    C

    They are used to notify areas of the ASBR.

    D

    They are flooded to all areas except stub areas （external route）.


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

  • 第10题：

    单选题
    You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）
    A

    Use the Database Resource Manager.

    B

    Set the limits in the profiles used by users.

    C

    Modify the SESSIONS initialization parameter.

    D

    Set the warning threshold for the Current Logons Count metric.


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

  • 第11题：

    单选题
    Which one of these statements is true of OSPF type 5 LSAs？ （）
    A

     They are used to summarize area routes to other areas.

    B

     They are used in not-so-stubby areas to propagate external routes.

    C

     They are used to notify areas of the ASBR.

    D

     They are flooded to all areas except stub areas （external route）.


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

  • 第12题：

    多选题
    In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager？（）
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


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

  • 第13题：

    Which one of these statements is true of OSPF type 5 LSAs？ （）

    • A、 They are used to summarize area routes to other areas.
    • B、 They are used in not-so-stubby areas to propagate external routes.
    • C、 They are used to notify areas of the ASBR.
    • D、 They are flooded to all areas except stub areas （external route）.

    正确答案:D

  • 第14题：

    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

    • A、 The log sequence is reset to 0.
    • B、 All the online redo logs are deleted.
    • C、 All the archived redo logs from a previous incarnation become useless.
    • D、 The full database backup taken from a previous incarnation can be used in future.
    • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

    正确答案:D

  • 第15题：

    You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

    • A、Shared pool 
    • B、Control file 
    • C、SGA 
    • D、PGA

    正确答案:B

  • 第16题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第17题：

    You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）

    • A、Use the Database Resource Manager.
    • B、Set the limits in the profiles used by users.
    • C、Modify the SESSIONS initialization parameter.
    • D、Set the warning threshold for the Current Logons Count metric.

    正确答案:D

  • 第18题：

    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?（）

    • A、SYSTEM 
    • B、OUTLN 
    • C、INTERNAL 
    • D、SYS

    正确答案:D

  • 第19题：

    单选题
    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）
    A

    Library cache 

    B

    Row cache

    C

    Dictionary cache 

    D

    Large area 

    E

    Buffer cache


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

  • 第20题：

    单选题
    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
    A

     The log sequence is reset to 0.

    B

     All the online redo logs are deleted.

    C

     All the archived redo logs from a previous incarnation become useless.

    D

     The full database backup taken from a previous incarnation can be used in future.

    E

     Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.


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

  • 第21题：

    单选题
    You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）
    A

    Clone 

    B

    Copy 

    C

    Template 

    D

    Terminal 


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

  • 第22题：

    单选题
    You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）
    A

    LOGICAL_READS_PER_SESSION 

    B

    CONNECT_TIME 

    C

    COMPOSITE_LIMIT 

    D

    CPU_PER_SESSION 

    E

    PRIVATE_SGA


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

  • 第23题：

    多选题
    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）
    A

    Oracle Flashback uses undo information to construct consistent data.

    B

    You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.

    C

    You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.

    D

    Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.


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

  • 第24题：

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

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


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

相关内容