oracle 1Z0-083 Exam Questions

Questions for the 1Z0-083 were updated on : Jun 07 ,2024

Page 1 out of 19. Viewing questions 1-15 out of 282

Question 1

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common
tables of the SALES APP application. Examine these steps:
Install the SALES_APP application, induding the common tables, in the application root.
Install the SALES_APP application in the application root and the common tables in both the CDB root
and the application root.
Create an application seed.
Install the SALES_APP application in the application seed.
Create the SALES_APP1 and SALES_APP2 application PDBs.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
Sync the application seed with the application root. Which are the minimum required steps in the
correct sequence?

  • A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
  • A. 1,3,5,7
  • B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
  • B. 2,5,6
  • C. to include specific user tablespaces only when relocating a PDB
  • C. 1,5,6
  • D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
  • D. 3,4,1.6,8
  • E. to exclude a temp tablespace when plugging in a PDB
  • E. 1,3,5,6,7
  • F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
Answer:

C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 2

A container database, CDB1, contains a pluggable database PDB1. Another container database is
called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three
are required?

  • A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in the MOUNT state.
  • A. CDB2 must be in shared UNDO mode only.
  • B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
  • B. CDB2 must be in archivelog mode.
  • C. An Oracle database can be restored from backup files copied using O/S utilities.
  • C. CDB1 must be in archivelog mode.
  • D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
  • D. CDB1 and CDB2 must both be in local UNDO mode.
  • E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
  • E. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
  • F. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
  • F. CDB1 and CDB2 must be in shared UNDO mode.
  • G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
Answer:

B, C, D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
G
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
G
0 / 1000

Question 3

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

  • A. using the KEEP FOREVER clause with the BACKUP command
  • A. A PDB snapshot depends on an existing storage snapshot of the source PDB.
  • B. using RMAN stored scripts
  • B. APDB snapshot can be a full copy of a source PDB.
  • C. using the REPORT SCHEMA command to list a database’s current data files and tablespaces
  • C. A PDB snapshot can be a sparse copy of a source PDB
  • D. creating customized reports about a single database’s backups
  • D. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
  • E. creating encrypted backups
  • E. A snapshot copy PDB can be a full copy of a source PDB
  • F. using the REPORT SCHEMA command to list a database’s data files and tablespaces at times in the past
Answer:

B, C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 4

Which two are true about creating RMAN backups for an Oracle container database?

  • A. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
  • A. Online Redo Log backups can be created while connected to CDB$ROOT
  • B. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
  • B. Control file backups can be created while connected to CDB$ROOT.
  • C. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
  • C. The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.
  • D. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
  • D. Archived Redo Log backups can be created while connected to PDB
  • E. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
  • E. Control file backups can not be created while connected to a PDB
  • F. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.
Answer:

A, B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 5

Which three are true about Automatic Workload Repository (AWR) snapshots?

  • A. 1, 3, 5, 8, 6, 10
  • A. They can be retained forever.
  • B. 1, 3, 5, 6, 10
  • B. They are always created automatically.
  • C. 1, 3, 5, 7, 10
  • C. They are always created manually.
  • D. 1, 2, 5, 7, 4, 10
  • D. They are generated if STATISTICS LEVEL is set to TYPICAL.
  • E. 1, 3, 5, 6, 9
  • E. They are generated if STATISTICS LEVEL is set to BASIC.
  • F. They are generated if STATISTICS LEVEL is set to ALL.
Answer:

B, D, F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 6

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

  • A. A proxy PDB must exist in the application root in the remote CDB.
  • A. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
  • B. A database link must exist in the local CDB root referring to the remote CDB.
  • B. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
  • C. PDB3’s application root replica must exist in the local CDB.
  • C. backing up the cloned PDB
  • D. A database link must exist in the remote CDB referring to the local CDB.
  • D. opening the cloned PDB
  • E. The HR_ROOT replica must exist in the remote CDB.
  • E. leaving the cloned PDB in mount state
  • F. A proxy PDB must exist in the application root in the local CDB.
Answer:

A, D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 7

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

  • A. It analyzes a period of time corresponding to the 12 hours of activity.
  • A. All metrics are instance related.
  • B. It runs automatically after each AWR snapshot.
  • B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
  • C. A DBA can run it manually.
  • C. A space usage management alert is automatically cleared after the underlying problem is resolved
  • D. Results are written to the alert log.
  • D. They are generated by SMON when a tablespace is 97% full.
  • E. It analyzes a period of time corresponding to the last day of activity.
  • E. Metrics are statistical counts for a specific unit.
  • F. STATISTICS_LEVEL must be set to ALL to generate alerts.
Answer:

B, C, E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 8

Choose three. In which three situations can you use threshold server-generated alerts to help
diagnose and fix problems?

  • A. All metrics are instance related.
  • A. when free space in a dictionary managed tablespace falls below a specified percentage
  • B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
  • B. when free space in a locally managed tablespace falls below a specified percentage
  • C. A space usage management alert is automatically cleared after the underlying problem is resolved.
  • C. when the total number of locked user account exceeds a specific value
  • D. They are generated by SMON when a tablespace is 97% full.
  • D. when the number of logons per second exceeds a specific value
  • E. Metrics are statistical counts for a specific unit.
  • E. when a resumable statement is suspended
  • F. STATISTICS_LEVEL must be set to ALL to generate alerts.
  • F. when the total number of logons exceeds a specific value
Answer:

B, C, D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 9

While backing up to an SBT channel, you determine that the read phase of your compressed
Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled
for the database. Which two could improve read performance? (Choose two.)

  • A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
  • A. Increase the size of tape I/O buffers.
  • B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
  • B. Disable FORCE LOGGING for the database.
  • C. The Oracle Grid Infrastructure installation must be owned by the grid user.
  • C. Increase the size of the database buffer cache.
  • D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
  • D. Enable asynchronous disk I/O.
  • E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
  • E. Increase the level of RMAN multiplexing.
  • F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
Answer:

B, C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 10

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE
DATABASE command? (Choose two.)

  • A. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
  • A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB
  • B. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
  • B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
  • C. Flashback commands help with repairing physical errors.
  • C. to include specific user tablespaces only when relocating a PDB
  • D. RMAN can always repair corrupt blocks.
  • D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
  • E. The ADR can store metadata in an Oracle Database repository.
  • E. to exclude a temp tablespace when plugging in a PDB
  • F. The Data Recovery Advisor uses the ADR.
  • F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
Answer:

B, D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 11

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

  • A. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
  • A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
  • B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
  • B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
  • C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
  • C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
  • D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
  • D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
  • E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
  • E. FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.
  • F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
  • F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
Answer:

A, B, F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 12

Which two are prerequisites for performing Flashback Transaction?

  • A. CDB1 and CDB2 must be in shared undo mode.
  • A. Fast Recovery Area must be enabled for the database
  • B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
  • B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
  • C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
  • C. Undo retention guarantee must be configured for the database.
  • D. Cloning HR_ROOT automatically clones HR_PDB1.
  • E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
  • E. A supplemental log must be enabled for the primary key.
Answer:

B, D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
E
50%
E
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
E
E
0 / 1000

Question 13

choose one You enable Flashback Data Archive for a table for which you want to track and save all
transactions for four years. After some time, the requirement changes for keeping transactions from
four to two years. You execute the following command to change the requirement: SQL> ALTER
FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

  • A. The Pre-Upgrade Information Tool script is executed by DBUA.
  • A. All historical data older than two years, if any, is purged from the flashback archive FDA1.
  • B. DBUA must be launched from the target Oracle Home.
  • B. An error is returned because the retention period cannot be reduced.
  • C. All pluggable databases are automatically upgraded as part of a container database upgrade.
  • C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
  • D. A whole database backup must exist before upgrade
  • D. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.
  • E. The database must be opened in read-only mode.
  • F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
F
0 / 1000

Question 14

Which three statements are true about Flashback Data Archive?

  • A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
  • A. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
  • B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
  • B. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
  • C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
  • C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
  • D. A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it.
  • D. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
  • E. CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated.
  • E. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
Answer:

C, D, E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 15

Examine the statements that use flashback technologies:
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMMDD
HH:MI:SS');
SELECT * FROM customers AS OF SCN 123456;
FLASHBACK TABLE customers TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD
HH:MI:SS');
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of
relevant undo data in the undo tablespace?

  • A. A PDB snapshot can be a sparse copy of a source PDB.
  • A. 1,3,6
  • B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
  • B. 1,2,5
  • C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
  • C. 3,4,5
  • D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
  • D. 2,3,5,6
  • E. A PDB snapshot can be a full copy of a source PDB.
  • F. A snapshot copy PDB can be a full copy of a source PDB.
  • G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%
G
50%

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
F
G
0 / 1000
To page 2