1Z0-053

单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor

题目
单选题
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）
A

 The SGA Tuning Advisor

B

 The SQL Access Advisor

C

 The SQL Tuning Advisor

D

 The Memory Advisor

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE


参考答案：A, F

第2题：

Which of the following connectors identifies that a motherboard has onboard video capabilities？（）

  • A、DB-15
  • B、DB-9
  • C、DB-25
  • D、RJ-45
  • E、DVI

正确答案:A,E

第3题：

Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

A. It collects statistics into the pending area in the data dictionary

B. It creates a virtual hidden column in the CUSTOMERS_OBE table

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

D. It creates a histogram to hold skewed information about the data in the columns


参考答案：B

第4题：

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

  • A、 The SGA Tuning Advisor
  • B、 The SQL Access Advisor
  • C、 The SQL Tuning Advisor
  • D、 The Memory Advisor

正确答案:C

第5题：

A storage specialist needs to create a new host connection using the DSCLI.  Which of the following parameters identifies the host（）

  • A、hosttype
  • B、volume group
  • C、ioports
  • D、WWPN

正确答案:D

第6题：

Which of the following is the proper pronunciation of "meet you" as a result of assimilation


A./mi:t ju:/

B./mi:t ju/

C./mi:tju:/

D./mi:t∫u:/

答案：D
解析：
考查音的同化。当／t／，／d／，／s／，／z／遇到半元音[j]时，会分别发生新的辅音／t∫／，／d／，／∫／，／／。本题中的／t／遇到／j／产生了新的辅音／t∫／，故本题的正确答案为D。

第7题：

Which of the following commands identifies all network adapter types that are installed in a machine？（）

  • A、lsdev
  • B、lsattr
  • C、ifconfig
  • D、netstat

正确答案:A

第8题：

Consider the following:Which statement best describes the meaning of the value for the key_len column?()

A.It shows the total size of the index row

B.It shows how many columns in the index are examined

C.It shows the number of characters indexed in the key

D.It shows how many bytes will be used from each index row


参考答案：D

第9题：

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） 

  • A、 Index-organized table
  • B、 Mapping Table
  • C、 Clustered Table
  • D、 Journal Table

正确答案:D

第10题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

  • A、Immediately following statement execution 
  • B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
  • C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
  • D、After the ALTER TABLE MODIFY command is issued

正确答案:B

更多相关问题
相关内容