多选题Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）AAvoid coding unnecessary long-running transactions.BAllow the database to handle locks in default locking mode.CAlways explicitly 

题目
多选题
Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）
A

Avoid coding unnecessary long-running transactions.

B

Allow the database to handle locks in default locking mode.

C

Always explicitly code the locks as per the requirement of the application.

D

Allow escalation of row locks to block locks if too many row locks cause problem.

相似考题

1.Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above

2.Which tier in Oracle E－Business Suite is responsible for storing application data?()A.database tierB.application tierC.client (desktop) tierD.both database tier and application tier

3.Which Oracle Database component is audited by default if the unified Auditing option is enabled?()A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application Security

4.Which correctly describes the tiers of the Oracle Workflow architecture?()A. Oracle Database tier and Application server tier onlyB. Oracle Database tier, Application server tier, and End-user client tier onlyC. Oracle Database tier, Application server tier, and Development client tier onlyD. Oracle Database tier, Application server tier, Development client tier, and End-user client tier

更多“多选题Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）AAvoid coding unnecessary long-running transactions.BAllow the database to handle locks in default locking mode.CAlways explicitly ”相关问题

  • 第1题：

    Which two statements are correct about the aaa authentication login default grouptacacs+ localglobal configuration command？ （）

    • A、 this login authenticationmethod list is automaticallyapplied to all lines except those that have a named method list explicitly defined
    • B、 If the user fails the TACACS+ authentication then the local database on the router will be used to authenticatethe user
    • C、 if the tacacs+ server fails to respond then the local database on the router will be used to authenticate the user 
    • D、 "login" is the name of the method list being configured
    • E、 if the tacacs+ server is unavailable， authentication will succeed automaticallyby default

    正确答案:A,C

  • 第2题：

    Which two are valid locking levels that are used by transactions in an Oracle database？（）

    • A、row level
    • B、block level
    • C、object level
    • D、schema level
    • E、database level

    正确答案:A,C

  • 第3题：

    During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）

    • A、The installation terminates with an error.
    • B、The installation proceeds with the default value without warnings and errors.
    • C、The installation proceeds with the default value but it would not be an OFA-compliant database.
    • D、The installation proceeds with the default value but a message would be generated in the alert log file.

    正确答案:D

  • 第4题：

    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

    • A、 The audit trail is stored in an operating system file.
    • B、 Auditing is disabled for all privileges.
    • C、 The audit trail is stored in the database.
    • D、 Auditing is enabled for all privileges.
    • E、 Auditing is enabled for certain privileges related to database security.

    正确答案:C,E

  • 第5题：

    Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）

    • A、Avoid coding unnecessary long-running transactions.
    • B、Allow the database to handle locks in default locking mode.
    • C、Always explicitly code the locks as per the requirement of the application.
    • D、Allow escalation of row locks to block locks if too many row locks cause problem.

    正确答案:A,B

  • 第6题：

    多选题
    Which two statements are correct about the aaa authentication login default grouptacacs+ localglobal configuration command？ （）
    A

    this login authenticationmethod list is automaticallyapplied to all lines except those that have a named method list explicitly defined

    B

    If the user fails the TACACS+ authentication then the local database on the router will be used to authenticatethe user

    C

    if the tacacs+ server fails to respond then the local database on the router will be used to authenticate the user

    D

    login is the name of the method list being configured

    E

    if the tacacs+ server is unavailable， authentication will succeed automaticallyby default


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

  • 第7题：

    单选题
    Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）
    A

    Oracle Data Pump

    B

    Oracle Recovery Manager (RMAN)

    C

    Oracle Label Security

    D

    Oracle Database Vault

    E

    Oracle Real Application Security


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

  • 第8题：

    多选题
    Which two statements are true regarding hot patching? （）
    A

    It requires relinking of the Oracle binary.

    B

    It does not require database instance shutdown.

    C

    It can detect conflicts between two online patches.

    D

    It is available for installing all patches on all platforms.

    E

    It works only in a single database instance environment.


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

  • 第9题：

    多选题
    Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? （）
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第10题：

    多选题
    In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）
    A

    Database client and database server

    B

    WebSphere Application Server and Database Server

    C

    WebSphere Commerce Server and WebSphere Application Server

    D

    Web server and WebSphere Application Server


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

  • 第11题：

    多选题
    Which three tasks can be performed using a duplicate database？（）
    A

    Testing the backup and recovery procedures

    B

    Testing the upgrade of an Oracle database to a new release

    C

    Testing the effect of an application changes on database performance

    D

    Continuously updating archive log files from the target database to support failover


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

  • 第12题：

    多选题
    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
    A

    Flashback logs are not archived.

    B

    Flashback logs are maintained in redo log files.

    C

    Flashback logs are maintained in the Flash Recovery Area.

    D

    Flashback logs are used to maintain Flashback Database related errors.

    E

    Flashback logs need to be cleared manually after you disable Flashback Database.


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

  • 第13题：

    Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）

    • A、Oracle Data Pump
    • B、Oracle Recovery Manager (RMAN)
    • C、Oracle Label Security
    • D、Oracle Database Vault
    • E、Oracle Real Application Security

    正确答案:B

  • 第14题：

    SQ L*Loader is a utility that can perform which two tasks？（）

    • A、Load data from a disk， tape， or named pipes.
    • B、Load data into an Oracle database using DML statements.
    • C、Extract， reorganize， and insert data within an Oracle database.
    • D、Load data from external files into tables in an Oracle database.
    • E、Load data into an Oracle database using operating system commands.
    • F、Load data directly from a non-Oracle database to an Oracle database.

    正确答案:A,D

  • 第15题：

    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

    • A、Application Server Control
    • B、Oracle Management Service
    • C、Oracle Enterprise Manager Repository
    • D、Oracle Enterprise Manager Database Control

    正确答案:C,D

  • 第16题：

    Which two statements are true about record groups?（）

    • A、They are stored in the database. 
    • B、They are stored in local Forms memory. 
    • C、The type is specified explicitly at design time. 
    • D、The type is implied by when and how it is created.

    正确答案:B,D

  • 第17题：

    多选题
    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）
    A

    You must shut down the database instance to perform the backups.

    B

    You must configure the Flash Recovery Area （FRA） for the database.

    C

    You can perform complete database backups without closing the database.

    D

    All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.


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

  • 第18题：

    多选题
    Which two statements are true about record groups?（）
    A

    They are stored in the database.

    B

    They are stored in local Forms memory.

    C

    The type is specified explicitly at design time.

    D

    The type is implied by when and how it is created.


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

  • 第19题：

    多选题
    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）
    A

    The audit trail is stored in an operating system file.

    B

    Auditing is disabled for all privileges.

    C

    The audit trail is stored in the database.

    D

    Auditing is enabled for all privileges.

    E

    Auditing is enabled for certain privileges related to database security.


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

  • 第20题：

    多选题
    Which three tasks can be performed using a duplicate database? （）(Choose three.)
    A

    Testing the backup and recovery procedures

    B

    Testing the upgrade of an Oracle database to a new release

    C

    Testing the effect of an application changes on database performance

    D

    Continuously updating archive log files from the target database to support failover


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

  • 第21题：

    多选题
    Which two are valid locking levels that are used by transactions in an Oracle database？（）
    A

    row level

    B

    block level

    C

    object level

    D

    schema level

    E

    database level


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

  • 第22题：

    多选题
    Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第23题：

    多选题
    SQ L*Loader is a utility that can perform which two tasks？（）
    A

    Load data from a disk， tape， or named pipes.

    B

    Load data into an Oracle database using DML statements.

    C

    Extract， reorganize， and insert data within an Oracle database.

    D

    Load data from external files into tables in an Oracle database.

    E

    Load data into an Oracle database using operating system commands.

    F

    Load data directly from a non-Oracle database to an Oracle database.


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

相关内容