[Dec-2022] Use Real 1Z1-083 Dumps Free Sample Questions and Practice Test Engine [Q134-Q155]

Posted On December 21, 2022

[Dec-2022] Use Real 1Z1-083 Dumps Free Sample Questions and Practice Test Engine

Pass Oracle 1Z1-083 exam – questions – convert Tets Engine to PDF

Q134. Which two are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

It can be used to provision middleware.

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

It Is an Oracle Database service.

It can be used to provision applications.

It cannot be used to upgrade Oracle Database homes.

Q135. Which two are true about Optimizer Statistics? (Choose two.)

They can be gathered by the DBMS_STATS package.

They are gathered by the SQL Tuning Advisor.

They provide real-time data about schema objects.

They are ignored by Optimizer if they are stale.

By default, they are automatically gathered by a maintenance job.

Q136. 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

Q137. Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

A target database’s persistent RMAN configuration settings are always stored in the target’s control file

Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

The RMAN SHOW ALL command displays only settings with nondefault values.

A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.

A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Q138. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

creating a new empty PDB in the local database from PDB$SEED

creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

automatically dropping the database link to the remote database if it already exists

creating a database link from CDB$ROOT in the remote database to the PDB in the local database

opening the cloned PDB

Q139. Choose two. Which two are true in Oracle 19c and later releases?

Schema Only accounts can be granted administrator privileges.

If the password file location changes, then the instance must be restarted.

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

All the Oracle-supplied accounts are Schema Only accounts.

Unified Auditing can be configured to audit only events that are issued indirectly by all users

Q140. Examine this configuration:
* CDB1 is a container database.
* COMMON_USER_PREFIX is C##.
* PDB1 is a pluggable database contained in CDB1.
* APP1_ROOT is an application container contained in CDB1.
* APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

APP1_USER1 can be created in PDB1.

APP1_USER1 can be created in CDB1.

APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

C##_APP_USER1 can be created in CDB1.

P1_USER1 can be created in CDB1.

C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

Q141. Which two are true about RMAN duplexed backup sets? (Choose two.)

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Q142. Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

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.

RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

The undo tablespace clause is always required when no connection exists to the target instance.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Q143. Which two are true about RMAN duplexed backup sets? (Choose two.)

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Q144. Examine this configuration:
1. CDB1is a container database.
2. PDB1and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

PDB1and PDB2are in MOUNTstate.

Redo logs are opened.

PDB1 and PDB2 are in READ ONLYstate.

CDB$ROOTis in MOUNTstate.

PDB$SEEDis in READ ONLYstate.

Q145. Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

all backups prior to 10th of August

all backups prior to 22nd of August

all backups prior to 20th of August

all backups prior to 24th of August

all backups prior to 17th of August

Q146. Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

to switch an existing Oracle Database home to a newer release of Oracle software on the same server

to switch to a read-only Oracle home

to switch back to the previous Oracle home as part of a rollback operation

to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

to switch to a patched Oracle Database home

You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home. The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image. You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/cwadd/rapid-home- provisioning.html#GUID-856C7378-2510-4B3E-8BE1-B4D79DF4FE8B

Q147. Choose three. Which three are true about SGA memory management in a multitenant database?

SGA_MIN_SIZE cannot be set for a PDB.

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

Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA 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 DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

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

Q148. 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? (Choose two.)

after losing a SYSAUX tablespace data 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 all copies of the control file

after losing an UNDO tablespace that is in use

Q149. Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.

The Oracle Grid Infrastructure installation must be owned by the grid user.

The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.

The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Q150. Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?

Pre-existing backups of the database to be duplicated are required for the “push” method of duplication.

Pre-existing backups of the database to be duplicated are required for the “pull” method of duplication.

Pre-existing backups of the database to be duplicated are always used if they exist.

Image copies can be used to duplicate the active database.

The active database must be duplicated while in OPEN state.

No connection to the recovery catalog is required for active database duplication.

Backup sets can be used to duplicate the active database.

Q151. Examine this output:

Which two are true? (Choose two.)

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

PDB3 can use all available parallel execution processes at times.

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

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

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

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

Q152. The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Backups must be done incrementally.

Backups must be contained in backup sets.

Backups can be taken only if the database is in ARCHIVELOG mode.

Backups can be done incrementally.

The database must be registered in an RMAN catalog.

Only consistent backups can be created.

Q153. 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.)