网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “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.” 相关考题
考题
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
考题
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 duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database
考题
Which statements are true regarding the system－defined moving window baseline in Oracle Database 11g?()
A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default with the window size being equal to the AWR retention time.D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
考题
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 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
考题
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
考题
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 definedB、 If the user fails the TACACS+ authentication then the local database on the router will be used to authenticatethe userC、 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 configuredE、 if the tacacs+ server is unavailable， authentication will succeed automaticallyby default
考题
Which two statements correctly describe VTP？（）A、Transparent mode always has a configuration revision number of 0.B、Transparent mode cannot modify a VLAN database.C、Client mode cannot forward received VTP advertisements.D、Client mode synchronizes its VLAN database from VTP advertisements.E、Server mode can synchronize across VTP domains.
考题
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
考题
Which two are valid locking levels that are used by transactions in an Oracle database？（）A、row levelB、block levelC、object levelD、schema levelE、database level
考题
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.
考题
Which statement correctly describes SQL and /SQL*Plus?（）A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
考题
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.
考题
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 ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
考题
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（） A、 The Oracle database will perform block checking for the index blocks onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
考题
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.
考题
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.
考题
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 duplicatedB、The read-only tablespaces in the target database are still defined in new the databaseC、The read-only tablespaces in the target database are changed to online after duplicationD、The data files of the read-only tablespaces in the target database get duplicatedE、The read-only tablespaces in the target database are not defined in the new database
考题
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）A、 It does not allow you to change the moving window size.B、 Adaptive threshold functionalities use it by default to compute statistics.C、 It is created by default with the window size being equal to the AWR retention time.D、 It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.
考题
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.
考题
In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）A、Database client and database serverB、WebSphere Application Server and Database ServerC、WebSphere Commerce Server and WebSphere Application ServerD、Web server and WebSphere Application Server
考题
单选题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
考题
多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
考题
多选题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 code the locks as per the requirement of the application.DAllow escalation of row locks to block locks if too many row locks cause problem.
考题
单选题Which statement correctly describes SQL and /SQL*Plus?（）A
Both SQL and /SQL*plus allow manipulation of values in the database.B
/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C
/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D
/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
考题
多选题Which two statements correctly describe VTP？（）ATransparent mode always has a configuration revision number of 0.BTransparent mode cannot modify a VLAN database.CClient mode cannot forward received VTP advertisements.DClient mode synchronizes its VLAN database from VTP advertisements.EServer mode can synchronize across VTP domains.
考题
多选题Which two are valid locking levels that are used by transactions in an Oracle database？（）Arow levelBblock levelCobject levelDschema levelEdatabase level
热门标签
最新试卷