多选题You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time 

题目
多选题
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
A

Increase the size of redo log files

B

Increase the size of redo log buffer

C

Increase the number of redo log files

D

Place the redo log files on a separate disk

E

Decrease the number of redo log groups to two

F

Increate the number Log Writer （LGWR） process

相似考题

1.You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）A、Host namingB、Local namingC、Easy ConnectD、External namingE、directory naming

2.You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup

3. You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）

4.Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A、increase the undo retentionB、create more undo segmentsC、create another undo tablespaceD、increase the size of the undo tablespace

更多“多选题You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time ”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

    • A、The advisory memory has been turned off.
    • B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
    • C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
    • D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
    • E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

    正确答案:C

  • 第2题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

    • A、Increase the size of redo log files
    • B、Increase the size of redo log buffer
    • C、Increase the number of redo log files
    • D、Place the redo log files on a separate disk
    • E、Decrease the number of redo log groups to two
    • F、Increate the number Log Writer （LGWR） process

    正确答案:B,D

  • 第3题：

    You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

    • A、The trace file
    • B、The fixed views
    • C、The data dictionary views
    • D、The operating system log fields
    • E、The dynamic performance views.

    正确答案:E

  • 第4题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

    • A、Increase the undo return
    • B、Create more undo segments
    • C、Create another undotablespace
    • D、Increase the size of the undotablespace

    正确答案:D

  • 第5题：

    You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero.  What would you do to overcome this problem？（）

    • A、Increase the undo return
    • B、Create more undo segments
    • C、Create another undotablespace
    • D、Increase the size of the undo tablespace

    正确答案:D

  • 第6题：

    You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）

    • A、snmp.ora
    • B、names.ora
    • C、spfile.ora
    • D、sqlnet.ora
    • E、listener.ora
    • F、tnsnames.ora

    正确答案:D,F

  • 第7题：

    You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication.  You decide to make use of Microsoft ASP.NET 3.5 in order to create the application. The followingmarkup is present on the page：                  The page is used to retrieve the Users from a company database. However， only the active usersare displayed. The TextBox control allows you to also filter users by status. You do not specify astatus when you click the Filter button. You notice that the page does not filter by active users andshows all the users that are retrieved from the database. You need to make the necessary settingsto ensure that only the active users are being displayed on the page when a status is notspecified.  What should you do？（）

    • A、You should ensure that a default value for the Status property of the ControlParameter controlis set.
    • B、You should ensure that the PropertyName property of the ControlParameter control is set toText.
    • C、You should ensure that the ControlParameter control’s ConvertEmptyStringToNull property isset to false.
    • D、You should ensure that the {0} placeholder in the FilterExpression property is replaced with the（？） symbol.

    正确答案:C

  • 第8题：

    单选题
    You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisors

    B

    Segment Advisors

    C

    SQL Tuning and Access Advisors

    D

    Automated Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第9题：

    多选题
    You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）
    A

    Use a flashback query to retrieve the rows that were deleted

    B

    Useconventialincremental export and then import the affected object

    C

    Shutdown the database inNORMALmode and restart the database instance

    D

    Use DBMS_META package to reconstruct the object using undo segments

    E

    UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data

    F

    Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.


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

  • 第10题：

    多选题
    You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）
    A

    snmp.ora

    B

    names.ora

    C

    spfile.ora

    D

    sqlnet.ora

    E

    listener.ora

    F

    tnsnames.ora


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

  • 第11题：

    多选题
    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource 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


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

  • 第12题：

    单选题
    You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）
    A

    The trace file

    B

    The fixed views

    C

    The data dictionary views

    D

    The operating system log fields

    E

    The dynamic performance views.


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

  • 第13题：

    You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）

    • A、AFTER CREATE
    • B、AFTER SUSPEND
    • C、BEFORE CREATE
    • D、AFTER TRUNCATE
    • E、BEFORE SUSPEND
    • F、AFTER INSERT OR DELETE OR DELETE
    • G、BEFORE INSERT OR DELETE OR DELETE

    正确答案:B

  • 第14题：

    You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

    • A、Information about each Oracle Net connection.
    • B、Information about each entry in theLinstener.orafile
    • C、Information about the changed done in the database
    • D、Information about the different listeners in your system
    • E、Information about all thenondatabasefiles required to operate the database

    正确答案:A

  • 第15题：

    You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

    • A、Restart the database instance and run the job
    • B、Truncate the Certkiller STAFF table and run the job
    • C、Delete all rows from the Certkiller STAFF table and run the job
    • D、Increase the size of the USERStablespacethe and run the job
    • E、Increase the size of the database default permanenttablespaceand run the job

    正确答案:D

  • 第16题：

    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource 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

    正确答案:A,B,E

  • 第17题：

    You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

    • A、Increase the size of redo log files
    • B、Increase the size of redo log buffer
    • C、Increase the number of redo log files
    • D、Place the redo log files on a separate disk
    • E、Decrease the number of redo log groups to two
    • F、Increate the number Log Writer （LGWR） process

    正确答案:B,D

  • 第18题：

    You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

    • A、The trace file
    • B、The fixed views
    • C、The data dictionary views
    • D、The operating system log fields
    • E、The dynamic performance views.

    正确答案:E

  • 第19题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第20题：

    单选题
    You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）.  You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
    A

    Control file

    B

    Password file

    C

    Parameter file

    D

    Online redo log file

    E

    Listener controller file

    F

    Server parameter file


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

  • 第21题：

    多选题
    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
    A

    Increase the size of redo log files

    B

    Increase the size of redo log buffer

    C

    Increase the number of redo log files

    D

    Place the redo log files on a separate disk

    E

    Decrease the number of redo log groups to two

    F

    Increate the number Log Writer （LGWR） process


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

  • 第22题：

    单选题
    You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）
    A

    The trace file

    B

    The fixed views

    C

    The data dictionary views

    D

    The operating system log fields

    E

    The dynamic performance views.


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

  • 第23题：

    多选题
    You work as a database administrator for Certkiller .com. Your listener process， L1，is currently listening to three databases：CertK INDB04，Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant （DBCA） you create one more database，Certkiller DB07，and enable dynamic registration.  Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， Certkiller DB07， with the L1 listener process？（）
    A

    SHOW L1

    B

    SPAWN L1

    C

    STATUS L1

    D

    SERVICES L1

    E

    STATUS LISTENER

    F

    SERVICES LISTENER

    G

    SHOWcurrent_listener


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

  • 第24题：

    多选题
    You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
    A

    Increase the size of redo log files

    B

    Increase the size of redo log buffer

    C

    Increase the number of redo log files

    D

    Place the redo log files on a separate disk

    E

    Decrease the number of redo log groups to two

    F

    Increate the number Log Writer （LGWR） process


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

相关内容