1z0-062 무료 덤프문제 온라인 액세스

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

• A.The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
• B.The transaction in Scott's session is rolled back and the tablespace becomes readonly.
• C.The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
• D.The command fails as a transaction is still pending.

Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)

• A.the private SQL area
• B.the SQL Access Advisor
• C.the AWR Compare Periods Report
• D.the Automatic Workload Repository (AWR)
• E.the Automatic Database Diagnostic Monitor (ADDM)
• F.the shared SQL area

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

• A.The job is terminated but the gathered statistics are not published.
• B.The job continues to run until all statistics are gathered.
• C.The job is terminated and the gathered statistics are not saved.
• D.The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

• A.Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B.The schema for the common user C # # A_ADMIN can be different in each container.
• C.The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• D.The command will create a user in the root container only because the container clause is not used.
• E.The command will, create a common user whose description is contained in the root and each PDB.

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)

• A.Sequential recompilation of any stored PL/SQL code
• B.Sequential recompilation of Java code
• C.Sequential recompilation of only the stored PL/SQL code
• D.Parallel recompilation of Java code
• E.Parallel compilation of only the stored PL/SQL code
• F.Parallel recompilation of any stored PL/SQL code