Updated Dec-2023 Pass 1Z0-083 Exam – Real Practice Test Questions [Q145-Q159]

Rate this post

Updated Dec-2023 Pass 1Z0-083 Exam – Real Practice Test Questions

Download Free Oracle 1Z0-083 Real Exam Questions

QUESTION 145
You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

a General Purpose database template with default memory allocation

a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

a default database configuration

QUESTION 146
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 147
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.

QUESTION 148
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

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.

QUESTION 149
Which four are true about RMAN backup sets?

A backup set must be written to media.

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

A backup set must be written to disk.

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

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

A backup piece can belong to only one backup set.

A backup set can contain only one backup piece.

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

QUESTION 150
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are open in read write mode.
You execute these commands successfully:

Which two are true?

CDB1 is in mount state

CDB1 is shut down.

PDB1 is closed.

Uncommitted transactions in PDB1 have been rolled back.

Uncommitted transactions in CDB1 and pdbi have been rolled back.

QUESTION 151
Which three are true about patchsets? (Choose three.)

They can be applied in a rolling fashion for Clusterware and the databases.

They can introduce new features.

They are installed via OPatch or OPatchAuto.

Installing a patchset is considered an “upgrade”.

They are only released quarterly.

A base release is not needed to install patchsets.

QUESTION 152
choose one You want to create a test database as a replica of your production database with minimum intervention from a DBA.
Which method would you use?

Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

QUESTION 153
Which two are true about gathering optimizer statistics? (Choose two.)

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

System statistics can be gathered only while connected to CDB$ROOT.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

QUESTION 154
Which two are true about RMAN encryption? (Choose two.)

RMAN encryption keys are stored in a database keystore.

RMAN can encrypt the Oracle Database password file.

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

The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

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

QUESTION 156
A database is configured in ARCHIVELOGmode.
Full RMAN backups are taken and no backup to trace has been taken of the control file.
A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

when any archived log from, before, or after the most recent backup is corrupt.

after losing all copies of the control file

after losing an archived log from after the most recent backup

after losing an archived log from before the most recent backup

after losing the SYSTEMtablespace

QUESTION 157
When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck.
Which two are true about diagnosing and tuning these problems?

If an rman backup validate command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

If an rman backup validate command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

Data files with a high value in v$backup_sync_io.discrete_bytes_per_second are a potential performance bottleneck when synchronous I/O is used.

If an rman backup validate command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.

Data files with a high value in v$backup_async_io.short_waits are a potential performance bottleneck when asynchronous I/O is used.

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

QUESTION 159
Which three are true in Oracle 19c and later releases? (Choose three.)

If the password file location changes, then the new location is used automatically by the Oracle Server.

Schema Only accounts can be granted administrator privileges.

All the Oracle-supplied accounts are Schema Only accounts.

Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

1Z0-083 Dumps 100 Pass Guarantee With Latest Demo: https://www.real4dumps.com/1Z0-083_examcollection.html

Updated Dec-2023 Pass 1Z0-083 Exam – Real Practice Test Questions [Q145-Q159]

Leave a Reply Cancel reply

Related Posts

Oracle 1z0-1032-22 Exam Preparation Guide and PDF Download [Q41-Q56]

All Obstacles During 1z0-1077-24 Exam Preparation with 1z0-1077-24 Real Test Questions [Q31-Q46]

Try Free and Start Using Realistic Verified 1z0-1104-23 Dumps Instantly [Q75-Q92]