Oracle Database Administration II - 1Z1-083 Exam Practice Test

Question 1

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

C. In a PDB plan, subplans may be used with up to eight consumer groups.

D. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

E. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

Correct Answer: A,D

Question 2

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

A. AWR reports can be generated while connected to any container.

B. ADDM can run in a nonroot container.

C. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

D. AWR snapshots can be created in a PDB.

E. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

F. AWR snapshots can be created in CDB$ROOT.

Correct Answer: B,D,F

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

Which three are true about a whole database backup? (Choose three.)

A. It can be created only by using RMAN.

B. It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C. It can consist of either backup sets or image copies.

D. It can be inconsistent.

E. It is the only possible backup type for a database in NOARCHIVELOG mode.

F. It can be consistent.

Correct Answer: C,D,F

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

A. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

B. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

C. It can be used for applications and middleware.

D. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

E. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

Correct Answer: C,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

B. The Oracle Application Express configuration should be updated after upgrading Oracle Database.

C. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

D. The new extended data type capability must be enabled by running the utlrp.sql script

E. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

Correct Answer: B,D,E

Question 6

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

A. It is automatically synchronized with its application root PDB when an application is upgraded.

B. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

C. It cannot be dropped from its application container.

D. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

E. It cannot be added to an application container after the application container has already been created.

F. It is automatically synchronized with its application root PDB when an application is installed.

G. It is not required in an application container.

Correct Answer: B,D,G

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Which two statements are true about the Oracle Database server during and immediately after SHUTDOWN IMMEDIATE?

A. All existing connections to the database instance remain connected until all transactions either roll back or commit.

B. New connection requests made to the database instance are refused.

C. Uncommitted transactions are rolled back automatically.

D. Uncommitted transactions are allowed to continue to the next COMMIT.

E. All existing transactions are aborted immediately.

Correct Answer: B,C

Question 8

Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A. A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

B. A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

C. A PDB Lockdown profile can be created in CDB$ROOT .

D. A PDB Lockdown profile can be created in a regular PDB.

E. A PDB Lockdown profile can be created in an application root.

Correct Answer: C,E

Question 9

Examine the description of the SALES table:

Examine this statement:
CREATE TABLE mysales (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true?

A. MYSALES is created with no rows.

B. MYSALES will have no constraints defined regardless of which constraints might be de-fined on SALES.

C. MYSALES is created with 2 rows.

D. MYSALES has NOT NULL constraints on any selected columns which had that constraint in the SALES table.

E. MYSALES is created with 1 row.

Correct Answer: A,D

Question 10

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assiged in the CDB?

A. five

B. six

C. seven

D. three

E. eight

Correct Answer: C

Question 11

You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is never redacted for the EMP_V.SAL column.

B. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

C. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

E. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

Correct Answer: A,B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Oracle Database Administration II - 1Z1-083 Exam Practice Test

Latest Update

Useful Links

Contact Us