Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Apr 14, 2026

Add To Cart

Question 1

Choose three. Which three are true about the FLASHBACK DATABASE feature?

A : FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

B : It requires that the target database be in ARCHIVELOG mode.

C : FLASHBACK LOGS are archived after a log switch.

D : A database can be flashed back using SQL*PLUS.

E : It always generates REDO and UNDO.

F : Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

Answer: A,B,D

Question 2

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

A : The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B : The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C : The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D : The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Answer: B

Question 3

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

A : The REVENUE table must be a list-partitioned table.

B : The CONTAINERS clause cannot be used in queries on the REVENUE table.

C : The REVENUE table partitions are not pruned across the PDBs automatically

D : The REVENUE table must be a composite-partitioned table.

E : The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.

Answer: C,D

Question 4

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 : SPFILE backups can be created while connected to an application root PDB.

D : The BACKUP DATABASE PLUS ARCHIVE LOG 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.

Answer: A,B

Question 5

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

A : It uses multisection backup.

B : It uses parallelization for the backup set.

C : It uses asynchronousI/O for the backup.

D : It creates compressed backup sets.

Answer: B

Page: 1 / 57

Total 285 Questions | Updated On: Apr 14, 2026

Add To Cart