Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 261:

  Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

  A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

  B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.

  C. The Oracle Grid Infrastructure installation must be owned by the grid user.

  D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

  E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.

  F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

  Correct Answer: BD

  A - false - Members of this group are granted the SYSASM system privilege to administer Oracle ASM.SYSASM system privileges do not grant access privileges on an Oracle Database instance. B- Correct C - false Only if you wish to define role separation but is not a must D - correct E- false OSOPER is optional is not a must F - the same OSDBA could be used but is not a must ( usually SYSDBA and SYSASM are used for separation us duties )

  Reference: https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99-4C6D-85D6-868CBA6F5DAE

• Question 262:

  Which two are true about the character sets used in an Oracle database? (Choose two.)

  A. Single-byte character sets provide better performance than multibyte character sets.

  B. Unicode enables information from any language to be stored using a single character set.

  C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

  D. Single-byte character sets always use 7-bit encoding schemes.

  E. Multibyte character sets allow more efficient space utilization than single byte character sets.

  F. Single-byte character sets always use 8-bit encoding schemes.

  Correct Answer: AB

  A > Single-byte character sets result in better performance than multibyte character sets, and they also are the most efficient in terms of space requirements.

  B> Unicode is a universal encoded character set that enables information from any language to be stored using a single character set.

  Reference:

  https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166

  https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch6unicode.htm#:~:text=Unicode%20is%20a%20universal%20encoded%20character%20set%20that,been%20adopted%20by%20many%20software%20and%20hardware%

  20vendors.

• Question 263:

  Which three are true about monitoring waits for sessions and services? (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.

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

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

  D. V$SESSION_WAITand V$SESSION both contain details of the event on which a non-waiting session last waited.

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

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

  Correct Answer: BDF

  A, E - False : V$SESSION_EVENT displays information on waits for an event by a session.

  V$SESSION_WAIT_HISTORY displays the last 10 wait events for each active session.

  B - V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic.

  C - False : V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis.

  D, F - True : V$SESSION_WAIT displays the current or last wait for each session. V$SESSION.EVENT If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the

  resource or event for which the session most recently waited.

  Resource :

  https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8

• Question 264:

  Which three are true about opatchauto? (Choose three.)

  A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

  B. It must be invoked by a user with root user privileges.

  C. Patches are applied via opatchauto.

  D. Users must always input patch plans to opatchauto.

  E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

  F. It applies patches in nonrolling mode by default.

  G. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

  Correct Answer: ABG

  A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process. => True

  B. It must be invoked by a user with root user privileges. => true

  C. Patches are applied via opatchauto. => not always.

  D. Users must always input patch plans to opatchauto. => false, patch plans is optional

  E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked. => false

  F. It applies patches in nonrolling mode by default. => false, default is rolling mode.

  G. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations. => true

  Correct: A,B,G Reference: https://docs.oracle.com/cd/E24628_01/doc.121/e39376/opatchauto_commands.htm#OPTCH585 https://docs.oracle.com/cd/E24628_01/doc.121/e39376/configuration_patching.htm#OPTCH149

• Question 265:

  Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

  A. It analyzes a period of time corresponding to the 12 hours of activity.

  B. It runs automatically after each AWR snapshot.

  C. A DBA can run it manually.

  D. Results are written to the alert log.

  E. It analyzes a period of time corresponding to the last day of activity.

  Correct Answer: BC

  Results are written to the alert log. -Incorrect .. stores in AWR not in alert logfile.

• Question 266:

  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.

  Correct Answer: BC

  Best to start with defining stateful/stateless: A stateful alert is a threshold based alert (ie, tablespace usage above 90%), a stateless alert is non-threshold based alert (ie, a capture aborted with an ORA- error).

  A stateful alert first appears in DBA_OUTSTANDING_ALERTS. When cleared, it goes to DBA_ALERT_HISTORY.

  A stateless alert goes straight to DBA_ALERT_HISTORY

  A stateless alert can be considered as a "point in time" error, the DB tells you about it and then forgets that it ever spoke about it.

  Therefore, each answer:

  A: FALSE - the DB creates stateful alerts, not a DBA.

  B: TRUE - a DBA can perform a purge to bulk remove alerts, perhaps based on date

  C: TRUE - a DBA can clear individual alerts

  D: FALSE - Stateless alerts are never checked again, by the DB, so cannot be automatically cleared

  E: FALSE - Stateful alerts are purged from the "Outstanding Alerts" and put into the alert history, where they will remain.

  Therefore, BC are correct

  Reference: https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/

• Question 267:

  Which three are located by using environment variables? (Choose three.)

  A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

  B. the location of Oracle Net Services configuration files

  C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

  D. default directories for temporary files used by temporary tablespaces

  E. the temporary disk space used by Oracle Installer during installation

  F. the maximum number of database files that can be opened by a database instance

  Correct Answer: ABE

  A - ORACLE_BASE, ORACLE_HOME - correct B - TNS_ADMIN, old TWO_TASK, etc - correct C - spfile parameter ASM_DISKGROUPS, not env variable D - [s]pfile parameter DB_CREATE_FILE_DEST, not env variable E - TMP, TEMP - correct F - [s]pfile parameter DB_FILES, not env variable

• Question 268:

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

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

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

  C. to include specific user tablespaces only when relocating a PDB

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

  E. to exclude a temp tablespace when plugging in a PDB

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

  Correct Answer: BD

• Question 269:

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

  A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

  B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

  C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

  D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

  E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

  F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

  Correct Answer: BDF

  A is incorrect. Although the statement "FLASHBACK transaction query requires undo" is true, it is asking to retrieve all versions of a row instead. The correct answer should be F which is FLASHBACK version query to retrieve versions between two point in time from undo.

  A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

  F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

  Reference: https://books.google.com.pk/books?id=0iwrL9P25Z0Candpg=PA35andlpg=PA35anddq=FLASHBACK+transaction+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in +timeandsource=blandots=MJnYl5CZ1uandsig=ACfU3U0dWP-NPd-U8uu3zbaoi3YZzT0FTQandhl=enandsa=Xandved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v=onepageandq=FLASHBACK%20transaction%20query%20requires% 20undo%20to%20retrieve%20all%20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20timeandf=false https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm

• Question 270:

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

  A. All metrics are instance related.

  B. Cleared stateful alerts 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 a specific unit.

  F. STATISTICS_LEVEL must be set to ALL to generate alerts.

  Correct Answer: BCE

  A. False. Tablespace Space Usage metris is database related

  B. True. Stateful alerts appear in DBA_OUTSTANDING_ALERTS and, when cleared, go to DBA_ALERT_HISTORY

  C. True. Most alerts (such as "Out of space") are clared automatically when the cause of the problem disappears.

  D. False. They're generated by MMON

  E. True

  F. False. This parameter is not required to generate alerts

  Reference: Oracle Database 12c: Administration Wrokshop https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2