New 2025 Latest Questions 1Z0-083 Dumps – Use Updated Oracle Exam [Q39-Q56]

1Z0-083 Oracle

admin -

January 11, 2025

4/5 - (1 vote)

New 2025 Latest Questions 1Z0-083 Dumps – Use Updated Oracle Exam

Latest 1Z0-083 Exam Dumps Oracle Exam from Training Expert DumpsTests

Oracle 1Z0-083 Certification Exam is a challenging but rewarding exam that tests the skills and knowledge of experienced database administrators. By preparing thoroughly and demonstrating their mastery of Oracle database administration, candidates can earn this valuable certification and take their careers to the next level.

NO.39 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.40 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.41 A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?

Data file 24 can be recovered only while connected to PDB2.

Data file 24 can be restored only while connected to CDB$ROOT.

Data file 24 can be recovered while connected to CDB$ROOT.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

Data file 24 can be restored only while connected to PDB2.

Data file 24 can be recovered while connected to PDB2.

NO.42 You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall) , 54322(dba) Which two are true?

oracle will be granted the sysasm privilege when installing the Oracle Database software.

oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

oracle will be an owner of the Oracle Inventory.

The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

oracle must be the owner of every Oracle Database installation.

NO.43 Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

Media Management messages for SBT devices are always written to sbtio.log.

RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

RMAN error stacks should be read from the top down as that is the order in which errors are generated.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

Media Management messages for SBT devices are written to an Oracle trace file.

The sbtio.log contains information written by the media management software, not Oracle Database. Thus, you must consult your media vendor documentation to interpret the error codes and messages. If no information is written to the sbtio.log, then contact your media manager support to ask whether they are writing error messages in some other location, or whether there are steps you must take to have the media manager errors appear in sbtio.log.
Read the messages from the bottom up, because this is the order in which RMAN issues the messages. The last one or two errors displayed in the stack are often the most informative.
https://docs.oracle.com/database/121/BRADV/rcmtroub.htm#BRADV89875

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

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

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

Flashback commands help with repairing physical errors.

RMAN can always repair corrupt blocks.

The ADR can store metadata in an Oracle Database repository.

The Data Recovery Advisor uses the ADR.

NO.45 Which three are true about performing an Oracle Database install on Linux?

The runfixup.sh script can install missing RPMs.

The Oracle PreinstallationRPMcan be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It can be done before installing Grid Infrastructure for a Standalone Server.

The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It can be done after installing Grid Infrastructure for a Standalone Server.

The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.

It allows you to select the languages supported by the Oracle database server.

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

Create an application seed, and install HR_APP in it.

Create the PDB1 application PDB and install HR_APP in it.

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

Create the PBD1 application PDB and synchronize it with HR_ROOT.

Create the PBD1 application PDB and synchronize it with PDB$SEED.

NO.47 Which two are true about RMAN duplexed backup sets? (Choose two.)

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

https://docs.oracle.com/cd/E18283_01/backup.112/e10642/rcmbckad.htm#i1006180
“You cannot back up from tape to tape or from tape to disk: only from disk to disk or disk to tape.”
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-
73642FF2-43C5-48B2-9969-99001C52EB50

NO.48 Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

An existing Oracle base can be used.

The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

Existing Oracle Database instances must be shut down before starting the upgrade.

Only the grid user can perform the upgrade.

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

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.

NO.50 Choose the best answer. How do you configure a CDB for local undo mode?

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

NO.51 In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

Decreasing PCTUSED

Decreasing PCTFREE

Increasing the number of DBWN process

Using Automatic Segment Space Management (ASSM)

Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

NO.52 Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

The sudo password can be specified in a response file.

root.sh can be executed automatically by the Database installer only by using sudo credentials.

The sudo password must be specified in a response file.

The root password cannot be specified in a response file.

NO.53 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_LEVEL must be set to ALL to generate alerts.

Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2

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

It is not possible if an archived log is missing.

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

It is performed by the Recovery Writer (RVWR) background process.

Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

NO.55 Which two are true about gathering optimizer statistics? (Choose two.)

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

System statistics can be gathered only while connected to CDB$ROOT.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you’ll%20have%20to,independently%20from%20the%20CDB%24ROOT.&text=Oracle%20Database%20automatically%20gathers%20fixed,Automatic%20Optimizer%20Statistics%20Collection%E2%80%9C) .
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html

NO.56 Which three are true about Optimizer Statistics Advisor? (Choose three.)

It can be run only manually.

It is part of the DBMS_ADVISOR package.

It can recommend changes to improve the statistics gathering process.

It always analyzes all schemas in the database.

It runs automatically every night by default.

It is part of the DBMS_STATS package.

https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2

Loading …