2022 Updated Verified 1Z0-083 Downloadable Printable Exam Dumps [Q17-Q40]

4.4/5 - (5 votes)

2022 Updated Verified 1Z0-083 Downloadable Printable Exam Dumps

The Ultimate Oracle 1Z0-083 Dumps PDF Review

Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083

The following will be discussed in the ORACLE 1Z0-083 exam dumps:

Configuring and using RMAN – Oracle Database: Backup and Recovery Workshop
Duplicate Databases
Restore and Recovery Concepts – Oracle Database: Backup and Recovery Workshop
Configure RMAN and the Database for Recoverability
Using Flashback Technologies – Oracle Database: Backup and Recovery Workshop
Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry
Configure your Database to support Flashback
Employ the best Oracle Database recovery technology for your failure situation
Detect and repair database and database block corruption
Perform flashback operations
Diagnosing Database Issues

NO.17 You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

The insert on USER2.DEPT fails because of the active transaction in the parent container.

The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

The inserts on USER1.EMP were rolled back when the session connected to PDB2.

The insert on USER2.DEPT is uncommitted.

The inserts on USER1.EMP were committed when the session connected to PDB2.

NO.18 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 ACTIV

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

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

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

NO.19 Which three are true about requirements for various FLASHBACK operations? (Choose three.)

FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

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

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

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.

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.

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

The data file containing the block being recovered remains online.

To use it, Flashback Database must be enabled.

A block being recovered is not accessible.

It can be performed on noncorrupt blocks.

The target database for which one or more blocks are to be recovered must be in the OPEN state.

It cannot repair logical corruption.

NO.22 Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

Tracking the most recent read time for a table segment in a user tablespace

Tracking the most recent write time for a table segment in a user tablespace

Tracking insert time by row for table rows

Tracking the most recent write time for a table block

Tracking the most recent read time for a table segment in the SYSTEM tablespace

Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct

NO.23 Examine this configuration:
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.

NO.24 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.25 Which two are true about automatic block repair?

Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

It is not possible for media corrupt blocks.

Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

NO.26 Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

3,4,6

2,3,4,5,6,7

1,3,4,6,8

1,2,3,4,5,6,7,8

NO.27 Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

the configuration of storage arrays

the physical data model

defining primary keys for all tables to speed up all queries

defining foreign keys for all tables to speed up joins

using check constraints to speed up updates

NO.28 Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?

By default, MMON creates an AWR snapshot every 30 minutes.

By default, AWR snapshots are automatically purged after eight days.

ADDM can recommend shrinking the buffer cache.

ADDM can recommend extending the buffer cache.

ADDM performs its analysis only when a DBA requests it.

AWR snapshots must be deleted when no longer required by ADDM.

NO.29 Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

It recompiles all stored PL/SQL code by using utlrp.sql.

It empties the RECYCLE BIN.

It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

It sets all user tablespaces to “read-only” before starting the upgrade.

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

It increases tablespace size, if required, to meet upgrade requirements.

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

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

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

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

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

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

NO.31 Which two are true about Oracle Flashback features? (Choose two.)

FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

FLASHBACK TABLE can undrop a column.

FLASHBACK DROP can undrop an index when undropping a table.

After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

NO.32 Choose two. Which two are true about PDB archive files?

DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

They contain all the data files only in uncompressed form for a PDB.

They must be created using the DBMS_PDB package.

They contain a PDB manifest file and all the data files in compressed form for a PDB.

They contain all the data files only in compressed form for a PDB.

NO.33 Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?

It will return an error because creation of a local role is not allowed in CDB$ROOT.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

ROLE1 will be created only in CDB$ROOT.

It will return an error because common roles must start with C##.

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

Some messages in the error stack are not errors.

If an RMAN command fails, the output will only identify the command that failed.

If an RMAN command fails, the output will identify the channel ID where the failure occurred.

Media Management errors appear as a line with “sbtio” and a number.

Media Management errors appear as a line with “sbtio”.

Media Management errors appear as a line with “Additional information” and a number.

NO.35 Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

A failure can be closed only when it has been repaired.

Data Recovery Advisor can be used if a database is closed.

The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

Data Recovery Advisor can proactively check for failures.

NO.36 Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

A PDB snapshot depends on an existing storage snapshot of the source PDB.

APDB snapshot can be a full copy of a source PDB.

A PDB snapshot can be a sparse copy of a source PDB

A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

A snapshot copy PDB can be a full copy of a source PDB

NO.37 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.38 Which two are true about Oracle Database Configuration Assistant (DBCA) templates?

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

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

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

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

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

NO.39 Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.

A new PDB is automatically created when importing a non-CDB into a CDB.

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

NO.40 Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

2,4,5,6

1,2,3,4,5,6

1,2,4,5

2,4,5

1,3,4,5