1Z0-083 - Latest Training Dumps

FRAGE 117
Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

Data Pump full database export and import

cloning the non-CDB as a PDB

replication using GoldenGate

Data Pump transportable tablespaces

Data Pump full transportable database

the DBMS_PDB package

FRAGE 118
Prüfen Sie diese Konfiguration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRA for the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:

What is the outcome?

The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

Only the ORCL database instance is started.

Only the ORCL database and the ASM instances are started.

Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

Only the ORCL database instance and the +DATA and +FRA disk groups are started.

FRAGE 119
Your SALES_ROOTapplication container has two application PDBs.
The SALES_APPapplication has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Welche beiden Aussagen sind richtig? (Wählen Sie zwei.)

The CONTAINERS clause cannot be used in queries on the REVENUE table.

The REVENUE table must be a list-partitioned table.

The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

The MAPTABLE table is a metadata-linked table.

A container map exists for the REVENUE table, but is not enabled.

The REVENUE table partitions are not pruned across the PDBs automatically.

FRAGE 120
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A PDB snapshot is always a full copy of the source PDB.

A PDB snapshot is always a sparse copy of the source PDB.

A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

A PDB snapshot depends on a storage snapshot which can be stored on any file system.

A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

A snapshot copy PDB can be created from a stand-alone clone PDB.

FRAGE 121
Which three are true about using Database Resource Manager in an Oracle multitenant environment?
(Wählen Sie drei aus.)

A PDB-level resource plan can limit session PGA memory.

A CDB-level resource plan can limit PDB CPU utilization.

A CDB-level resource plan can limit session CPU utilization.

PDB-level resource plans can limit uncommitted UNDO per consumer group.

A CDB-level resource plan can limit PDB UNDO use.

A CDB-level resource plan is mandatory when using PDB-level resource plans.

FRAGE 122
For which two requirements can you use the USER_TABLESPACEclause with the CREATE PLUGGABLE DATABASEcommand? (Choose two.)

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

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

to include specific user tablespaces only when relocating a PDB

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

to exclude a temp tablespace when plugging in a PDB

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

FRAGE 123
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?

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

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

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

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

The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously

FRAGE 124
Choose three. Which three are true about a container database (CDB)?

It can be created from a non-CDB.

It can contain only one PDB$SEED, which is created when the CDB is created.

It can have local users with the same name in different PDBs.

It can contain only one Application Container seed, which is created when the Application Container is created.

It can be created by cloning an existing CDB.

It can have any number of pluggable databases (PDBs) limited only by space availability.

It contains predefined common roles in both the root and the seed.

FRAGE 125
How do you configure a CDB for local undo mode?

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 restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.

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 read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

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.

FRAGE 126
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

The number of table rows is considered when evaluating the cost of accessing a table using an index.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

FRAGE 127
Beim Backup in die Oracle Fast Recovery Area (FRA) stellen Sie fest, dass das Backup zu lange dauert und vermuten einen Leistungsengpass.
Welche zwei Aussagen zur Diagnose und Einstellung dieser Probleme sind richtig?

Wenn ein rman-Backup-Validierungsbefehl ungefähr die gleiche Zeit benötigt wie die eigentliche Sicherung, dann sind wahrscheinlich sowohl Lese- als auch Schreib-E/A Engpässe.

Wenn ein rman-Backup-Validierungsbefehl deutlich weniger Zeit benötigt als eine tatsächliche Sicherung, dann ist die Schreib-E/A wahrscheinlich ein Engpass.

Datendateien mit einem hohen Wert in v$backup_sync_io.discrete_bytes_per_second sind ein potentieller Leistungsengpass, wenn synchrone E/A verwendet wird.

Wenn ein rman-Backup-Validierungsbefehl ungefähr die gleiche Zeit benötigt wie eine tatsächliche Sicherung, dann ist die Lese-E/A wahrscheinlich ein Engpass.

Datendateien mit einem hohen Wert in v$backup_async_io.short_waits sind ein potentieller Leistungsengpass, wenn asynchrone E/A verwendet wird.

FRAGE 128
Which four are true about RMAN backup sets? (Choose four.)

A backup piece can belong to only one backup set.

A data file can be split into multiple sections stored in different backup sets.

A data file canbe split into multiple sections stored in different backup pieces in the same backup set.

Blocks from multiple data files can be contained in one backup piece,

A backup set can contain only one backup piece.

A backup set must be written to media.

A backup set must be written to disk.

Blocks from multiple data files can be contained in one backup set,

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

By default, AWR snapshots are taken every 60 minutes.

Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

By default, AWR snapshots are retained for 7 days.

The taking of AWR snapshots can be disabled.

AWR data is stored in the SYSTEM tablespace.

FRAGE 130
Which two are true about RMAN encryption?

Password encryption can be persistently configured using the configure encryption command.

Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

RMAN encryption keys are stored in a database keystore.

RMAN can encrypt the Oracle Database password file.

The set encryption command overrides encryption settings specified by the configure encryption command.

FRAGE 131
PDB1 and PBD2 are pluggable databases in CDB1.
Prüfen Sie diese Befehle:

CDB1 is then restarted.
Which three are true? (Choose three.)

PDB2 will be MOUNTED.

PDB1 will be MOUNTED.

PDB$SEED will be opened READ ONLY.

PDB2 will be opened READ WRITE.

PDB1 will be opened READ WRITE.

PDB$SEED will be MOUNTED.

FRAGE 132
Prüfen Sie diese Ausgabe:

Welche beiden Aussagen sind richtig?

Any PDB not specified in the plan will be unable to execute statements in parallel.

PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

PDB3 can use all available parallel execution processes at times.

PDB1 is always limited to 40% of the available system resources regardless of demand.

PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

FRAGE 133
A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

SYS sessions, regardless of the roles that are set in the session

SYSTEM sessions, regardless of the roles that are set in the session

SCOTT sessions, only if the MGR role is set in the session

SCOTT sessions, only if the MGR role is granted to SCOTT

SCOTT sessions, because he is the owner of the table

SYSTEM session, only if the MGR role is set in the session

FRAGE 134
Prüfen Sie diese Konfiguration:

To recover from this critical failure, you execute these commands:

What will be the outcome?

Option

FRAGE 135
Prüfen Sie diese Konfiguration:
1. CDB1 ist eine Container-Datenbank, die im ARCHIVELOG-Modus läuft.
2. In CDB1 laufen mehrere unbestätigte Transaktionen.
3. Die Redo-Log-Gruppen 1 und 2 sind INAKTIV.
4. Die Redo-Log-Gruppe 3 ist die CURRENT-Gruppe.
Alle Mitglieder der Redo-Log-Gruppe 3 gehen verloren, bevor sie archiviert wird.
Prüfen Sie diese möglichen Schritte:
1. ABSCHALTEN ABBRUCH
2. STARTUP-NOMOUNT
3. ANFANGSMONTAGE
4. ALTER DATABASE MOUNT
5. DATEN WIEDERHERSTELLEN
6. DATENBANK WIEDERHERSTELLEN NOREDO
7. WIEDERHERSTELLUNG DER DATENBANK BIS ZUR VERFÜGBARKEIT
8. ARCHIVIERUNGSPROTOKOLL WIEDERHERSTELLEN ALLE
9. ALTER DATABSE OPEN
10.ALTER DATABASE OPEB RESETLOGS
Wählen Sie die minimal erforderlichen Schritte in der richtigen Reihenfolge, um die Datenbank wiederherzustellen.

1, 3, 5, 8, 6, 10

1, 3, 5, 6, 10

1, 3, 5, 7, 10

1, 2, 5, 7, 4, 10

1, 3, 5, 6, 9

FRAGE 136
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

The number of table rows is considered when evaluating the cost of accessing a table using an index.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

FRAGE 137
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
(Wählen Sie zwei aus.)

Nach der Änderung kann nur ein normaler Benutzer mit den erforderlichen Rechten einen Undo-Tablespace in CDB&ROOT erstellen.

Jede neue PDB und bestehende PDBs werden automatisch so konfiguriert, dass sie den Standard-Tablespace für Undos in CDB$ROOT verwenden.

Nach der Änderung kann nur ein Undo-Tablespace in CDB$ROOT existieren.

Nach der Änderung kann jeder Benutzer mit den erforderlichen Berechtigungen einen Undo-Tablespace in den PDBs erstellen.

In PDBs vorhandene Undo-Tablespaces müssen vor der Änderung gelöscht werden.

Nach der Änderung muss jede bestehende PDB erneut geöffnet werden, damit der neue Rückgängigmachungsmodus wirksam wird.

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

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

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

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

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

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

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

FRAGE 139
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Welche drei Aussagen sind richtig?

APP1 can never be unplugged.

Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

An application seed PDB Is created for APP1.

Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

An application root PDB is created for APP1.

A default service Is created for the application root APP1.

FRAGE 140
Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /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 PDB2 only

CDB1 and PDB$SEED only

CDB1, PDB1, and PDB2 only

CDB1, PDB$SEED, and PDB1 only

FRAGE 141
T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

Recovery catalog is resynchronized with the control files of the registered databases.

Imported databases are unregistered from the RC11 catalog.

Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

All databases registered in the RC11 catalog are registered in the RC12C catalog.

Kategorie 1Z0-083

[Apr 10, 2025] Valid 1Z0-083 Test Answers & 1Z0-083 Exam PDF [Q117-Q141]