Oracle 1z0-083 Free Practice Exam & Test Training

Question 1

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
C. An existing Oracle base can be used.
D. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
E. Existing Oracle Database instances must be shut down before starting the upgrade.
F. Only the grid user can perform the upgrade.

Answer : DEF

Reference:
https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB

Question 2

A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)

A. after losing a SYSAUX tablespace data file
B. after losing all members of an INACTIVE online redo log group
C. after losing all members of the CURRENT online redo log group
D. after losing all copies of the control file
E. after losing an UNDO tablespace that is in use

Answer : BD

Question 3

Which two are true about instance recovery? (Choose two.)

A. It is not possible if an archived log is missing.
B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
C. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
D. It is performed by the Recovery Writer (RVWR) background process.
E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.
F. It is performed automatically while the database remains in MOUNT state. Then the database is opened.

Answer : EF

Question 4

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
B. Index balanced B*Tree height is considered when evaluating the cost of using an index.
C. The Statistics Advisor can help recommend the best way to gather statistics.
D. Statistics collected using DBMS_STATS always yield the best optimizer result.
E. The Statistics Advisor generates actions for all recommendations.

Answer : CD

Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-advisor.html#GUID-D81A7708-FDA0-45BB-A6E2-
103858B047AE

Question 5

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to PDB2.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be recovered while connected to CDB$ROOT.

Answer : BDF

Question 6

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
C. A new PDB is automatically created when importing a non-CDB into a CDB.
D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Answer : DE

Question 7

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

A. using Database Replay
B. using SQL Developer
C. using Oracle Data Pump
D. using operating system file copy utilities
E. using Database Upgrade Assistant
F. using the CREATE TABLE AS SELECT SQL statement

Answer : DEF

Question 8

Which two are true about Oracle instance recovery? (Choose two.)

A. Recovery begins from the beginning of the CURRENT redo log group.
B. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
D. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened.
E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Answer : BD

Question 9

Examine this configuration:
1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCL uses disk group +FRA for the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:

What is the outcome?

A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
B. Only the ORCL database instance is started.
C. Only the ORCL database and the ASM instances are started.
D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Answer : D

Question 10

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
C. RMAN ג€pushesג€ the backups of the database to be duplicated over the network to the auxiliary instance.
D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Answer : ABGH

Reference:
http://oradb-srv.wlv.ac.uk/ora12c/RCMRF/rcmsynta020.htm

Question 11

Which three are true? (Choose three.)

A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
B. Application-common TSDP policies are always container specific.
C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
G. Unified auditing can be automatically synchronized to all application PDBs in an application container.

Answer : ACG

Question 12

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

A. By default, AWR snapshots are taken every 60 minutes.
B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
C. By default, AWR snapshots are retained for 7 days.
D. The taking of AWR snapshots can be disabled.
E. AWR data is stored in the SYSTEM tablespace.

Answer : ABD

Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

Question 13

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.

Answer : BC

Question 14

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
B. An application seed PDB is created for APP1.
C. An application root PDB is created for APP1.
D. A default service is created for the application root APP1.
E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
F. APP1 can never be unplugged.

Answer : ABE

Question 15

Which two are true about RMAN encryption? (Choose two.)

A. RMAN encryption keys are stored in a database keystore.
B. RMAN can encrypt the Oracle Database password file.
C. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
D. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
E. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.