Oracle 1z0-083 Free Practice Questions

NEW QUESTION 1
On the 10th ofAugust, 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?

• A. all backups prior to 10th of August
• B. all backups prior to 22nd of August
• C. all backups prior to 24th of August
• D. all backups prior to 20th of August
• E. all backups prior to 17th of August

Answer: C

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

• A. All metrics are instance related.
• B. Cleared statefulalerts are displayed by querying DBA_ALERT_HISTORY.
• C. A space usage management alert is automatically cleared after the underlying problem is resolved.
• D. They are generated by SMON when a tablespace is 97% full.
• E. Metrics are statistical counts for aspecific unit.
• F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Answer: BCE

NEW QUESTION 3
Which two are true about server-generated alerts? (Choose two.)

• A. Stateful alerts must be created by a DBA after resolving the problem.
• B. Stateless alerts can be purged manually from the alert history.
• C. Stateless alerts can be cleared manually.
• D. Stateless alerts are automatically cleared.
• E. Stateful alerts are purged automatically from the alert history.

Answer: BC

Explanation:
Except for the tablespace space usage metric, which is database related, the other metrics are instance related. Threshold alerts are also referred to as stateful alerts which are automatically cleared when an alert condition clears. Stateful alert appears in DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other server-generated alerts correspond to specific database events such as
ORA-* errors, "Snapshot too old" errors, Recovery Area Low on Free Space, Resumable Session Suspended. These are non threshold based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table. +++ Most alerts (such as "Out of Space") are cleared automatically when the cause of the problem disappears. However, other alerts (such as generic alert log errors) are sent to you for notification and must be acknowledged by you. After taking the corrective measures, you acknowledge an alert by clearing or purging it. Clearing an alert sends the alert to the Alert History which is accessible from Monitoring sub menu. Purging an alert removes it from the Alert History.

NEW QUESTION 4
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A. It recompiles all stored PL/SQL code by using utlrp.sql.
• B. It empties the RECYCLE BIN.
• C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D. It sets all user tablespaces to “read-only” before starting theupgrade.
• E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F. It increases tablespace size, if required, to meet upgrade requirements.

Answer: ACF

NEW QUESTION 5
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.)

• A. to switch an existing Oracle Database home to anewer release of Oracle software on the same server
• B. to switch to a read-only Oracle home
• C. to switch back to the previous Oracle home as part of a rollback operation
• D. to switch the Oracle Database home when using a centralized Rapid Home Provisioningserver
• E. to switch to a patched Oracle Database home

Answer: CE

Explanation:
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.

NEW QUESTION 6
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

• A. It is an Oracle Database service
• B. It cannot be usedto upgrade Oracle Database homes.
• C. It can be used to provision applications.
• D. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
• E. It can be used to provision middleware.

Answer: DE

NEW QUESTION 7
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.)

• A. Backups must be doneincrementally.
• B. Backups must be contained in backup sets.
• C. Backups can be taken only if the database is in ARCHIVELOG mode.
• D. Backups can be done incrementally.
• E. The database must be registered in an RMAN catalog.
• F. Only consistent backups can becreated.

Answer: CE

NEW QUESTION 8
Your CDB has two regular PDBs as well as one application container with two applicationPDBs and an application seed
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

• A. three
• B. eight
• C. seven
• D. six
• E. five

Answer: C

NEW QUESTION 9
Which three are true about Audit policies In container databases (CDBs)?

• A. All audit records are written to the audit trail in CDB$ROOT
• B. A common unified audit policy can be created at the application root level.
• C. A common unified audit policy can be created at the CDB level.
• D. An application PDB cannot have a local audit policy.
• E. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
• F. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

Answer: DEF

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

• A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
• B. Index balanced B*Tree height is considered whenevaluating the cost of using an index.
• C. The Statistics Advisor can help recommend the best way to gather statistics.
• D. Statistics collected using DBMS_STATS always yield the best optimizer result.
• E. The Statistics Advisor generates actions for all recommendations.

Answer: CD

NEW QUESTION 11
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A. By default, AWR snapshots are taken every 60 minutes.
• B. Its collection level is determined by the value of theSTATISTICS_LEVEL database parameter.
• C. By default, AWR snapshots are retained for 7 days.
• D. The taking of AWR snapshots can be disabled.
• E. AWR data is stored in the SYSTEM tablespace.

Answer: ABD

NEW QUESTION 12
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

• A. SBT tape compression can be used even if no RMAN compression is configured.
• B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
• C. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• D. SBT tape compression and RMAN backup compression should be used in parallel.
• E. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Answer: DE

NEW QUESTION 13
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A. using Database Replay
• B. using SQL Developer
• C. using Oracle Data Pump
• D. using operating system file copy utilities
• E. using Database Upgrade Assistant
• F. using the CREATE TABLE AS SELECT SQLstatement

Answer: DEF

NEW QUESTION 14
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

• A. CDB1 and CDB2 must be in shared undo mode.
• B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• D. Cloning HR_ROOT automatically clones HR_PDB1.
• E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Answer: BD

NEW QUESTION 15
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• C. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
• E. It is always possible for RMAN to connect to a pluggable database as a target.
• F. A Virtual Private Catalog used to register a container database can be created in a non-container database.

Answer: DEF

NEW QUESTION 16
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?

• A. V$SESSION_EVENT
• B. V$SESSTAT
• C. V$SESSION_WAIT
• D. V$SESSION_WAIT_CLASS
• E. V$SESSION

Answer: A

NEW QUESTION 17
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

• A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
• 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.
• C. An Oracle database can be restored from backup files copied using O/S utilities.
• D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
• E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
• F. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
• 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: BDE

NEW QUESTION 18
YourSALES_ROOTapplication container has two application PDBs. TheSALES_APPapplication has a common table,FIN.REVENUE, in the two PDBs. Examine this query and its output:

Which two are true? (Choose two.)

• A. The CONTAINERS clause cannot be used in queries on the REVENUEtable.
• B. The REVENUE table must be a list-partitioned table.
• C. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
• D. The MAPTABLE table is a metadata-linked table.
• E. A container map exists for theREVENUE table, but is not enabled.
• F. The REVENUE table partitions are not pruned across the PDBs automatically.

Answer: CE

NEW QUESTION 19
Examine this configuration:
CDB1is a container database.
PDB1andPDB2are pluggable databases inCDB1. You execute these commands successfully:

Which two are true? (Choose two.)

• A. PDB1 and PDB2 are in MOUNT state.
• B. Redo logs are opened.
• C. PDB1 and PDB2 are in READ ONLY state.
• D. CDB$ROOT is in MOUNT state.
• E. PDB$SEED is in READ ONLY state.

Answer: BE

NEW QUESTION 20
Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

• A. Run the SQL Access Advisor.
• B. Run the Memory Advisor for the shared pool.
• C. Run the SQL Tunning Advisor.
• D. Run theMemory Advisor for the Program Global Area.
• E. Run the Memory Advisor for the System Global Area.

Answer: B

NEW QUESTION 21
......