默认题库 - OCP 11G认证

多选题

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）

A must contain all of the characters defined in B
B. A must be Unicode
C. The encoded values in A must match the encoded values in B for all characters defined in B
D. A must be a multibyte character set
E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

查看答案

单选题

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）

A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS&e

查看答案

单选题

While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.

A. 2, 3, 5
B. 1, 2, 4
C. 1, 2, 4, 5
D. 1, 2, 3, 4, 5

查看答案

单选题

Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）

A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor

查看答案

单选题

You have the following requirements in relation to the detection of block corruption for your database instance: 1. Check for logical self-consistency of data blocks when modified in memory. 2. Checksums are calculated before and after the block change. 3. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically? （）

A. Set the DB_SECUREFILE parameter to PERMITTED
B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

查看答案

单选题

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.

查看答案

单选题

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

A. It updates the existing SQL profiles with current statistics
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually

查看答案

多选题

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?（）

A. It can be used to allow the access privilege settings for users but not roles.
B. It can be used to allow the access privilege settings for users as well as roles.
C. It can be used to control the time interval for which the access privilege is available to a user.
D. It can be used to selectively restrict the access for each user in a database to different host computers.
E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

查看答案

单选题

Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）

A. only encryption and compression settings for all SecureFile LOBs
B. only encryption and deduplication settings for only SecureFile CLOBs
C. deduplication, encryption, and compression settings for all SecureFile LOBs
D. deduplication, encryption, and compression settings only for SecureFile CLOB

查看答案

多选题

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.

查看答案