New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Download Full Version 1z0-083 Oracle Exam

Page: 14 / 21
Question 56

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Options:

A.

Tables or table partitions can be recovered by using an auxiliary instance only.

B.

Tables or table partitions with a foreign key cannot be recovered.

C.

Tables or table partitions can be recovered only when the database is in mount state.

D.

Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

E.

Tables with not null constraints cannot be recovered.

Question 57

Choose two. Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SESSION SET CONTAINER=app1_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0'; Pluggable database altered SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC; Pluggable database altered. Which two are true?

Options:

A.

USER1 can connect to CDB1.

B.

USER1 can connect to APP1_ROOT and APP1_PDB1.

C.

USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

D.

USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

E.

USER1 can connect only to APP1_ROOT.

Question 58

Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

Options:

A.

to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

B.

to generate an XML metadata file from any unplugged PDB

C.

to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

D.

to generate a . pdb archive file for any PDB in the current CDB

E.

to generate an XML metadata file that describes the current plugged-in PDB

Question 59

Choose three. Which three are true about backing up the control file?

Options:

A.

It cannot be backed up manually as a binary copy.

B.

It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re¬creation when a database backup occurs.

C.

It can be backed up manually as a binary copy.

D.

It can get backed up automatically as a binary copy.

E.

It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

F.

It can be backed up manually as a trace file containing SQL statements for control file recreation.

Page: 14 / 21
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: Dec 22, 2024
Questions: 286
1z0-083 pdf

1z0-083 PDF

$25.5  $84.99
1z0-083 Engine

1z0-083 Testing Engine

$28.5  $94.99
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$40.5  $134.99