Get 2023 Updated Free Oracle 1Z1-083 Exam Questions & Answer [Q13-Q32]

Rate this post

Get 2023 Updated Free Oracle 1Z1-083 Exam Questions and Answer

1Z1-083 Dumps PDF and Test Engine Exam Questions

Q13. Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

defining primary keys for all tables to speed up all queries

using check constraints to speed up updates

defining foreign keys for all tables to speed up joins

the physical data model

the configuration of storage arrays

Q14. Which three are true about monitoring waits for sessions and services? (Choose three.)

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

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

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 sessions if the wait has occurred at least once for a session.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Q15. In which two situations can you use Database Upgrade Assistant? (Choose two.)

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

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

Q16. Which three are true about managing memory components in an Oracle database instance? (Choose three.)

With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Q17. Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
(Choose three.)

Some messages in the error stack are not errors.

If an RMAN command fails, the output will only identify the command that failed.

If an RMAN command fails, the output will identify the channel ID where the failure occurred.

Media Management errors appear as a line with “sbtio” and a number.

Media Management errors appear as a line with “sbtio”.

Media Management errors appear as a line with “Additional information” and a number.

Q18. Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?

SBT tape compression can be used even if no RMAN compression is configured.

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

SBT tape compression and RMAN backup compression should be used in parallel.

The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously

Q19. Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

CDB$ROOT and PDB$SEED are automatically duplicated.

Q20. Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST=’/u01/app/oracle/oradata/cdb1/pdb1′ ; Which three are true about PDB1?

It has the same common users defined as does CDB1.

It has only local roles.

It has the same number of roles as CDB1.

Service PDB1 is created for remote logins to PDB1.

It is in mount state after creation.

It has no local users.

Q21. Which three are true about the SQL Tuning Advisor? (Choose three.)

It checks each query being analyzed for stale statistics.

It checks each query being analyzed for missing statistics.

It only recommends syntactic changes to SQL statements.

It can recommend semantic changes to SQL statements.

It considers all SQL statements being analyzed by the advisor task as a group.

It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Q22. Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

using the KEEP FOREVER clause with the BACKUP command

using RMAN stored scripts

using the REPORT SCHEMA command to list a database’s current data files and tablespaces

creating customized reports about a single database’s backups

creating encrypted backups

using the REPORT SCHEMA command to list a database’s data files and tablespaces at times in the past

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

Q24. Which two are prerequisites for performing Flashback Transaction?

Fast Recovery Area must be enabled for the database

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

Undo retention guarantee must be configured for the database.

A supplemental log must be enabled for the primary key.

Q25. Choose two. Which two are true about backup encryption?

The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

Vendor-specific media management software can be used for making encrypted RMAN backups to media.

The BACKUP BACKUPSET command can encrypt and decrypt backup sets.

Image copies can be encrypted.

Keystore-based encryption is the default mode for RMAN backup encryption.

Backup encryption can be enabled selectively for specific tablespaces.

Q26. Which two are true about Oracle instance recovery? (Choose three.)

Recovery begins from the beginning of the CURRENT redo log group.

Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Q27. Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?

mounting disk groups

acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

managing extent allocation for Oracle database segments

managing Allocation Units (AUs) for disk group content

managing space allocation for Oracle ASM files

acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)

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

Q29. Choose the best answer. How do you configure a CDB for local undo mode?

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

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

to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

to include specific user tablespaces only when relocating a PDB

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

to exclude a temp tablespace when plugging in a PDB

to specify the list of tablespaces to include when creating a PDB from the CDB seed

Q31. Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

the configuration of storage arrays

the physical data model

defining primary keys for all tables to speed up all queries

defining foreign keys for all tables to speed up joins

using check constraints to speed up updates

Q32. choose two Examine these RMAN commands: RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”; RMAN> CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

It succeeds.

It fails because no parallel channels are allocated for the auxiliary database.

It fails because connection to the AUXILIARY instance must be as SYSDBA.

Itsucceeds only if the target database is greater than 400M.

No catalogued backup of the TARGET is used to duplicate the database.