Free Oracle 1z0-083 Practice Exam with Questions & Answers | Set: 3

Name: How to Pass 1z0-083 Exams
Brand: Examstrack
SKU: 1z0-083
Price: 36.75 USD
Availability: InStock

Questions 21

choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

Options:

All historical data older than two years, if any, is purged from the flashback archive FDA1.

An error is returned because the retention period cannot be reduced.

All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years

All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Oracle 1z0-083 Premium Access

Keyon

18-Jun-2025

examstrack.com's real exams content is the ultimate 1z0-083_V2.0 preparation tool.

Questions 22

Identify three benefits of Unified Auditing.

Options:

Decreased use ofstorage to store audit trail rowsin the database.

It improves overall auditing performance.

It guarantees zero-loss auditing.

The audit trail cannot be easily modified because it is read-only.

It automatically audits Recovery Manager (RMAN) events.

Questions 23

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

Options:

After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

After the change, only one undo tablespace can exist in CDB$ROOT.

After the change, any user with the required privilege can create an undo tablespace in the PDBs.

Undo tablespaces existing in PDBs must be dropped before the change.

After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Questions 24

Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

Options:

poorly trained users who do not commit transactions

the number of tablespaces containing tables updated by a transaction

issuing multiple savepoints during a transaction

the number of data files containing extents belonging to tables updated by a transaction

poorly written SQL

Questions 25

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Options:

Create the PDB1 application PDB and synchronize it with poB$SEED.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

Create the PDB1 application PDB and install HR_APP in it.

Create an application seed, and install HR_APP in it.

Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Questions 26

Which two are true about automatic block repair? (Choose two.)

Options:

Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

It is not possible for media corrupt blocks.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Questions 27

A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

Options:

V$SESSION_EVENT

V$SESSTAT

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION

Questions 28

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Options:

cloning a remote container database in interactive mode

cloning a remote pluggable database in silent mode

relocating a remote pluggable database in interactive mode

relocating a remote container database in silent mode

cloning a remote container database in silent mode

relocating a remote pluggable database in silent mode

relocating a remote container database in interactive mode.

Questions 29

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?

Options:

user-managed backups of data files and control files

flashback logs

RMAN backups that are obsolete

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

Questions 30

choose three Which three are true about unified auditing in full mode?

Options:

The unified audit trail is written to a read-only table.

The unified audit trail is written to a read-only external file.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

Audit records are created for SYS.