The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below: <img src="https://img.ppkao.com/2018-08/yiyu/2018080210404021218.jpg" /> Which statement is true regarding what this command accomplishes?（） The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below: <img src="https://img.ppkao.com/2018-08/yiyu/2018080210404021218.jpg" /> Which statement is true regarding what this command accomplishes?（）..

第1题

[] The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?（）

A、A. The Oracle database will perform block checking for the index blocks only B、B. The Oracle database will not perform block checking for any of the data blocks C、C. The Oracle database will perform block checking for the default permanent tablespace only D、D. The Oracle database will perform block checking for the data blocks in all user tablespaces E、E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

点击查看答案

第2题

[单选题] You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands: What are the implications of this command?（）

A、It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database. B、It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database. C、It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure. D、It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

点击查看答案

第3题

[单选题] You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

A、It must be executed from the Oracle Database 11g environment. B、It must be executed only after the SYSAUX tablespace has been created. C、It must be executed from the environment of the database that is being upgraded. D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

点击查看答案

第4题

[多选题] You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

A、The ASM compatibility attribute controls the format of the disk group metadata. B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group. C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group. D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group. E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

点击查看答案

第5题

[] Which correctly describes the tiers of the Oracle Workflow architecture?（）

A、A. Oracle Database tier and Application server tier only B、B. Oracle Database tier, Application server tier, and End-user client tier only C、C. Oracle Database tier, Application server tier, and Development client tier only D、D. Oracle Database tier, Application server tier, Development client tier, and End-user client tier

点击查看答案

第6题

[] You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands: Which two statements are true regarding the tasks accomplished with these commands?（） You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:

A、A. They import all metadata from the RCAT10 catalog. B、B. They unregister the database from the RCAT10 catalog. C、C. They do not register the databases registered in the RCAT10 catalog. D、D. They register all databases registered in the RCAT10 catalog.

点击查看答案

第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

点击查看答案

第8题

[单选题] Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started. B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started. C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration. D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

点击查看答案

第9题

[] Integration between （） multidata sources and （） is defined as the Grid Link for RAC.

A、A.Oracle WebLogic Server; Oracle Database B、B.Oracle WebLogic Server clusters; Oracle Database C、C.Oracle WebLogic Server clusters; Oracle Database RAC D、D.Oracle OC4J; Oracle Database RAC E、E.Oracle WebLogic Server; Oracle OC4J

点击查看答案

第10题

[单选题] You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables: What is the outcome of the above commands?（）

A、They execute and create a virtual catalog for pre-Oracle 11g clients. B、They produce an error because PROD1 and PROD2 databases belong to the older version. C、They produce an error because you need to connect as CATOWNER to execute this packaged procedure. D、They produce an error because you need to connect to the target database to execute this packaged procedure.

点击查看答案

请使用微信扫码支付