Updated Dec 19, 2024 Certification Exam 1Z0-083 Dumps - Practice Test Questions
Updated Verified 1Z0-083 dumps Q&As - Pass Guarantee or Full Refund
NEW QUESTION # 167
Choose two. Which two are true about server-generated alerts?
- A. Stateless alerts can be cleared manually.
- B. Stateful alerts are purged automatically from the alert history after one day.
- C. Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
- D. Stateless alerts can be purged manually from the alert history.
- E. Stateless alerts are automatically cleared after one day.
Answer: A,B
NEW QUESTION # 168
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
- A. Run the Memory Advisor for the Program Global Area.
- B. Run the SQL Tunning Advisor.
- C. Run the SQL Access Advisor.
- D. Run the Memory Advisor for the System Global Area.
- E. Run the Memory Advisor for the shared pool.
Answer: E
NEW QUESTION # 169
Which two statements are true about sequences in a single instance Oracle database?
- A. Sequence numbers that are allocated require a COMMIT statement to make the allocation permanent.
- B. Sequences that start with 1 and increment by 1 can never have gaps.
- C. The data dictionary is always updated each time a sequence number is allocated.
- D. A sequence can provide numeric values for more than one column or table.
- E. A sequence can issue the same number more than once.
Answer: D,E
NEW QUESTION # 170
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$SESSION
- C. V$SESSTAT
- D. V$SESSION_WAIT
- E. V$SESSION_WAIT_CLASS
Answer: A
Explanation:
The V$SESSION_EVENT view provides summary of all the events the session has waited for since it started.
NEW QUESTION # 171
Which two are true about gathering optimizer statistics? (Choose two.)
- A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- C. System statistics can be gathered only while connected to CDB$ROOT.
- D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
Answer: A,B
Explanation:
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%20have%20to,independently%20from%20the%20CDB%24ROOT.&text=Oracle%20Database%20automatically%20gathers%20fixed,Automatic%20Optimizer%20Statistics%20Collection%E2%80%9C) .
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html
NEW QUESTION # 172
Which two are true about RMAN backups when using a media manager? (Choose two.)
- A. By default, a request for a proxy copy may result in a backup set being created.
- B. A media manager is required to create RMAN image copies.
- C. A media manager is required to create RMAN proxy copies.
- D. A media manager always writes RMAN requested backups to tape.
- E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
Answer: A,C
Explanation:
https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107 A is incorrect - zdlra backups are sbt backups but not written to tape always E is incorrect - Not all are supported B If the media manager cannot proxy copy the file, then RMAN backs up the file as if the PROXY option had not been used From: https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV89487
NEW QUESTION # 173
Which three are true about corrupted data blocks and their recovery in an Oracle Database?
- A. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
- B. A media corrupt block is one where the block is not formatted correctly.
- C. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
- D. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
- E. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
- F. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.
Answer: A,C,F
NEW QUESTION # 174
Which two are prerequisites for performing Flashback Transaction?
- A. Undo retention guarantee must be configured for the database.
- B. Row movement must be enabled.
- C. Fast Recovery Area must be enabled for the database
- D. A supplemental log must be enabled for the primary key.
- E. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
Answer: D,E
NEW QUESTION # 175
Which three are true about an application container? (Choose three.)
- A. It can contain a single application.
- B. It must have an application root PDB.
- C. It must have an application seed PDB.
- D. An application PDB can belong to multiple application containers.
- E. It can contain multiple applications.
- F. Two application containers can share an application seed PDB.
Answer: A,B,D
NEW QUESTION # 176
Choose two. Which two statements are true when row-archival management is enabled?
- A. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.
- B. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.
- C. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.
- D. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
- E. The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query
Answer: B,E
NEW QUESTION # 177
Choose three. Which three are true about cloning databases into an existing CDB with RMAN?
- A. Two or more PDBs can be cloned with the same command.
- B. Only one PDB can be cloned at a time.
- C. The target and auxiliary instance passwords must be the same.
- D. A non-CDB can be cloned into a PDB.
- E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
- F. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
Answer: B,E,F
NEW QUESTION # 178
Which three are true? (Choose three.)
- A. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
- B. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- C. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- D. Application-common TSDP policies are always container specific.
- E. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- F. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- G. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
Answer: C,E,G
NEW QUESTION # 179
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts can be cleared manually.
- B. Stateful alerts must be created by a DBA after resolving the problem.
- C. Stateful alerts are purged automatically from the alert history.
- D. Stateless alerts are automatically cleared.
- E. Stateless alerts can be purged manually from the alert history.
Answer: A,B
NEW QUESTION # 180
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.)
- A. The insert on USER2.DEPT fails because of the active transaction in the parent container.
- B. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
- C. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
- D. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
- E. The insert on USER2.DEPT is uncommitted.
- F. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
- G. The inserts on USER1.EMP were committed when the session connected to PDB2.
Answer: B,F
NEW QUESTION # 181
Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
- A. general operating system health
- B. log writer performance
- C. database writer performance
- D. database instance memory management and sizes
- E. SQL statements
Answer: D
NEW QUESTION # 182
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.)
- A. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
- B. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
- C. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
- D. 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.
- E. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
- F. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
- G. 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.
Answer: B,D,E
NEW QUESTION # 183
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
- A. The BACKUP PLUGGABLE DATABASEcommand can be used to back up CDB$ROOT.
- B. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
- C. The BACKUP DATABASE PLUS ARCHIVELOGcommand will back up archive logs when RMAN is connected to a PDB.
- D. SPFILEbackups can be created while connected to an application root PDB.
- E. The BACKUP DATABASEcommand will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
Answer: B,E
NEW QUESTION # 184
Choose three. Which three are true about the Oracle Optimizer?
- A. It updates stale object statistics in the Data Dictionary.
- B. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
- C. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
- D. It considers object statistics when generating execution plans for SQL statements.
- E. It can re-optimize execution plans after previous executions detect suboptimal plans.
- F. It obeys all hints.
Answer: A,C,E
NEW QUESTION # 185
Which two are true about instance recovery?
- A. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
- B. Setting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
- C. It is performed automatically while the database remains in mount state. Then the database is opened.
- D. Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.
- E. It is not possible if an archived log is missing.
- F. It is performed by the Recovery Writer (rvwr) background process.
Answer: B,E
NEW QUESTION # 186
Choose two. Which two are true about various Oracle security and auditing capabilities?
- A. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
- B. Application-common OLS policies can be created only if all the PDBs in the application container are closed.
- C. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- D. Application-common TSDP policies are always container specific.
- E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.
Answer: C,E
NEW QUESTION # 187
Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?
- A. It fails because the command does notspecify when the unified audit policy should be enforced.
- B. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
- C. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
- D. It fails because system privileges cannot be granted with roles in the same audit policy.
Answer: C
NEW QUESTION # 188
Choose three. Which three are true about patchsets?
- A. They are installed via OPatch or OPatchAuto.
- B. A base release is not needed to install patchsets.
- C. They can introduce new features.
- D. Installing a patchset is considered an "upgrade."
- E. They can be applied in a rolling fashion for Clusterware and the databases.
- F. They are only released quarterly.
Answer: C,D,E
NEW QUESTION # 189
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 removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
- C. It empties the RECYCLE BIN.
- D. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- E. It sets all user tablespaces to "read-only" before starting the upgrade.
- F. It increases tablespace size, if required, to meet upgrade requirements.
Answer: A,D,F
Explanation:
Reference:
https://oracle-base.com/articles/12c/upgrading-to-12c
NEW QUESTION # 190
Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)
- A. creating encrypted backups
- B. using the KEEP FOREVER clause with the BACKUP command
- C. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past
- D. using the REPORT SCHEMA command to list a database's current data files and tablespaces
- E. using RMAN stored scripts
- F. creating customized reports about a single database's backups
Answer: B,C,E
Explanation:
A is correct:
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html
"Specifies that the backup or copy never becomes obsolete (see Example 2-27). A recovery catalog is required when FOREVER is specified because the backup records eventually age out of the control file." B is correct:
https://docs.oracle.com/database/121/RCMRF/rcmsynta013.htm
"Execute CREATE SCRIPT only at the RMAN prompt. RMAN must be connected to a target database and a recovery catalog." F is correct:
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/REPORT.html
"atClause
This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMA command with an AT clause."
NEW QUESTION # 191
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- A. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
- B. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
- C. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- D. to include specific user tablespaces only when relocating a PDB
- E. to exclude a temp tablespace when plugging in a PDB
- F. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
Answer: C,F
NEW QUESTION # 192
......
Exam Engine for 1Z0-083 Exam Free Demo & 365 Day Updates: https://topexamcollection.pdfvce.com/Oracle/1Z0-083-exam-pdf-dumps.html