搜题

【单选题】

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:<br /> There is enough free space in the disk group for mirroring to be done.<br /> What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）

A、Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

B、Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

C、The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.

D、ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

E、Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

查看正确答案

更多“ A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:<br /> There is enough free space in the disk group for mirroring to be done.<br /> What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）”相关的问题

第1题

[多选题] Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）

A、You can use RMAN stored scripts B、Recovery is faster if data is stored in catalog in addition to the control file C、You can store backup information of all registered databases in one place D、Database backups are automatically deleted when they are older than the specified time period

点击查看答案

第2题

[多选题] Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

A、You can use RMAN stored scripts B、Recovery is faster if data is stored in catalog in addition to the control file C、You can store backup information of all registered databases in one place D、Database backups are automatically deleted when they are older than the specified time period

点击查看答案

第3题

[单选题] You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

A、It is a list of remote database links stored in the XML file that are available to the users of the database. B、It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts. C、It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts. D、It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

点击查看答案

第4题

[单选题] Which statement about using RMAN stored scripts is true?（）

A、To create and execute an RMAN stored script, you must use a recovery catalog. B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file. C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog. D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

点击查看答案

第5题

[单选题] Which statement about using RMAN stored scripts is true?（）

A、To create and execute an RMAN stored script, you must use a recovery catalog. B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file. C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog. D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

点击查看答案

第6题

[多选题] 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.

点击查看答案

第7题

[单选题] Which tier in Oracle E-Business Suite is responsible for storing application data?（）

A、database tier B、application tier C、client (desktop) tier D、both database tier and application tier

点击查看答案

第8题

[单选题] Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）

A、It performs parallel recompilation of only the stored PL/SQL code. B、It performs sequential recompilation of only the stored PL/SQL code. C、It performs parallel recompilation of any stored PL/SQL as well as Java code. D、It performs sequential recompilation of any stored PL/SQL as well as Java code.

点击查看答案

第9题

[] Which statement is true regarding virtual private catalogs?（）

A、A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. B、B. The virtual private catalog owner cannot create and modify the stored scripts. C、C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. D、D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服