Latest 1Z0-083 Dumps And Practice Questions: Break The 1Z0-083 Exam
Looking for how to break the 1Z0-083 exam? You’ve come to the right place. PassITDump provides you with up-to-date 1Z0-083 dumps and practices questions to help you prepare for the Oracle Database Administration II exam.
Here you can get the latest 1Z0-083 dumps and practice questions that you can use to improve your exam success rate.
These questions are from 1Z0-083 free dumps. All questions in 1Z0-083 dumps are from the latest 1Z0-083 real exams.
Question 1:
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
Question 2:
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: EF
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing-pdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59
Question 3:
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 4:
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
B. creating the oracle OS user
C. creating the OSDBA (dba) group
D. creating thte oraInventory (oinstall) group
E. creating the grid OS user
F. configuring the OS for Oracle Automatic Storage Management shared storage access
Correct Answer: BCD
When installed, the Oracle Preinstallation RPM does the following: Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Preinstallation RPM program Sets hard and soft resource limits Sets other recommended parameters, depending on your kernel version Sets numa=off in the kernel for Linux x86_64 machines. Reference: https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932
Question 5:
Which two are true about common objects? (Choose two.)
A. They can be created only in CDB$ROOT.
B. They can be only metadata-linked in an application container.
C. They can exist in user-defined schemas only in application containers.
D. They can exist in CDB$ROOT and an application root.
E. They can be extended data-linked in CDB$ROOT.
F. They can be created only in an application root.
Correct Answer: DF
A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT.
You can create most schema objects-such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF
D: they can exist in CDB$ROOT and application root.
F: they can be created only in application root.
Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing-of-data-in-application-common-objects
Question 6:
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 7:
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 8:
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 9:
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 10:
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 11:
Which three are true about monitoring waits for sessions and services? (Choose three.)
A. V$SESSION_EVENTdisplays all waits for all past and existing sessions if the wait has occurred at least once for a session.
B. V$SERVICE_EVENTdisplays all waits for all services if the wait has occurred at least once for a service.
C. V$SESSION_WAIT_CLASSdisplays 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_EVENTdisplays 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 12:
You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:
1.
Make the UNIVERSITY tablespace read-only on the source system.
2.
Export the UNIVERSITY tablespace metadata using EXPDP.
3.
Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.
Copy the UNIVERSITY tablespace data files to the destination system.
5.
Copy the Data Pump dump set to the destination system.
6.
Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.
Import the UNIVERSITY tablespace metadata using IMPDP.
8.
Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?
A. 1, 2, 4, 5, 7, 8
B. 1, 2, 4, 6, 7, 8
C. 1, 2, 3, 4, 5, 7, 8
D. 1, 2, 3, 4, 5, 6, 7, 8
E. 2, 4, 5, 6, 7
Correct Answer: C
Question 13:
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 14:
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
B. A connection to an auxiliary instance is always required.
C. A subset of the target database can be duplicated.
D. A new DBID is always created for the duplicated database.
E. A connection to the recovery catalog instance is always required.
F. A backup of the target database is always required.
G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
H. A connection to the target database instance is always required.
Correct Answer: ABCG
Question 15:
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1.
PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING `/u01/app/oracle/oradata/pdb1.xml\’
SOURCE_FILE_NAME_CONVERT =
(`/u01/app/oracle/oradata/\’, `/u02/app/oracle/oradata/\’);
Which two are true? (Choose two.)
A. PDB1 data files already exist in the correct location.
B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
C. PDB_FILE_NAME_CONVERT must be set before executing the command.
D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
E. PDB1 must be dropped from CDB1.
Correct Answer: AE
Reference: http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html