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: Nov 26, 2025

Add To Cart

Question 1

Choose three. Which three are true about recovering tables using RMAN?

A : RMAN can recover tables owned by the SYSTEM user.

B : RMAN can recover tables owned by the SYS user.

C : RMAN can recover tables in the SYSTEM tablespace.

D : RMAN always uses an auxiliary instance.

E : RMAN can recover a table after a DDL operation has altered the table structure

F : RMAN can recover tables in the SYSAUX tablespace.

G : RMAN can recover tables in a standby database.

Answer: A,D

Question 2

Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?

A : Re-create or migrate the password file to the Oracle Database 12c format

B : Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C : Copy the password file from a sample file in the DBS dierectory

D : Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.

Answer: A,B

Question 3

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

A : an operating system user to own this installation

B : the Oracle Inventory group oinstall

C : an operating system account called grid

D : a group called dba

E : the installation of Oracle ASMLIB

Answer: A,B

Question 4

Which two are true about Oracle Flashback features? (Choose two.)

A : FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

B : FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

C : FLASHBACK TABLE can undrop a column.

D : FLASHBACK DROP can undrop an index when undropping a table.

E : After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Answer: A,D

Question 5

Choose two. Which two are true about various Oracle security and auditing capabilities?

A : Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

B : Application-common TSDP policies are always container specific.

C : Application-common OLS policies can be created only if all the PDBs in the application container are closed.

D : Unified auditing can be automatically synchronized to all application PDBs in an application container.

E : Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

Answer: A,D

Page: 1 / 57

Total 285 Questions | Updated On: Nov 26, 2025

Add To Cart