[Mar-2022] Oracle 1Z1-083 Dumps – Reduce Your Chance of Failure in 1Z1-083 Exam [Q119-Q143]

4.2/5 - (4 votes)

[Mar-2022] Oracle 1Z1-083 Dumps – Reduce Your Chance of Failure in 1Z1-083 Exam

To help you achieve your ultimate goal, we suggest the actual Oracle 1Z1-083 dumps for your Oracle Database Administration II exam preparation to use as your guideline.

NO.119 A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING ‘/u01/app/oracle/oradata/pdb1.xml’
SOURCE_FILE_NAME_CONVERT =
(‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)

PDB1 data files already exist in the correct location.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

PDB_FILE_NAME_CONVERT must be set before executing the command.

/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

PDB1 must be dropped from CDB1.

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

V$SESSION_EVENT

V$SESSTAT

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION

NO.121 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.122 Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c?

relocating a remote container database in interactive mode

cloning a remote container database in silent mode

cloning a remote container database in interactive mode

relocating a remote container database in silent mode

relocating a remote pluggable database in interactive mode

cloning a remote pluggable database in silent mode

relocating a remote pluggable database in silent mode

NO.123 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: Which two are true? (Choose two.)

oracle will be an owner of the Oracle Inventory.

oracle must be the owner of every Oracle Database installation.

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

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

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

NO.124 Which three are true about the SQL Tuning Advisor? (Choose three.)

It checks each query being analyzed for stale statistics.

It checks each query being analyzed for missing statistics.

It only recommends syntactic changes to SQL statements.

It can recommend semantic changes to SQL statements.

It considers all SQL statements being analyzed by the advisor task as a group.

It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

NO.125 Which three are true about SGA memory management in a multitenant database? (Choose three.)

Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.

Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.

The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

SGA_MIN_SIZE cannot be set for a PDB.

NO.126 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.127 Choose two. Which two are prerequisites for using FLASHBACK TABLE?

A table’s constraints must be disabled before issuing the flashback.

The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.

Row Movement must be enabled on the table being flashed back.

A table’s indexes must be set to unusable before issuing the flashback.

The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

NO.128 choose one .Examine the RMAN commands: RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”; RMAN> CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?

It succeeds and creates multisection backup sets that are used for active database duplication.

It fails because there is no connection to a recovery catalog.

It succeeds only if the target database is in MOUNT state.

It fails because no parallel channels are allocated for the auxiliary database.

NO.129 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.130 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.131 Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCLuses disk group +FRAfor 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 +DATAand +FRAdisk groups, and the LISTENER are started.

Only the ORCL database instance is started.

Only the ORCLdatabase and the ASM instances are started.

Only the ORCLdatabase instance, the Oracle ASM instance, and the +DATAand +FRAdisk groups are started.

Only the ORCLdatabase instance and the +DATAand +FRAdisk groups are started.

NO.132 Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

Oracle DBCA templates can store only logical structure and not database files.

New templates can only be created by modifying an existing user-created template.

The Data Warehouse template is most suitable when transaction response time is the key criterion.

Oracle DBCA templates can be used to create new databases and duplicate existing databases.

NO.133 Choose the best answer. Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

1,3,5, 6, 9

1,3,5, 7, 10

1,2, 5, 7,4, 10

1,3, 5, 6, 10

1,3,5, 6, 10

1,3,5,8, 6, 10

NO.134 Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

using the KEEP FOREVER clause with the BACKUP command

using RMAN stored scripts

using the REPORT SCHEMA command to list a database’s current data files and tablespaces

creating customized reports about a single database’s backups

creating encrypted backups

using the REPORT SCHEMA command to list a database’s data files and tablespaces at times in the past

NO.135 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.136 The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)

A proxy PDB must exist in the application root in the remote CDB.

A database link must exist in the local CDB root referring to the remote CDB.

PDB3’s application root replica must exist in the local CDB.

A database link must exist in the remote CDB referring to the local CDB.

The HR_ROOT replica must exist in the remote CDB.

A proxy PDB must exist in the application root in the local CDB.

NO.137 Which two are true about common objects? (Choose two.)

They can be created only in CDB$ROOT.

They can be only metadata-linked in an application container.

They can exist in user-defined schemas only in application containers.

They can exist in CDB$ROOTand an application root.

They can be extended data-linked in CDB$ROOT.

They can be created only in an application root.

NO.138 Which two are true about common objects? (Choose two.)

They can be created only in CDB$ROOT.

They can be only metadata-linked in an application container.

They can exist in user-defined schemas only in application containers.

They can exist in CDB$ROOT and an application root.

They can be extended data-linked in CDB$ROOT.

They can be created only in an application root.

NO.139 Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

Plugging the application root into a different CDB plugs in all its application PDBs.

The application root of an application container should be plugged into the other CDB before its application PDBs are plugged in.

Application PDBs in the application container must be unplugged before the application root is unplugged.

Unplugging the application root from a CDB unplugs all its application PDBs.

It requires only local UNDO mode in the database where the application container will be unplugged.

It requires local UNDO mode in both container databases.

NO.140 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.

NO.141 Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE —————————————PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

It fails because Data Pump cannot be container.

It creates a full export of the root

It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

NO.142 While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

Increase the size of tape I/O buffers.

Disable FORCE LOGGING for the database.

Increase the size of the database buffer cache.

Enable asynchronous disk I/O.

Increase the level of RMAN multiplexing.

NO.143 Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.

Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.

An Oracle database can be restored from backup files copied using O/S utilities.

Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

Accurate & Verified Answers As Seen in the Real Exam here: https://www.testsimulate.com/1Z1-083-study-materials.html

Leave a Reply Cancel reply