Best 1Z0-083 Exam Dumps for the Preparation of Latest Exam Questions [Q52-Q69]

4/5 - (1 vote)

Best 1Z0-083 Exam Dumps for the Preparation of Latest Exam Questions

1Z0-083 Actual Questions 100% Same Braindumps with Actual Exam!

Oracle 1Z0-083 exam is a certification exam designed for database administrators who want to validate their skills and knowledge in managing an Oracle database. It measures the candidate’s ability to perform complex database administration tasks such as backup and recovery, database tuning, database security, and high availability. Passing 1Z0-083 exam is a requirement for earning the Oracle Database Administration II certification.

Oracle 1Z0-083 certification is highly valued in the industry and is recognized by employers worldwide. It is a testament to an individual’s expertise in database administration and can open up new career opportunities. Oracle Database Administration II certification is also a prerequisite for many advanced Oracle certifications, such as the Oracle Certified Expert (OCE) in Oracle Database Performance and Tuning and the Oracle Certified Master (OCM) in Oracle Database Administration.

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

The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

NO.53 Which three are true about an application seed pluggable database (PDB)? (Choose three.)

It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

It is automatically synchronized with its application root PDB when an application is installed.

It cannot be dropped from its application container.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

It is not required in an application container.

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

Recovery begins from the beginning of the CURRENT redo log group.

Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

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.

Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

NO.55 A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

when any archived log from, before, or after the most recent backup is corrupt.

after losing all copies of the control file

after losing an archived log from after the most recent backup

after losing an archived log from before the most recent backup

after losing the SYSTEM tablespace

NO.56 Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

It is an Oracle Database service

It cannot be used to upgrade Oracle Database homes.

It can be used to provision applications.

It can be used to patch Grid Infrastructure homes containing Oracle Restart.

It can be used to provision middleware.

NO.57 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?

It has the same common users defined as does CDB1.

It has only local roles.

It has the same number of roles as CDB1.

Service PDB1 is created for remote logins to PDB1.

It is in mount state after creation.

It has no local users.

NO.58 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? (Choose two.)

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

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

when a new tablespace is added to a registered target database

when a backup of the current control file is created

when the target is first registered

NO.59 Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

All metrics are instance related.

Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

A space usage management alert is automatically cleared after the underlying problem is resolved.

They are generated by SMON when a tablespace is 97% full.

Metrics are statistical counts for a specific unit.

STATISTICS_LEVELmust be set to ALLto generate alerts.

NO.60 Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

A lost SPFILE can be recovered from memory using SQL*PLUS.

A lost password file can be re-created with SQL*PLUS.

A lost TEMPFILE must always be re-created manually.

A lost password file can be manually re-created with the orapwd utility.

A lost PFILE can be re-created alert.log using SQL*PLUS.

A lost index tablespace can be re-created without performing any recovery.

NO.61 Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?

he SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.

A backup of pdb1 and pdb5 must exist before executing the command.

The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

A backup of CDB and pdb1 and pdb5 must exist before executing the command.

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

NO.62 Choose three. Which three are true about Audit policies in container databases (CDBs)?

All audit records are written to the audit trail in CDB$ROOT .

Application-common unified audit policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

A common unified audit policy can be created at the CDB level.

A common unified audit policy can be created at the application root level.

An application PDB cannot have a local audit policy.

NO.63 Which three are located by using environment variables? (Choose three.)

the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

the location of Oracle Net Services configuration files

the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

default directories for temporary files used by temporary tablespaces

the temporary disk space used by Oracle Installer during installation

the maximum number of database files that can be opened by a database instance

NO.64 Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

CDB1, PDB$SEED, PDB1, and PDB2

PDB$SEED, PDB1, and PDB2only

CDB1and PDB$SEEDonly

CDB1, PDB1, and PDB2only

CDB1, PDB$SEED, and PDB1 only

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

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

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

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.

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

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

Application-common TSDP policies are always container specific.

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

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

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.

NO.68 Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

The base catalog must be enabled for Virtual Private Catalog use.

The target PDB must be registered in a Virtual Private Catalog.

The target PDB must be registered in a base catalog.

NO.69 Which operating system group is NOT needed to perform an Oracle Database installation?

OSASM

OSKMDBA

OSDBA

OSOPER

OSRACDBA