Download Oracle.1z0-083.TestKing.2020-04-15.46q.tqb

Vendor:	Oracle
Exam Code:	1z0-083
Exam Name:	Oracle Database Administration II
Date:	Apr 15, 2020
File Size:	1 MB
Downloads:	1

Download Exam

Demo Questions

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

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

Correct answer: CEF

Explanation:

Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027https://blogs.oracle.com/oem/how-to-clear-an-alert-v2

Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027

https://blogs.oracle.com/oem/how-to-clear-an-alert-v2

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

FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Correct answer: ABC

Explanation:

Reference:https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd-U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v=onepage&q=FLASHBACK%20transaction%20query%20requires%20undo%20to%20retrieve%20all%20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=falsehttps://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm

Reference:

https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd-U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v=onepage&q=FLASHBACK%20transaction%20query%20requires%20undo%20to%20retrieve%20all%20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=false

https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm

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

performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
creating the oracle OS user
creating the OSDBA (dba) group
creating thte oraInventory (oinstall) group
creating the grid OS user
configuring the OS for Oracle Automatic Storage Management shared storage access