搜题

【单选题】

Your&ensp;alert&ensp;log&ensp;file&ensp;has&ensp;the&ensp;following&ensp;information：&ensp;Tue&ensp;May&ensp;25&ensp;17：43：38&ensp;2004&ensp;<br /> ORA-00060：&ensp;Deadlock&ensp;detected.&ensp;More&ensp;info&ensp;in&ensp;file&ensp;<br /> /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.&ensp;<br /> What&ensp;would&ensp;you&ensp;do&ensp;to&ensp;ensure&ensp;that&ensp;database&ensp;is&ensp;still&ensp;running&ensp;correctly？（）

A、examine the trace file and kill the session that caused the deadlock

B、examine the trace file and kill both the sessions responsible for the deadlock

C、examine the trace file for details and ask the user who caused the deadlock to roll back the transaction

D、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database

E、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

查看正确答案

更多“ Your&ensp;alert&ensp;log&ensp;file&ensp;has&ensp;the&ensp;following&ensp;information：&ensp;Tue&ensp;May&ensp;25&ensp;17：43：38&ensp;2004&ensp;<br /> ORA-00060：&ensp;Deadlock&ensp;detected.&ensp;More&ensp;info&ensp;in&ensp;file&ensp;<br /> /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.&ensp;<br /> What&ensp;would&ensp;you&ensp;do&ensp;to&ensp;ensure&ensp;that&ensp;database&ensp;is&ensp;still&ensp;running&ensp;correctly？（）”相关的问题

第1题

[单选题] View&ensp;the&ensp;Exhibit&ensp;to&ensp;examine&ensp;the&ensp;output&ensp;of&ensp;the&ensp;DBA_OUTSTANDING_ALERTS&ensp;view. After&ensp;30&ensp;minutes，&ensp;you&ensp;executed&ensp;the&ensp;following&ensp;command：&ensp; SQL>&ensp;SELECT&ensp;reason，metric_value&ensp;FROM&ensp;dba_outstanding_alerts；&ensp;REASON&ensp;&ensp;&ensp;&ensp;&ensp;&ensp;&ensp;&ensp;&ensp;METRIC_VALUE&ensp; ------------------------------------------------------------&ensp;&ensp;------------&ensp; Tablespace&ensp;[TEST]&ensp;is&ensp;[28&ensp;percent]full&ensp;&ensp;28.125&ensp; What&ensp;could&ensp;be&ensp;the&ensp;reason&ensp;for&ensp;the&ensp;elimination&ensp;of&ensp;the&ensp;other&ensp;rows&ensp;in&ensp;the&ensp;output（）

A、An&ensp;Automatic&ensp;Workload&ensp;Repository&ensp;snapshot&ensp;has&ensp;been&ensp;taken&ensp;recently. B、The&ensp;non-threshold-based&ensp;alerts&ensp;are&ensp;transferred&ensp;to&ensp;DBA_ALERT_HISTORY. C、The&ensp;threshold&ensp;alerts&ensp;conditions&ensp;are&ensp;cleared&ensp;and&ensp;the&ensp;alerts&ensp;are&ensp;transferred&ensp;to&ensp;DBA_ALERT_HISTORY. D、The&ensp;threshold&ensp;alerts&ensp;related&ensp;to&ensp;database&ensp;metrics&ensp;are&ensp;permanently&ensp;stored&ensp;in&ensp;DBA_ALERT_HISTORY&ensp;but&ensp;not&ensp;the&ensp;threshold&ensp;alerts&ensp;related&ensp;to&ensp;instance&ensp;metrics.

点击查看答案

第2题

[单选题] Which of the following functions does the "ifconfig en0" perform？（）

A、Shuts&ensp;down&ensp;en0 B、Displays&ensp;en0&ensp;settings C、Reconfigures&ensp;en0&ensp;using&ensp;the&ensp;ODM D、Sends&ensp;an&ensp;SNMP&ensp;alert&ensp;to&ensp;the&ensp;network&ensp;administrator

点击查看答案

第3题

[] View&ensp;the&ensp;Exhibit&ensp;to&ensp;examine&ensp;the&ensp;output&ensp;of&ensp;the&ensp;DBA_OUTSTANDING_ALERTS&ensp;view.&ensp;After&ensp;30&ensp;minutes,&ensp;youexecuted&ensp;the&ensp;following&ensp;command: SQL>&ensp;SELECT&ensp;reason,metric_value&ensp;FROM&ensp;dba_outstanding_alerts;&ensp;REASON&ensp;METRIC_VALUE------------------------------&ensp;----------------------&ensp;Tablespace&ensp;[TEST]&ensp;is&ensp;[28&ensp;perce&ensp;28.125&ensp;nt]&ensp;fullWhat&ensp;could&ensp;be&ensp;the&ensp;reason&ensp;for&ensp;the&ensp;elimination&ensp;of&ensp;the&ensp;other&ensp;rows&ensp;in&ensp;the&ensp;output（） View&ensp;the&ensp;Exhibit&ensp;to&ensp;examine&ensp;the&ensp;output&ensp;of&ensp;the&ensp;DBA_OUTSTANDING_ALERTS&ensp;view.&ensp;After&ensp;30&ensp;minutes,&ensp;youexecuted&ensp;the&ensp;following&ensp;command: SQL>&ensp;SELECT&ensp;reason,metric_value&ensp;FROM&ensp;dba_outst

A、A.An&ensp;Automatic&ensp;Workload&ensp;Repository&ensp;snapshot&ensp;has&ensp;been&ensp;taken&ensp;recently. B、B.The&ensp;non-threshold-based&ensp;alerts&ensp;are&ensp;transferred&ensp;to&ensp;DBA_ALERT_HISTORY. C、C.The&ensp;threshold&ensp;alerts&ensp;conditions&ensp;are&ensp;cleared&ensp;and&ensp;the&ensp;alerts&ensp;are&ensp;transferred&ensp;to&ensp;DBA_ALERT_HISTORY. D、D.The&ensp;threshold&ensp;alerts&ensp;related&ensp;to&ensp;database&ensp;metrics&ensp;are&ensp;permanently&ensp;stored&ensp;in&ensp;DBA_ALERT_HISTORY&ensp;but&ensp;notthe&ensp;threshold&ensp;alerts&ensp;related&ensp;to&ensp;instance&ensp;metrics

点击查看答案

第4题

[单选题] Your&ensp;database&ensp;is&ensp;running&ensp;in&ensp;NOARCHIVELOG&ensp;mode.&ensp;Every&ensp;night&ensp;there&ensp;is&ensp;a&ensp;backup&ensp;taken&ensp;using&ensp;RMAN.&ensp;During&ensp;your&ensp;startup&ensp;this&ensp;morning&ensp;you&ensp;received&ensp;en&ensp;error&ensp;regarding&ensp;DISK&ensp;3&ensp;on&ensp;your&ensp;server.&ensp;This&ensp;is&ensp;the&ensp;location&ensp;of&ensp;your&ensp;data&ensp;file&ensp;for&ensp;the&ensp;SYSTEM&ensp;tablespace.&ensp;Which&ensp;option&ensp;is&ensp;open&ensp;to&ensp;you？（）

A、A B、B C、C D、D

点击查看答案

第5题

[多选题] Which two statements are true about alerts（）

A、Clearing&ensp;an&ensp;alert&ensp;sends&ensp;the&ensp;alert&ensp;to&ensp;the&ensp;alert&ensp;history. B、Response&ensp;actions&ensp;cannot&ensp;be&ensp;specified&ensp;with&ensp;server-generated&ensp;alerts. C、The&ensp;nonthreshold&ensp;alerts&ensp;appear&ensp;in&ensp;the&ensp;DBA_OUTSTANDING_ALERTS&ensp;view. D、Server-generated&ensp;alerts&ensp;notify&ensp;the&ensp;problems&ensp;that&ensp;cannot&ensp;be&ensp;resolved&ensp;automatically&ensp;and&ensp;requireadministrators&ensp;to&ensp;be&ensp;notified.

点击查看答案

第6题

[单选题] While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

A、&ensp;It&ensp;would&ensp;result&ensp;in&ensp;an&ensp;error&ensp;because&ensp;the&ensp;warning&ensp;threshold&ensp;cannot&ensp;be&ensp;more&ensp;than&ensp;the&ensp;critical&ensp;threshold. B、&ensp;The&ensp;warning&ensp;threshold&ensp;is&ensp;ignored&ensp;and&ensp;alerts&ensp;would&ensp;be&ensp;generated&ensp;when&ensp;space&ensp;usage&ensp;exceeds&ensp;the&ensp;critical&ensp;threshold. C、&ensp;The&ensp;critical&ensp;threshold&ensp;is&ensp;ignored&ensp;and&ensp;alerts&ensp;would&ensp;be&ensp;generated&ensp;when&ensp;space&ensp;usage&ensp;exceeds&ensp;the&ensp;warning&ensp;threshold. D、&ensp;Both&ensp;threshold&ensp;values&ensp;are&ensp;used&ensp;and&ensp;alerts&ensp;are&ensp;generated&ensp;when&ensp;space&ensp;usage&ensp;exceeds&ensp;the&ensp;respective&ensp;threshold&ensp;values.

点击查看答案

第7题

[单选题] You&ensp;are&ensp;working&ensp;on&ensp;the&ensp;Certkiller&ensp;database.&ensp; What&ensp;is&ensp;the&ensp;default&ensp;name&ensp;of&ensp;the&ensp;alert&ensp;log&ensp;file&ensp;in&ensp;this&ensp;database？（）

A、alert_&ensp;Certkiller&ensp;.log B、alertlog_&ensp;Certkiller&ensp;.log C、alert_log_&ensp;Certkiller&ensp;.log D、Certkiller&ensp;_alert_log.log E、log_alert_：&ensp;Certkiller&ensp;.log F、trace_alert_&ensp;Certkiller&ensp;.log

点击查看答案

第8题

[多选题] You&ensp;executed&ensp;the&ensp;following&ensp;commands&ensp;to&ensp;find&ensp;the&ensp;location&ensp;of&ensp;the&ensp;alert&ensp;log&ensp;file： Where&ensp;is&ensp;the&ensp;alert&ensp;log&ensp;file&ensp;stored（）

A、in&ensp;the&ensp;BACKGROUND_DUMP_DEST&ensp;location；&ensp;in&ensp;text&ensp;format B、in&ensp;the&ensp;BACKGROUND_DUMP_DEST&ensp;location；&ensp;in&ensp;XML&ensp;format C、in&ensp;the&ensp;BACKGROUND_DUMP_DEST&ensp;location；&ensp;in&ensp;both&ensp;text&ensp;and&ensp;XML&ensp;format D、in&ensp;the&ensp;DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert&ensp;directory；&ensp;in&ensp;text&ensp;format E、in&ensp;the&ensp;DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert&ensp;directory；&ensp;in&ensp;XML&ensp;format F、in&ensp;the&ensp;DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert&ensp;directory；&ensp;in&ensp;both&ensp;text&ensp;and&ensp;XML&ensp;format

点击查看答案

第9题

[] Your&ensp;network&ensp;includes&ensp;Windows&ensp;Server&ensp;2008&ensp;R2&ensp;Hyper-V&ensp;servers.&ensp;Each&ensp;Hyper-V&ensp;server&ensp;runs&ensp;multiple&ensp;virtual&ensp;machines&ensp;（VMs）.&ensp;You&ensp;need&ensp;to&ensp;detect&ensp;performance&ensp;issues&ensp;and&ensp;generate&ensp;an&ensp;alert&ensp;when&ensp;Hyper-V&ensp;server&ensp;load&ensp;exceeds&ensp;specific&ensp;thresholds.&ensp;&ensp;&ensp; Which&ensp;tool&ensp;should&ensp;you&ensp;use？（） Your&ensp;network&ensp;includes&ensp;Windows&ensp;Server&ensp;2008&ensp;R2&ensp;Hyper-V&ensp;servers.&ensp;Each&ensp;Hyper-V&ensp;server&ensp;runs&ensp;multiple&ensp;virtual&ensp;machines&ensp;（VMs）.&ensp;You&ensp;need&ensp;to&ensp;detect&ensp;performance&ensp;issues&ensp;and&ensp;generate&ensp;an&ensp;alert&ensp;when&ensp;Hyper-V&ensp;server&ensp;load&ensp;exceeds&ensp;specific&ensp;thresholds.&ensp;&ensp;&ensp; Which&ensp;tool&ensp;should&ensp;you&ensp;use？（）

A、A.Microsoft&ensp;System&ensp;Center&ensp;Capacity&ensp;Planner&ensp;2007 B、B.Microsoft&ensp;System&ensp;Center&ensp;Operations&ensp;Manager&ensp;2007&ensp;R2 C、C.Microsoft&ensp;System&ensp;Center&ensp;Configuration&ensp;Manager&ensp;2007&ensp;R2 D、D.Microsoft&ensp;System&ensp;Center&ensp;Virtual&ensp;Machine&ensp;Manager&ensp;2008&ensp;R2

点击查看答案

第10题

[单选题] View&ensp;the&ensp;Exhibit&ensp;and&ensp;examine&ensp;the&ensp;highlighted&ensp;alert.&ensp;You&ensp;have&ensp;received&ensp;an&ensp;alert&ensp;with&ensp;the&ensp;Category&ensp;specified&ensp;as&ensp;Snapshot&ensp;Too&ensp;Old.&ensp;Which&ensp;page&ensp;would&ensp;you&ensp;open&ensp;from&ensp;the&ensp;Advisor&ensp;Central&ensp;page&ensp;to&ensp;determine&ensp;the&ensp;system&ensp;recommendations&ensp;to&ensp;avoid&ensp;such&ensp;alerts&ensp;in&ensp;future?（）

A、ADDM&ensp; B、Memory&ensp;Advisor&ensp; C、Segment&ensp;Advisor&ensp; D、Undo&ensp;Management&ensp; E、SQL&ensp;Tuning&ensp;Advisor&ensp; F、SQL&ensp;Access&ensp;Advisor

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服