Online Access Free 1z1-062 Exam Questions

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A.Implementing Database Resource Manager
• B.Enabling resumable timeout for user sessions
• C.Decreasing the value of the IDLE_TIME resource limit in the default profile
• D.Setting a metric threshold

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:
SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)

• A.The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.
• B.Only queries on fixed views execute without errors until you run the catctl.pl script.
• C.All system triggers are disabled during the upgrade process.
• D.All job queues remain active during the upgrade process.
• E.Only connections AS SYSDBA are allowed during the upgrade process.

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

• A.It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
• B.It can configure Automatic Storage Management (ASM) diskgroups.
• C.It can generate SQL database creation scripts.
• D.It can be used to add a new tablespace.
• E.It can be used to create a database template from an existing database.

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?

• A.a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
• B.a Data Warehouse database template, with the dedicated server mode option and AMM enabled
• C.a General Purpose database template with default memory allocation
• D.a default database configuration

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

• A.Create the CREATE_TEST procedure with invoker's rights.
• B.Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
• C.Create the CREATE_TEST procedure with definer's rights.
• D.Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.