Free Oracle 1Z0-083 Exam Questions

Question 1

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

A : Create the PDB1 application PDB and synchronize it with poB$SEED.

B : Create the PDB1 application PDB and synchronize it with HR_ROOT.

C : Create the PDB1 application PDB and install HR_APP in it.

D : Create an application seed, and install HR_APP in it.

E : Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Answer: A,B

Question 2

choose two Which two statements are true about encrypted backups performed by using RMAN?

A : Transparent encryption of backups uses an encryption wallet.

B : Image copy backups can be created by using password encryption.

C : A password encryption of backups uses the password while creating and restoring backups.

D : Encrypted backups can only be written to disk.

E : A database uses the same encryption key for every encrypted backup.

Answer: A,C

Question 3

Choose two. Which two are true about memory advisors?

A : If Automatic Memory Management is enabled, no memory advisors are available.

B : If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C : All memory advisors use data from Automatic Workload Repository

D : If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E : If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Answer: C,D

Question 4

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

A : Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

B : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D : Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

E : Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer: A,C

Question 5

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADAT 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A : SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B : SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows

C : It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

D : It will return an error because EMP is not empty in APP_ROOT.

E : It will return an error because EMP.SAL is empty in APP_ROOT.

Answer: D