Oracle 1Z1-083 Practice Exam - 279 Unique Questions [Q139-Q161]

Rate this post

Oracle 1Z1-083 Practice Exam – 279 Unique Questions

Latest Questions 1Z1-083 Guide to Prepare Free Practice Tests

To prepare for the Oracle 1Z1-083 exam, candidates can take advantage of various training resources provided by Oracle, including online courses, instructor-led training, and practice exams. Candidates can also use third-party study materials such as books, practice exams, and online forums to supplement their preparation.

Oracle 1Z1-083 exam is designed to test the candidate’s knowledge and skills in advanced database administration concepts such as performance tuning, backup and recovery, security, database deployment, and management. 1Z1-083 exam consists of 80 multiple choice questions and is 105 minutes long. The passing score for the exam is 64%, which means that candidates must answer at least 51 questions correctly to pass the exam.

Q139. 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 valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Q140. Choose three. Which three are true about Oracle Restart?

It is used in both clustered and non-clustered environments.

You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.

It runs from the Oracle Grid Infrastructure home.

If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.

Q141. choose three You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication ) The duplication process can create backup sets or image copies

The target database must be open

The duplication process can use existing backup sets or image copies

The duplication process can use existing backup sets or image copies.

The target database must be in mount state.

The duplication -process pushes backup sets to the auxiliary instance.

The duplication process pushes image copies to the auxiliary instance.

Q142. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.

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

Data Recovery Advisor can proactively check for failures.

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

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

Q143. Choose three. Which three are true about backing up the control file?

It cannot be backed up manually as a binary copy.

It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs.

It can be backed up manually as a binary copy.

It can get backed up automatically as a binary copy.

It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

It can be backed up manually as a trace file containing SQL statements for control file recreation.

Q144. Which two are true about monitoring waits for sessions and services?

v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.

v$session_wait_class displays waits broken down by wait class only for waiting sessions.

v$service_event displays wait counts for every wait event whether waited on or not, for each service.

v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.

v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

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

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

Q147. Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

redo logs

control files

all data dictionary metadata

user-defined PL/SQL packages

temporary tablespaces

mandatory Oracle-supplied PL/SQL packages

undo tablespaces

Q148. Which two statements are true when row archival management is enabled?

The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

Q149. Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true?

APP1 can never be unplugged.

Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

An application seed PDB Is created for APP1.

Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

An application root PDB is created for APP1.

A default service Is created for the application root APP1.

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

Q151. A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?

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

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

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

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

Q152. Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

By default, the transported database will use Oracle Managed Files (OMF)

Data files can be converted on the destination system.

Data files can be converted on the source system.

A new DBID is automatically created for the transported database.

Databases can be transported between systems with different endian formats.

The password file is automatically converted by RMAN.

Q153. Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

The number of table rows is considered when evaluating the cost of accessing a table using an index.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

Q154. Examine this output:

Which two are true?

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

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

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

PDB3 can use all available parallel execution processes at times.

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

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

Q155. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

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.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.

If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.

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_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

Q156. Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

The number of table rows is considered when evaluating the cost of accessing a table using an index.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

Q157. You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

Re-createthepasswordfileintheOracleDatabase12cformat. Correct

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

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

Q160. Which two are true about RMAN persistent configuration settings, administration, and their effects?

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

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

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

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

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

Q161. Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

APP1_USER1can be created in PDB1.

APP1_USER1can 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_USER1can be created in CDB1.

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

Correct and Up-to-date Oracle 1Z1-083 BrainDumps: https://www.prepawaytest.com/Oracle/1Z1-083-practice-exam-dumps.html

Oracle 1Z1-083 Practice Exam – 279 Unique Questions [Q139-Q161]

Leave a Reply Cancel reply