单选题You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the  Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the tab

题目
单选题
You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the  Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table.  How does this change affect the index？（）
A

A leaf will be marked as invalid.

B

An update in a leaf row takes place.

C

The index will be updated automatically at commit.

D

A leaf row in the index will be deleted and inserted.

E

The index becomes invalid when you make any updates

相似考题

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

3.As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates.

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

更多“单选题You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the  Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the tab”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the  Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table.  How does this change affect the index？（）

    • A、A leaf will be marked as invalid.
    • B、An update in a leaf row takes place.
    • C、The index will be updated automatically at commit.
    • D、A leaf row in the index will be deleted and inserted.
    • E、The index becomes invalid when you make any updates

    正确答案:D

  • 第4题：

    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

  • 第5题：

    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第6题：

    You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later， you are required to determine if assembly references in this application domain， which is the current application domain， are being cached. What property should you use to achieve this objective？（）

    • A、 AppDomain.CurrentDomain.ShadowCopyFiles
    • B、 AppDomain.CurrentDomain.CachePath
    • C、 AppDomain.CurrentDomain.ConfigurationFile
    • D、 AppDomain.CurrentDomain.Evidence

    正确答案:A

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
    A

    A leaf will be marked as invalid.

    B

    An update in a leaf row takes place.

    C

    The index will be updated automatically at commit.

    D

    A leaf row in the index will be deleted and inserted.

    E

    The index becomes invalid when you make any updates.


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

  • 第12题：

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


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

  • 第13题：

    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

  • 第14题：

    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

    正确答案:B

  • 第15题：

    You work as a database administrator for Certkiller .com. When you tried to connect to the database， you received the following error： ERROR：  ORA-12541：TNS：no_listener  You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.  lsnrctl>START  What statement is true？（）

    • A、It would attempt to start the default listener
    • B、It would start the most recently created listener.
    • C、It would display an error with a message asking for the listener name to be specified.
    • D、It would show you a list of listeners and prompts for the listener name that you want to start.

    正确答案:A

  • 第16题：

    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

  • 第17题：

    You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第18题：

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


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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


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

  • 第21题：

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

    B

    Local naming

    C

    Easy Connect

    D

    External naming

    E

    directory naming


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

  • 第22题：

    单选题
    You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）
    A

    Configure Java Pool to cache the java objects.

    B

    Configure Streams Pool to enable parallel processing.

    C

    Increase Shared Pool size to cache more PL/SQL objects.

    D

    Increase Database Buffer Cache size to increase cache hits.

    E

    Configure Large Pool to be used by RMAN and shared server.

    F

    Increase the total System Global Area （SGA） size to increase memory hits.


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

  • 第23题：

    单选题
    You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later， you are required to determine if assembly references in this application domain， which is the current application domain， are being cached. What property should you use to achieve this objective？（）
    A

     AppDomain.CurrentDomain.ShadowCopyFiles

    B

     AppDomain.CurrentDomain.CachePath

    C

     AppDomain.CurrentDomain.ConfigurationFile

    D

     AppDomain.CurrentDomain.Evidence


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

相关内容