搜题

【单选题】

As&ensp;DBA&ensp;for&ensp;the&ensp;Rebel&ensp;Alliance&ensp;you&ensp;have&ensp;decided&ensp;that&ensp;you&ensp;need&ensp;to&ensp;facilitate&ensp;some&ensp;redundancy&ensp;in&ensp;your&ensp;database.&ensp;Using&ensp;ASM，&ensp;you&ensp;want&ensp;to&ensp;create&ensp;a&ensp;disk&ensp;group&ensp;that&ensp;will&ensp;provide&ensp;for&ensp;the&ensp;greatest&ensp;amount&ensp;of&ensp;redundancy&ensp;for&ensp;your&ensp;ASM&ensp;data&ensp;（you&ensp;do&ensp;not&ensp;have&ensp;advanced&ensp;SAN&ensp;mirroring&ensp;technology&ensp;available&ensp;to&ensp;you，&ensp;unfortunately）.&ensp;<br /> Which&ensp;of&ensp;the&ensp;following&ensp;commands&ensp;would&ensp;create&ensp;a&ensp;disk&ensp;group&ensp;that&ensp;would&ensp;offer&ensp;the&ensp;maximum&ensp;in&ensp;data&ensp;redundancy？（）<img src="https://nimg.ppkao.com/2018-08/chenxin/2018080210075286111.jpg?sign=3a6bca29352ef4abb6a737659ab5bd0e&t=62d2a947" />

A、A

B、B

C、C

D、D

E、E

查看正确答案

更多“ As&ensp;DBA&ensp;for&ensp;the&ensp;Rebel&ensp;Alliance&ensp;you&ensp;have&ensp;decided&ensp;that&ensp;you&ensp;need&ensp;to&ensp;facilitate&ensp;some&ensp;redundancy&ensp;in&ensp;your&ensp;database.&ensp;Using&ensp;ASM，&ensp;you&ensp;want&ensp;to&ensp;create&ensp;a&ensp;disk&ensp;group&ensp;that&ensp;will&ensp;provide&ensp;for&ensp;the&ensp;greatest&ensp;amount&ensp;of&ensp;redundancy&ensp;for&ensp;your&ensp;ASM&ensp;data&ensp;（you&ensp;do&ensp;not&ensp;have&ensp;advanced&ensp;SAN&ensp;mirroring&ensp;technology&ensp;available&ensp;to&ensp;you，&ensp;unfortunately）.&ensp;<br /> Which&ensp;of&ensp;the&ensp;following&ensp;commands&ensp;would&ensp;create&ensp;a&ensp;disk&ensp;group&ensp;that&ensp;would&ensp;offer&ensp;the&ensp;maximum&ensp;in&ensp;data&ensp;redundancy？（）<img src="https://nimg.ppkao.com/2018-08/chenxin/2018080210075286111.jpg?sign=3a6bca29352ef4abb6a737659ab5bd0e&t=62d2a947" />”相关的问题

第1题

[] You&ensp;work&ensp;as&ensp;a&ensp;database&ensp;administrator&ensp;for&ensp;Certkiller&ensp;.com.&ensp;In&ensp;your&ensp;development&ensp;environmentenvironment，&ensp;the&ensp;developers&ensp;are&ensp;responsible&ensp;for&ensp;modifying&ensp;the&ensp;table&ensp;structure&ensp;according&ensp;to&ensp;the&ensp;application&ensp;requirements.&ensp;However，&ensp;you&ensp;want&ensp;to&ensp;keep&ensp;track&ensp;of&ensp;the&ensp;ALTER&ensp;TABLE&ensp;commands&ensp;being&ensp;executed&ensp;by&ensp;developers，&ensp;so&ensp;you&ensp;enable&ensp;auditing&ensp;to&ensp;achieve&ensp;this&ensp;objective.&ensp; Which&ensp;two&ensp;views&ensp;would&ensp;you&ensp;refer&ensp;to&ensp;find&ensp;out&ensp;the&ensp;audit&ensp;information？（） You&ensp;work&ensp;as&ensp;a&ensp;database&ensp;administrator&ensp;for&ensp;Certkiller&ensp;.com.&ensp;In&ensp;your&ensp;development&ensp;environmentenvironment，&ensp;the&ensp;developers&ensp;are&ensp;responsible&ensp;for&ensp;modifying&ensp;the&ensp;table&ensp;stru

A、A.DBA_AUDIT_TRAIL B、B.DBA_AUDIT_SESSION C、C.DBA_FGA_AUDIT_TRAIL D、D.DBA_COMMON_AUDIT_TRAIL

点击查看答案

第2题

[单选题] View&ensp;the&ensp;Exhibit. The&ensp;DBA&ensp;creates&ensp;a&ensp;new&ensp;user&ensp;as&ensp;follows：&ensp; SQL>&ensp;CREATE&ensp;USER&ensp;manfus&ensp;IDENTIFIED&ensp;BY&ensp;manfus&ensp;TEMPORARY&ensp;TABLESPACE&ensp;temp；&ensp; User&ensp;manfus&ensp;creates&ensp;a&ensp;table&ensp;as&ensp;follows：&ensp; SQL>&ensp;CREATE&ensp;TABLE&ensp;material（id&ensp;NUMBER（3））；&ensp; In&ensp;which&ensp;tablespace&ensp;will&ensp;the&ensp;material&ensp;table&ensp;be&ensp;created？（）

A、SYSTEM B、USERS C、PROD D、SYSAUX E、TEMP

点击查看答案

第3题

[] A&ensp;user&ensp;is&ensp;running&ensp;a&ensp;long&ensp;update&ensp;batch&ensp;file.&ensp;Many&ensp;tables&ensp;are&ensp;updated&ensp;and&ensp;all&ensp;the&ensp; statements&ensp;are&ensp;in&ensp;one&ensp;transaction.&ensp;Before&ensp;the&ensp;process&ensp;is&ensp;finished，&ensp;the&ensp;user&ensp;machine&ensp;lost&ensp;power.&ensp;When&ensp;the&ensp;user&ensp;calls&ensp;you，&ensp;what&ensp;should&ensp;you&ensp;do&ensp;as&ensp;DBA？（） A&ensp;user&ensp;is&ensp;running&ensp;a&ensp;long&ensp;update&ensp;batch&ensp;file.&ensp;Many&ensp;tables&ensp;are&ensp;updated&ensp;and&ensp;all&ensp;the&ensp; statements&ensp;are&ensp;in&ensp;one&ensp;transaction.&ensp;Before&ensp;the&ensp;process&ensp;is&ensp;finished，&ensp;the&ensp;user&ensp;machine&ensp;lost&ensp;power.&ensp;When&ensp;the&ensp;user&ensp;calls&ensp;you，&ensp;what&ensp;should&ensp;you&ensp;do&ensp;as&ensp;DBA？（）

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

点击查看答案

第4题

[] 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

点击查看答案

第5题

[单选题] Matthew&ensp;has&ensp;recently&ensp;joined&ensp;NetFx&ensp;Corporation&ensp;as&ensp;a&ensp;junior-level&ensp;Database&ensp;Administrator&ensp;（DBA）.&ensp;He&ensp;is&ensp;asked&ensp;by&ensp;his&ensp;supervisor&ensp;to&ensp;verify&ensp;the&ensp;database&ensp;for&ensp;data&ensp;block&ensp;corruptions.&ensp;He&ensp;uses&ensp;the&ensp;DBVERIFY&ensp;utility&ensp;and&ensp;finds&ensp;that&ensp;two&ensp;data&ensp;blocks&ensp;are&ensp;corrupted&ensp;in&ensp;the&ensp;database.&ensp;&ensp; What&ensp;should&ensp;Matthew&ensp;use&ensp;to&ensp;identify&ensp;the&ensp;corrupted&ensp;blocks&ensp;as&ensp;well&ensp;as&ensp;datafiles&ensp;containing&ensp;these&ensp;blocks？（）&ensp;

A、&ensp;datafile B、&ensp;alert&ensp;log C、&ensp;dynamic&ensp;views D、&ensp;control&ensp;file&ensp;script

点击查看答案

第6题

[] Which Scheduler view（s） can be queried to see which jobs are currently executing？（）

A、A.&ensp;DBA_SCHEDULER_JOB_RUN_DETAILS B、B.&ensp;DBA_SCHEDULER_RUNNING_JOBS C、C.&ensp;DBA_SCHEDULER_CURRENT_JOBS D、D.&ensp;DBA_SCHEDULER_JOBS E、E.&ensp;DBA_SCHEDULER_EXECUTING_JOBS

点击查看答案

第7题

[] You&ensp;are&ensp;working&ensp;as&ensp;a&ensp;DBA&ensp;in&ensp;a&ensp;company.&ensp;The&ensp;datafiles&ensp;in&ensp;the&ensp;database&ensp;are&ensp;as&ensp;follows： &ensp;&ensp; On&ensp;Monday，&ensp;you&ensp;tried&ensp;to&ensp;start&ensp;up&ensp;the&ensp;database&ensp;but&ensp;failed&ensp;because&ensp;all&ensp;the&ensp;control&ensp;files&ensp;were&ensp;missing.&ensp;You&ensp;recreated&ensp;the&ensp;control&ensp;file&ensp;using&ensp;the&ensp;script&ensp;you&ensp;have&ensp;created&ensp;by&ensp;issuing&ensp;the&ensp;ALTER&ensp;DATABASE&ensp;BACKUP&ensp;CONTROLFILE&ensp;TO&ensp;TRACE&ensp;command.&ensp;What&ensp;is&ensp;the&ensp;prerequisite&ensp;for&ensp;recreating&ensp;the&ensp;control&ensp;file？（） You&ensp;are&ensp;working&ensp;as&ensp;a&ensp;DBA&ensp;in&ensp;a&ensp;company.&ensp;The&ensp;datafiles&ensp;in&ensp;the&ensp;database&ensp;are&ensp;as&ensp;follows：

A、A.&ensp;All&ensp;the&ensp;datafiles&ensp;should&ensp;be&ensp;listed&ensp;in&ensp;the&ensp;CREATE&ensp;CONTROLFILE&ensp;statement. B、B.&ensp;The&ensp;DATA2.dbf&ensp;and&ensp;DATA3.dbf&ensp;datafiles&ensp;should&ensp;be&ensp;listed&ensp;in&ensp;the&ensp;CREATE&ensp;CONTROLFILE&ensp;statement.&ensp; C、C.&ensp;The&ensp;SYSTEM01.dbf&ensp;datafile&ensp;should&ensp;be&ensp;listed&ensp;in&ensp;the&ensp;CREATE&ensp;CONTROLFILE&ensp;statement. D、D.&ensp;The&ensp;SYSAUX01.dbf&ensp;datafile&ensp;should&ensp;be&ensp;listed&ensp;in&ensp;the&ensp;CREATE&ensp;CONTROLFILE&ensp;statement.

点击查看答案

第8题

[单选题] You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）

A、Assign&ensp;the&ensp;DEFAULT&ensp;profile&ensp;to&ensp;the&ensp;users B、Set&ensp;the&ensp;RESOURCE_LIMIT&ensp;parameter&ensp;to&ensp;TRUE&ensp;in&ensp;the&ensp;parameter&ensp;file C、Create&ensp;a&ensp;new&ensp;profile&ensp;with&ensp;CPU&ensp;restrictions&ensp;and&ensp;assign&ensp;it&ensp;to&ensp;the&ensp;users D、Specify&ensp;the&ensp;users&ensp;as&ensp;members&ensp;of&ensp;the&ensp;DEFAULT_CONSUMER_GROUP E、Revoke&ensp;the&ensp;DBA&ensp;role&ensp;and&ensp;grant&ensp;CONNECT&ensp;and&ensp;RESOURCE&ensp;role&ensp;to&ensp;the&ensp;users

点击查看答案

第9题

[单选题] You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）

A、Assign&ensp;the&ensp;DEFAULT&ensp;profile&ensp;to&ensp;the&ensp;users B、Set&ensp;the&ensp;RESOURCE_LIMIT&ensp;parameter&ensp;to&ensp;TRUE&ensp;in&ensp;the&ensp;parameter&ensp;file C、Create&ensp;a&ensp;new&ensp;profile&ensp;with&ensp;CPU&ensp;restrictions&ensp;and&ensp;assign&ensp;it&ensp;to&ensp;the&ensp;users D、Specify&ensp;the&ensp;users&ensp;as&ensp;members&ensp;of&ensp;the&ensp;DEFAULT_CONSUMER_GROUP E、Revoke&ensp;the&ensp;DBA&ensp;role&ensp;and&ensp;grant&ensp;CONNECT&ensp;and&ensp;RESOURCE&ensp;role&ensp;to&ensp;the&ensp;users

点击查看答案

第10题

[单选题] What statement about Transit AS is true？（）

A、Traffic&ensp;and&ensp;prefixes&ensp;originating&ensp;from&ensp;Source&ensp;AS&ensp;are&ensp;carried&ensp;across&ensp;a&ensp;Transit&ensp;AS&ensp;to&ensp;reach&ensp;theirdestination&ensp;AS B、Traffic&ensp;and&ensp;prefixes&ensp;originating&ensp;from&ensp;Transit&ensp;AS&ensp;are&ensp;carried&ensp;across&ensp;a&ensp;Stub&ensp;AS&ensp;to&ensp;their&ensp;destination&ensp;AS C、Traffic&ensp;and&ensp;prefixes&ensp;originating&ensp;from&ensp;Transit&ensp;AS&ensp;are&ensp;carried&ensp;across&ensp;a&ensp;Stub&ensp;AS&ensp;to&ensp;their&ensp;Source&ensp;AS D、None&ensp;of&ensp;the&ensp;above

点击查看答案

账号：登录

TOP

请使用微信扫码支付

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