Released Oracle 1Z0-083 Updated Questions PDF [Q45-Q68]

8 Feb, 2023 By admin 1Z0-083, Oracle 0 Comments

Released Oracle 1Z0-083 Updated Questions PDF [Q45-Q68]

Rate this post

Released Oracle 1Z0-083 Updated Questions PDF

1Z0-083 Dumps and Practice Test (279 Exam Questions)

QUESTION 45
Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

Create SQL plan directives for each of the regressed statements.

Use The SQL Tuning Advisor for each of the regressed statements.

Create an adaptive execution plan for each of the regressed statements

Use the SQL Access Advisor for each of the regressed statements.

QUESTION 46
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.

QUESTION 47
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

cloning a remote container database in interactive mode

cloning a remote pluggable database in silent mode

relocating a remote pluggable database in interactive mode

relocating a remote container database in silent mode

cloning a remote container database in silent mode

relocating a remote pluggable database in silent mode

relocating a remote container database in interactive mode

QUESTION 48
Which two are true about flashback features in Oracle Database 19c and later releases?

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_flashback_retention_TARGET only after there is space pressure

Flashback logs are monitored and proactively deleted when beyond the retention period defined in db_flashback_retention_target before there is space pressure.

Flashback logs are automatically purged whenever the value
Of DB_FLASHBACK_RETENTION_TARGET is changed.

Flashback logs are monitored for being older than the retention period defined in db_flashback_retention_target and can be deleted by an administrator written event trigger.

Flashback logs are automatically purged when db_flashback_retention_target is set lower than the time they have already been retained.

QUESTION 49
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.

This cannot be done due to the lack of a clean restore point.

QUESTION 50
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)

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

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

Data file 24 can be restored only 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.

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

QUESTION 51
Which three methods can be used for heap table data migration after upgrading a database?

using operating system file copy utilities

using SQL Developer

using Oracle Data Pump

using Database Replay

using Database Upgrade Assistant

using the create table AS select SQL statement

QUESTION 52
Which three are true? (Choose three.)

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

Application-common TSDP policies are always container specific.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

Unified auditing can be automatically synchronized to all application PDBs in an application container.

QUESTION 53
choose three Which three RMAN persistent settings can be set explicitly?

SPFILE backup duplexing

control file auto backup formats

archive log deletion policy

image copy duplexing

redo log backup duplexing

archive log backup duplexing

QUESTION 54
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

In a PDB plan, subplans may be used with up to eight consumer groups.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

QUESTION 55
Which two are true about instance recovery?

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

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

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

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 not possible if an archived log is missing.

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

QUESTION 56
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

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

Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

The BACKUP DATABASEcommand will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

SPFILEbackups can be created while connected to an application root PDB.

The BACKUP DATABASE PLUS ARCHIVELOGcommand will back up archive logs when RMAN is connected to a PDB.

The BACKUP PLUGGABLE DATABASEcommand can be used to back up CDB$ROOT.

QUESTION 58
You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

It creates a binary backup of the control file.

It updates the alert log with the location and contents of the control file

It creates a file that contains SQL statements to re-create the control file.

It creates a file that contains RMAN scripts to create a duplicate database.

It creates a copy of the control file in the fast recovery area (FRA).

QUESTION 59
Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

The base catalog must be enabled for Virtual Private Catalog use.

The target PDB must be registered in a Virtual Private Catalog.

The target PDB must be registered in a base catalog.

QUESTION 60
Choose two. In which two situations can you use Database Upgrade Assistant?

when a character set conversion is required during the upgrade

when multiple pluggable databases in a container database have to be upgraded in a specific sequence

when the target and source database are on the same platform

when the hardware platform needs to be changed as part of the upgrade

when the operating system (OS) needs to be changed as part of the upgrade

QUESTION 61
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

The valid time columns employee_time_start and employee_time_end are automatically created.

Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.

The valid time columns are not populated by the Oracle Server automatically.

The valid time columns are visible by default when the table is described.

Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

QUESTION 62
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_LEVELmust be set to ALLto generate alerts.

QUESTION 63
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

This cannot be done due to the lack of a clean restore point.

QUESTION 64
Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

PDB1 and PDB2 are in MOUNT state.

Redo logs are opened.

PDB1 and PDB2 are in READ ONLY state.

CDB$ROOT is in MOUNT state.

PDB$SEED is in READ ONLY state.

QUESTION 65
Choose two. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

Backups can be taken only if a fast recovery area is configured.

Backups can be written only to disk.

Backups can be taken only for data files.

Binary compression cannot be applied to the backup.

Backups can be written only if checksums are stored for each block.

Backups can be written only to media.

QUESTION 66
A database is configured in archivelog mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required?

after losing all copies of the control file

after losing all members of an inactive online redo log group

after losing all members of the current online redo log group

after losing an undo tablespace that is in use

after losing a sysaux tablespace data file

QUESTION 67
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

It is an Oracle Database service

It cannot be used to upgrade Oracle Database homes.

It can be used to provision applications.

It can be used to patch Grid Infrastructure homes containing Oracle Restart.

It can be used to provision middleware.

QUESTION 68
Choose two. Which two are true about backup set compression using RMAN default compression?

Compressed backups cannot have a section size defined.

Compressed backups can be written only to media.

Binary compression adds CPU overhead to backup operations.

Unused blocks below the high water mark are backed up.

Compression can be done only for locally managed tablespaces.

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:

Manage CDBs and PDBs
Backup Strategies and Terminology
Manage Security in Multitenant databases
Backup and Duplicate
Creating CDBs and Regular PDBs
Recovery and Flashback
Oracle Database: Backup and Recovery Workshop
Manage Application PDBs

1Z0-083 Exam Dumps Pass with Updated 2023 Certified Exam Questions: https://www.premiumvcedump.com/Oracle/valid-1Z0-083-premium-vce-exam-dumps.html

Premium VCE Dumps

Premium VCE Dumps

Released Oracle 1Z0-083 Updated Questions PDF [Q45-Q68]

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

Leave a Reply Cancel reply