Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 8 / 9
Total 286 questions

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

A.

It can be used for applications and middleware.

B.

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

C.

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

D.

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

E.

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

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.

COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A.

It will return an error because creation of a local role is not allowed in CDB$ROOT.

B.

ROLE1 will be created only in CDB$ROOT.

C.

It will return an error because common roles must start with C##.

D.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E.

ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Choose two. Which two are true about backup set compression using RMAN default compression?

A.

Compressed backups cannot have a section size defined.

B.

Compressed backups can be written only to media.

C.

Binary compression adds CPU overhead to backup operations.

D.

Unused blocks below the high water mark are backed up.

E.

Compression can be done only for locally managed tablespaces.

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

A.

It will create a multitenant container database (CDB) with only the root opened.

B.

ItwillcreateaCDBwithrootopenedandseedreadonly.

C.

It will create a CDB with root and seed opened and one PDB mounted.

D.

It will create a CDB that must be plugged into an existing CDB.

E.

ItwillcreateaCDBwithrootopenedandseedmounted.

Which three are true in Oracle 19c and later releases? (Choose three.)

A.

If the password file location changes, then the new location is used automatically by the Oracle Server.

B.

Schema Only accounts can be granted administrator privileges.

C.

All the Oracle-supplied accounts are Schema Only accounts.

D.

Privilege Analysisisincluded in Oracle Enterprise Edition and no longer requires Database Vault. E) Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

E.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Choose two. Which two are true about an RPM-based Oracle Database installation?

A.

It includes the Oracle Preinstallation RPM.

B.

From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

C.

It requires an Unbreakable Linux Network (ULN) subscription.

D.

It performs a software-only Oracle Database installation.

E.

It uses a service configuration script to create a single-instance database as part of the installation.

Which three statements are true about the keystore storage framework for transparent data encryption?

A.

It facilitates and helps to enforce keystore backup requirements.

B.

It handles encrypted data without modifying applications.

C.

It enables a keystore to be stored only in a file on a file system.

D.

It enables separation of duties between the database administrator and the security administrator.

E.

It transparently decrypts data for the database users and applications that access this data.

F.

It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Which three are true about an application container?

A.

It can contain a single application

B.

Two application containers can share an application seed PDB.

C.

It must have an application root PDB.

D.

An application PDB can belong to multiple application containers.

E.

It must have an application seed PDB.

F.

It can contain multiple applications.

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

A.

APP1_USER1can be created in PDB1.

B.

APP1_USER1can be created in CDB1.

C.

APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

D.

C##_APP_USER1 can be created in CDB1.

E.

P1_USER1can be created in CDB1.

F.

C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

Which two are true about automatic block repair? (Choose two.)

A.

Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

B.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

C.

Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

D.

It is not possible for media corrupt blocks.

E.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.