Online Access Free 1z1-062 Exam Questions

Which three statements are true about SQL plan directives? (Choose three.)

• A.They are used to gather only missing statistics.
• B.They are tied to a specific statement or SQL ID.
• C.They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• D.They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• E.Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
• F.They instruct the optimizer to create only column group statistics.

Which three statements are true about Oracle Restart? (Choose three.)

• A.It can be configured to automatically attempt to restart various components after a hardware or software failure.
• B.It can be used to only start Oracle components.
• C.It runs periodic check operations to monitor the health of Oracle components.
• D.It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• E.While starting any components, it automatically attempts to start all dependencies first and in proper order.

Which statement is true about the Oracle central inventory directory (oraInventory)?

• A.If ORACLE_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.
• B.oraInventory must not be shared by all Oracle software installations on a single system.
• C.Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.
• D.lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)

• A.It fails because no SQL *Loader control file location is specified.
• B.It fails because no SQL *Loader data file location is specified.
• C.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

• A.A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.
• B.A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
• C.A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.
• D.A scheduler window can control resource allocation by itself.
• E.A job class specifies a scheduler window that will be open when that job class becomes active.