AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-062





Question ID 21725

Examine the query and its output:
SQL> SELECT REASON, metric_value FROM dba_outstanding_alerts;

REASONMETRIC_VALUE
----------------------------------- -------------------
Tablespace [TEST] is [28 perce 28.125
nt] full
Metrics "Current Logons Count"29
Metrics "Database Time Spent99.0375405
waiting (%)" is at 99.03754 for
event class "Application"
db_recovery_file_dest_size of97
4294967296 bytes is 97.298 used
and has 116228096 remaining
bytes available.
After 30 minutes, you execute the same query:
SQL> SELECT reason, metric_value FROM dba_outstanding_alerets;
REASONMETRIC_VALUE
------------------------------ ---------------
Tablespace [TEST] is [28 percs 28.125
nt] full
What might have caused three of the alerts to disappear?

Option A

The threshold alerts were cleared and transferred to d0A_alert_history.

Option B

An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second

Option C

An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.

Option D

The database instance was restarted before the execution of the second query.

Correct Answer D
Explanation


Question ID 21726

Which two statements are true?

Option A

A role cannot be assigned external authentication.

Option B

A role can be granted to other roles.

Option C

A role can contain both system and object privileges.

Option D

The predefined resource role includes the unlimited_tablespace privilege.

Option E

All roles are owned by the sys user.

Option F

The predefined connect role is always automatically granted to all new users at the time of their creation.

Correct Answer B,C
Explanation Reference: http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG99878 (the functionality of roles)

Send email to admin@getfreedumps for new dumps request!!!