搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【多项选择题】

Exhibit:&ensp;View&ensp;the&ensp;Exhibit&ensp;and&ensp;examine&ensp;the&ensp;properties&ensp;of&ensp;the&ensp;USERS&ensp;tablespace.&ensp;You&ensp;execute&ensp;the&ensp;following&ensp;statement&ensp;to&ensp;shrink&ensp;the&ensp;TRANS&ensp;table&ensp;existing&ensp;on&ensp;the&ensp;USERS&ensp;tablespace:&ensp;SQL&gt;&ensp;ALTER&ensp;TABLE&ensp;trans&ensp;SHRINK&ensp;SPACE&ensp;CASCADE;&ensp;<br /> Which&ensp;objects&ensp;would&ensp;be&ensp;affected&ensp;by&ensp;this&ensp;command?()<br /> <img src="https://img.ppkao.com/2018-08/xiashuhui/2018080115421077159.jpg" /><p> Exhibit:&ensp;View&ensp;the&ensp;Exhibit&ensp;and&ensp;examine&ensp;the&ensp;properties&ensp;of&ensp;the&ensp;USERS&ensp;tablespace.&ensp;You&ensp;execute&ensp;the&ensp;following&ensp;statement&ensp;to&ensp;shrink&ensp;the&ensp;TRANS&ensp;table&ensp;existing&ensp;on&ensp;the&ensp;USERS&ensp;tablespace:&ensp;SQL&gt;&ensp;ALTER&ensp;TABLE&ensp;trans&ensp;SHRINK&ensp;SPACE&ensp;CASCADE;&ensp;<br /> Which&ensp;objects&ensp;would

A、A. the materialized views based on the TRANS table

B、B. the materialized views log of the TRANS table

C、C. the TRANS table

D、D. the B*Tree indexes on the TRANS table

E、E. the large object (LOB) segments of the TRANS table

更多“Exhibit:&ensp;View&ensp;the&ensp;Exhibit&ensp;and&ensp;examine&ensp;the&ensp;properties&ensp;of&ensp;the&ensp;USERS&ensp;tablespace.&ensp;You&ensp;execute&ensp;the&ensp;following&ensp;statement&ensp;to&ensp;shrink&ensp;the&ensp;TRANS&ensp;table&ensp;existing&ensp;on&ensp;the&ensp;USERS&ensp;tablespace:&ensp;SQL&gt;&ensp;ALTER&ensp;TABLE&ensp;trans&ensp;SHRINK&ensp;SPACE&ensp;CASCADE;&ensp;<br /> Which&ensp;objects&ensp;would&ensp;be&ensp;affected&ensp;by&ensp;this&ensp;command?()<br /> <img src="https://img.ppkao.com/2018-08/xiashuhui/2018080115421077159.jpg" /><p> Exhibit:&ensp;View&ensp;the&ensp;Exhibit&ensp;and&ensp;examine&ensp;the&ensp;properties&ensp;of&ensp;the&ensp;USERS&ensp;tablespace.&ensp;You&ensp;execute&ensp;the&ensp;following&ensp;statement&ensp;to&ensp;shrink&ensp;the&ensp;TRANS&ensp;table&ensp;existing&ensp;on&ensp;the&ensp;USERS&ensp;tablespace:&ensp;SQL&gt;&ensp;ALTER&ensp;TABLE&ensp;trans&ensp;SHRINK&ensp;SPACE&ensp;CASCADE;&ensp;<br /> Which&ensp;objects&ensp;would”相关的问题
第2题

A、A.Memory&<em>enspem>;Advisor  B、B.Segment&<em>enspem>;Advisor  C、C.SQL&<em>enspem>;Tuning&<em>enspem>;and&<em>enspem>;Access&<em>enspem>;Advisors  D、D.Automatic&<em>enspem>;Workload&<em>enspem>;Repository&<em>enspem>;(AWR)  EE.Automatic&<em>enspem>;Database&<em>enspem>;Diagnostic&<em>enspem>;Monitor&<em>enspem>;(ADDM)  

点击查看答案
第4题

A、&<em>enspem>;Schedule,create&<em>enspem>;new&<em>enspem>;package,<em>viewem>&<em>enspem>;manifest,<em>viewem>&<em>enspem>;contents  B、&<em>enspem>;Create&<em>enspem>;new&<em>enspem>;package,<em>viewem>&<em>enspem>;manifest,<em>viewem>&<em>enspem>;contents,schedule  C、&<em>enspem>;Schedule,create&<em>enspem>;new&<em>enspem>;package,<em>viewem>&<em>enspem>;contents,<em>viewem>&<em>enspem>;manifest  D、&<em>enspem>;Create&<em>enspem>;new&<em>enspem>;package,<em>viewem>&<em>enspem>;contents,<em>viewem>&<em>enspem>;manifest,schedule  E、&<em>enspem>;None&<em>enspem>;of&<em>enspem>;the&<em>enspem>;above.  

点击查看答案
第5题
[] <em>Exhibitem>:&<em>enspem>;<em>Viewem>&<em>enspem>;the&<em>enspem>;<em>Exhibitem>&<em>enspem>;and&<em>enspem>;examine&<em>enspem>;the&<em>enspem>;characteristic&<em>enspem>;of&<em>enspem>;the&<em>enspem>;USERS&<em>enspem>;tablespace.&<em>enspem>;You&<em>enspem>;observe&<em>enspem>;that&<em>enspem>;a&<em>enspem>;large&<em>enspem>;volume&<em>enspem>;of&<em>enspem>;inserts&<em>enspem>;and&<em>enspem>;deletes&<em>enspem>;are&<em>enspem>;happening&<em>enspem>;on&<em>enspem>;the&<em>enspem>;TRANS&<em>enspem>;table&<em>enspem>;in&<em>enspem>;the&<em>enspem>;USERS&<em>enspem>;tablespace&<em>enspem>;and&<em>enspem>;you&<em>enspem>;suspect&<em>enspem>;that&<em>enspem>;the&<em>enspem>;TRANS&<em>enspem>;table&<em>enspem>;is&<em>enspem>;fragmented.&<em>enspem>;Which&<em>enspem>;advisory&<em>enspem>;component&<em>enspem>;would&<em>enspem>;you&<em>enspem>;refer&<em>enspem>;to,&<em>enspem>;in&<em>enspem>;order&<em>enspem>;to&<em>enspem>;find&<em>enspem>;information&<em>enspem>;about&<em>enspem>;table&<em>enspem>;fragmentation?() <em>Exhibitem>:&<em>enspem>;<em>Viewem>&<em>enspem>;the&<em>enspem>;<em>Exhibitem>&<em>enspem>;and&<em>enspem>;examine&<em>enspem>;the&<em>enspem>;characteristic&<em>enspem>;of&<em>enspem>;the&<em>enspem>;USERS&<em>enspem>;tablespace.&<em>enspem>;You&<em>enspem>;observe&<em>enspem>;that&<em>enspem>;a&<em>enspem>;large&<em>enspem>;volume&<em>enspem>;of&<em>enspem>;inserts&<em>enspem>;and&<em>enspem>;deletes&<em>enspem>;are&<em>enspem>;happening&<em>enspem>;on&<em>enspem>;the&<em>enspem>;T

A、A.&<em>enspem>;Memory&<em>enspem>;Advisor  B、B.&<em>enspem>;Segment&<em>enspem>;Advisor  C、C.&<em>enspem>;SLQ&<em>enspem>;Tuning&<em>enspem>;Advisor  D、D.&<em>enspem>;SLQ&<em>enspem>;Access&<em>enspem>;Advisor  EE.&<em>enspem>;Automatic&<em>enspem>;Database&<em>enspem>;Diagnostic&<em>enspem>;Monitor&<em>enspem>;(ADDM)  

点击查看答案
第7题

A、Checkpoint&<em>enspem>;(CKPT)  B、Process&<em>enspem>;Monitor&<em>enspem>;(PMON)  C、Archiver&<em>enspem>;Processes&<em>enspem>;(ARCn)  D、Recoverer&<em>enspem>;Process&<em>enspem>;(RECO)  E、Memory&<em>enspem>;Manager&<em>enspem>;process&<em>enspem>;(MMAN)  

点击查看答案
第8题

A、A.DEFTBSP  B、B.SYSTEM  C、C.NEWDEFTBSP  D、D.USERS&<em>enspem>;and&<em>enspem>;NEWDEFTBSP&<em>enspem>;both  EE.USERS  

点击查看答案
客服
TOP

请使用微信扫码支付

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