Category «1Z0-040»

The ______ procedure is used to determine which statements are needed to make your materialized view eligible

The ______ procedure is used to determine which statements are needed to make your materialized view eligible for fast refresh and usable for general rewrite. A.REFRESH B.TUNE_MVIEW C.REGISTER_MVIEW D.EXPLAIN_REWRITE E.REFRESH_DEPENDENT Explanation:The TUNE_MVIEW procedure shows you how to optimize your CREATE MATERIALIZED VIEW statement and to meet other requirements such as materializedview log and rewrite equivalence …

What identifies and helps to resolve performance problems relating to the execution of SQL statements by recom

The ______ identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes, materialized views, or materialized view logs to create, drop, or retain. A.Undo Advisor B.MTTR Advisor C.Memory Advisor D.Segment Advisor E.SQL Tuning Advisor F.SQL Access Advisor Explanation:The SQL Access Advisor helps you achieve your performance goals …

Which parameter would be ignored while starting up the instance?

You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database. INSTANCE_TYPE = RDBMSLARGE_POOL_SIZE = 8MBBD_BLOCK_SIZE = 4KLOG_ARCHIVE_DEST = +dgroupALOG_ARCHIVE_FORMAT = “$ORACLE_SID_%s_%t.%t”DB_CREATE_FILE_DEST = +dgroupACOMPATIBLE = 10.1.0.2.0CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance? …

Which statement regarding the implementation of shared policy functions is correct?

Which statement regarding the implementation of shared policy functions is correct? A.The policies need to have the same name. B.The policy type must be DBMS_RLS.DYNAMIC. C.The shared policy function can be enforced on any number of objects. D.The shared policy function cannot be enforced on more than two objects. Explanation:Both static and context-sensitive policies can …

The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to __

You created a database (using Database Configuration Assistant [DBCA]) by using one of the default templates. The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to ________. A.USERS B.SYSTEM C.SYSAUX D.EXAMPLE Explanation:USERSThis tablespace is used to store permanent user objects and data. Like the TEMP tablespace, every database …

Which line of the command would cause an error?

Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables. 1. CREATE TABLE employee_ext2. (employee_id, first_name, department_name)3. ORGANIZATION EXTERNAL4. (5. TYPE ORACLE_LOADER6. DEFAULT DIRECTORY ext_dir7. LOCATION (’emp1.dmp’)8. )9. PARALLEL10. AS11. SELECT e.emplyee_id, e.first_name, e.last_name, department_name12. FROM employees e, departments d; Which line of the command would cause an error? A.line …