Free 1z0-083 Exam Dumps

Question 21

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
1Z0-083 dumps exhibit
Which two are true? (Choose two.)

A. oracle will be an owner of the Oracle Inventory.
B. oracle must be the owner of every Oracle Database installation.
C. oracle can own an OracleDatabase installation but not an Oracle Grid Infrastructure installation.
D. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
E. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Correct Answer:CD

Question 22

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.

Correct Answer:BC

Question 23

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
C. SPFILEbackups can be created while connected to an application root PDB.
D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.
E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Correct Answer:AB

Question 24

Which three are true In Oracle 19c and later releases?

A. Tablespaces always remain In read/write mode during transportable tablespace operations.
B. Simultaneous data pump jobs can be limited at thepluggable database (PDB) level.
C. Tablespaces never remain In read/write mode during transportable tablespace operations.
D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
F. A transportable data pump import can leave a plugged-in tablespace In read/write mode.

Correct Answer:ADE

Question 25

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A. It can be performed using anauxiliary instance managed by a DBA.
B. It can be used to recover a truncated table.
C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
D. RMAN always includes tablespaces containing undo segments in the recovery set.
E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
F. flashback database must be enabled for it to work.
G. It can be used to recover a dropped tablespace.
H. It can be performed using an auxiliary instance managed by RMAN.

Correct Answer:AEFH