Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

1z0-083 Oracle Database Administration II Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Oracle 1z0-083 Oracle Database Administration II certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Oracle 1z0-083 Premium Access     Download Demo    
Page: 4 / 5
Total 286 questions

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

A.

It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

B.

It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

C.

A Virtual Private Catalog used to register a container database must be created in a pluggable database.

D.

A Virtual Private Catalog used to register a container database can be created in a pluggable database.

E.

It is always possible for RMAN to connect to a pluggable database as a target.

F.

A Virtual Private Catalog used to register a container database can be created in a non-container database.

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

A.

It succeeds.

B.

It fails because no parallel channels are allocated for the auxiliary database.

C.

It fails because connection to the AUXILIARY instance must be as SYSDBA.

D.

Itsucceeds only if the target database is greater than 400M.

E.

No catalogued backup of the TARGET is used to duplicate the database.

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

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 datanase 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.

Choose three. Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?

A.

If an RMAN command fails, the output will only identify the command that failed.

B.

Some messages in the error stack are not errors.

C.

If an RMAN command fails, the output will identify the channel ID where the failure occurred. D)Media Management errors appear as a line with "Additional information" and a number.

D.

Media Management errors appear as a line with "sbtio" and a number.

E.

Media Management errors appear as a line with "sbtio".

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.

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

A.

It has the same common users defined as does CDB1.

B.

It has only local roles.

C.

It has the same number of roles as CDB1.

D.

Service PDB1 is created for remote logins to PDB1.

E.

It is in mount state after creation.

F.

It has no local users.

Choose two. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?

A.

The response file can specify the path of the sudo program.

B.

The response file must contain the root or sudo password.

C.

Silent install always runs operating scripts automatically.

D.

The response file can specify the root or sudo password.

E.

The installer will prompt for the root or sudo password.

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

A.

SBT tape compression can be used even if no RMAN compression is configured.

B.

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

C.

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

D.

SBT tape compression and RMAN backup compression should be used in parallel.

E.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?

A.

user-managed backups of data files and control files

B.

flashback logs

C.

RMAN backups that are obsolete

D.

archived redo log files that have multiple copies in a different archive location

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.

Which two statements are true about the Database Configuration Assistant (DBCA)?

A.

It can configure Automatic Storage Management (ASM) diskgroups.

B.

It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

C.

It can be used to add a new tablespace.

D.

It can be used to create a database template from an existing database.

E.

It can generate SQL database creation scripts.

choose two Which two statements are true about encrypted backups performed by using RMAN?

A.

Transparent encryption of backups uses an encryption wallet.

B.

Image copy backups can be created by using password encryption.

C.

A password encryption of backups uses the password while creating and restoring backups.

D.

Encrypted backups can only be written to disk.

E.

A database uses the same encryption key for every encrypted backup.

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

A.

to specify a default tablespace in a PDB cloned from another PDB in the same CDB

B.

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

C.

to include specific user tablespaces only when relocating a PDB

D.

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

E.

to exclude a temp tablespace when plugging in a PDB

F.

to specify the list of tablespaces to include when creating a PDB from the CDB seed

Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?

A.

when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

B.

when a new tablespace is added to a registered target database

C.

when a backup of the current control file is created

D.

when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

E.

when the target is first registered

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------0 SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1); SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE -------------1 After changing the value, you notice that FULL redaction continues to redact numeric data with zero.What must you do to activate the new default value for numeric full redaction?

A.

Re-enableredactionpoliciesthatuseFULLdataredaction.

B.

Re-createredactionpoliciesthatuseFULLdataredaction.

C.

Re-connect the sessions that access objects with redaction policies defined on them.

D.

Flushthesharedpool.

E.

Restart the database instance. Correct

Choose two. Which two are true about RMAN backups when using a media manager?

A.

A media manager always writes RMAN requested backups to tape.

B.

A media manager is required to create RMAN image copies.

C.

A media manager is required to create RMAN proxy copies.

D.

The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

E.

By default, a request for a proxy copy may result in a backup set being created.

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

A.

It is used to change failure priority only for HIGH or LOW priorities.

B.

It is used to execute the advised repair script.

C.

It is used to change failure priority only for the CRITICAL priority.

D.

It is used to explicitly close the open failures.

E.

It is used to inform the database about the repair after the repair script executes.

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command

A.

RMAN must be connected to the target database instance and the auxiliary instance.

B.

A most recent backup set of the PROD database must exist.

C.

Flashback must be enabled for the PROD database.

D.

The target database must be in MOUNT state.

Choose three. Which three are true about the tools for diagnosing Oracle Database failure situations?

A.

RMAN can always repair corrupt blocks.

B.

Flashback commands help with repairing physical errors.

C.

The ADR can store metadata in an Oracle Database repository.

D.

The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

E.

The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

F.

The Data Recovery Advisor uses the ADR.

Choose two. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?

A.

The entire PGA is located in the System Global Area (SGA) when using shared servers.

B.

PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

C.

The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

D.

The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

E.

Sorts and Hash Joins use PGA memory.

Oracle 1z0-083 Premium Access     Download Demo    
Page: 4 / 5
Total 286 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved