Is this exam completely free?

Examcademy offers a free preview for every exam, covering around 20% of the total questions. Full access is available with a paid upgrade.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! Examcademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our mock exams are built and reviewed with the help of AI and community contributions, staying aligned with real-world exam objectives.

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!

1z0-083Free trial

By oracle

Verified

25Q per page

Question 26

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

A: A lost SPFILE can be recovered from memory using SQL*PLUS.
B: A lost password file can be re-created with SQL*PLUS.
C: A lost TEMPFILE must always be re-created manually.
D: A lost password file can be manually re-created with the orapwd utility.
E: A lost PFILE can be re-created alert.log using SQL*PLUS.
F: A lost index tablespace can be re-created without performing any recovery.

—

Question 27

Examine this configuration:

CDB1 is a container database.
APP_ROOT is an application root in CDB1.
APP_PDB1 is an application PDB in APP_ROOT.
FLASHBACK DATABASE is ON.
You execute these commands:

Which table or set of tables will exist after the Flashback operation has completed?

A: CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
B: CDB1_TAB and APP_PDB1_TAB
C: none of the tables, because all three tables will be dropped
D: CDB1_TAB only
E: CDB1_TAB and APP_ROOT_TAB

—

Question 28

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

A: A media manager always writes RMAN requested backups to tape.
B: By default, a request for a proxy copy may result in a backup set being created.
C: A media manager is required to create RMAN proxy copies.
D: A media manager is required to create RMAN image copies.
E: The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

—

Question 29

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

A: Some messages in the error stack are not errors.
B: If an RMAN command fails, the output will only identify the command that failed.
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 ג€sbtioג€ and a number.
E: Media Management errors appear as a line with ג€sbtioג€.
F: Media Management errors appear as a line with ג€Additional informationג€ and a number.

—

Question 30

Which three are true about block media recovery? (Choose three.)

A: The data file containing the block being recovered remains online.
B: To use it, Flashback Database must be enabled.
C: A block being recovered is not accessible.
D: It can be performed on noncorrupt blocks.
E: The target database for which one or more blocks are to be recovered must be in the OPEN state.
F: It cannot repair logical corruption.

—

Question 31

In which two situations can you use Database Upgrade Assistant? (Choose two.)

A: when the operating system (OS) needs to be changed as part of the upgrade
B: when a character set conversion is required during the upgrade
C: when multiple pluggable databases in a container database have to be upgraded in a specific sequence
D: when the target and source database are on the same platform
E: when the hardware platform needs to be changed as part of the upgrade

—

Question 32

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

A: The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
B: PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
C: The entire PGA is located in the System Global Area (SGA) when using shared servers.
D: Sorts and Hash Joins use PGA memory.
E: The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

—

Question 33

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A: Online Redo Log backups can be created while connected to the root container.
B: Control file backups can be created while connected to the root container.
C: The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
D: Archived Redo Log backups can be created while connected to an application root CDB.
E: Control file backups can be created while connected to a nonroot container.

—

Question 34

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

A: They are generated if STATISTICS_LEVEL is set to TYPICAL.
B: They are generated if STATISTICS_LEVEL is set to ALL.
C: They are always created automatically.
D: They are always created manually.
E: They can be retained forever.
F: They are generated if STATISTICS_LEVEL is set to BASIC.

—

Question 35

You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:

Make the UNIVERSITY tablespace read-only on the source system.
Export the UNIVERSITY tablespace metadata using EXPDP.
Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.
Copy the UNIVERSITY tablespace data files to the destination system.
Copy the Data Pump dump set to the destination system.
Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
Import the UNIVERSITY tablespace metadata using IMPDP.
Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A: 1, 2, 4, 5, 7, 8
B: 1, 2, 4, 6, 7, 8
C: 1, 2, 3, 4, 5, 7, 8
D: 1, 2, 3, 4, 5, 6, 7, 8
E: 2, 4, 5, 6, 7

—

Question 36

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

A: A PDB-level resource plan can limit session PGA memory.
B: A CDB-level resource plan can limit PDB CPU utilization.
C: A CDB-level resource plan can limit session CPU utilization.
D: PDB-level resource plans can limit uncommitted UNDO per consumer group.
E: A CDB-level resource plan can limit PDB UNDO use.
F: A CDB-level resource plan is mandatory when using PDB-level resource plans.

—

Question 37

How do you configure a CDB for local undo mode?

A: Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
B: Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
C: 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.
D: Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
E: 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.

—

That’s the end of your free questions

You’ve reached the preview limit for 1z0-083

Consider upgrading to gain full access!

Page 2 of 8 • Questions 26-50 of 181

←

1 2 3 4 5

→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!