网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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（）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 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
考题
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 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.
考题
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
考题
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.
考题
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.
考题
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.
考题
多选题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
多选题Which two statements are correct about the aaa authentication login default grouptacacs+ localglobal configuration command？ （）Athis login authenticationmethod list is automaticallyapplied to all lines except those that have a named method list explicitly definedBIf the user fails the TACACS+ authentication then the local database on the router will be used to authenticatethe userCif the tacacs+ server fails to respond then the local database on the router will be used to authenticate the userDlogin is the name of the method list being configuredEif the tacacs+ server is unavailable， authentication will succeed automaticallyby default
考题
多选题Which two statements are true about record groups?（）AThey are stored in the database.BThey are stored in local Forms memory.CThe type is specified explicitly at design time.DThe type is implied by when and how it is created.
考题
单选题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 are true regarding hot patching? （）AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all platforms.EIt works only in a single database instance environment.
考题
多选题Which three tasks can be performed using a duplicate database? （）(Choose three.)ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
考题
多选题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? （）AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database
考题
多选题Which two are valid locking levels that are used by transactions in an Oracle database？（）Arow levelBblock levelCobject levelDschema levelEdatabase level
考题
多选题In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）ADatabase client and database serverBWebSphere Application Server and Database ServerCWebSphere Commerce Server and WebSphere Application ServerDWeb server and WebSphere Application Server
考题
多选题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)AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database
考题
多选题Which three tasks can be performed using a duplicate database？（）ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
考题
多选题SQ L*Loader is a utility that can perform which two tasks？（）ALoad data from a disk， tape， or named pipes.BLoad data into an Oracle database using DML statements.CExtract， reorganize， and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.
考题
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
热门标签
最新试卷
