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 […]

Read More

What should the repeat interval of the schedule be set to?

You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to? A.FREQ= MONTHLY; BYDAY = 2FRI; B.FREQ= MONTHLY; BYDAY = FRI2; C.FREQ= MONTHLY; BYDAY = -2FRI; D.FREQ= MONTHLY; BYDAY = FRI(2); Explanation:Examples of Calendaring ExpressionsThe following examples […]

Read More

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 […]

Read More

Which three file types are managed by Data Pump jobs? (Choose three.)

Which three file types are managed by Data Pump jobs? (Choose three.) A.out files B.log files C.alert files D.SQL files E.error files F.dump files Explanation:There are three types of files managed by Data Pump jobs:* Dump files to contain the data and metadata that is being moved* Log files to record the messages associated with […]

Read More

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? […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

What is the result of executing this command?

You have three production database, HRDB, FINDB, and ORGDB, that use the ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command? A.All the instances, including the ASM instance, are shut down in the […]

Read More