网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor” 相关考题
考题
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 dictionaryB. It creates a virtual hidden column in the CUSTOMERS_OBE tableC. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENTD. It creates a histogram to hold skewed information about the data in the columns
考题
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 rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row
考题
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_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
考题
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:/
考题
Which of the following connectors identifies that a motherboard has onboard video capabilities?()A、DB-15B、DB-9C、DB-25D、RJ-45E、DVI
考题
Which of the following commands identifies all network adapter types that are installed in a machine?()A、lsdevB、lsattrC、ifconfigD、netstat
考题
A storage specialist needs to create a new host connection using the DSCLI. Which of the following parameters identifies the host()A、hosttypeB、volume groupC、ioportsD、WWPN
考题
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 tableB、 Mapping TableC、 Clustered TableD、 Journal Table
考题
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?() A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor
考题
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
考题
You executed the following procedure to collect statistics regarding an index: SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE; Which view will you use to determine whether you need to rebuild the index or not?() A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
You issued the following statement to monitor the usage of the index: SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE; Which view will you query to ensure that the index is being monitored?() A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?()A、disabling the indexB、making the index invisibleC、making the index unusableD、using the MONITORING USAGE clause for the index
考题
Consider the following statement: SQL EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (- 2 ownname = ‘OE’, - 3 estimate_percent = DBMS_STATS.AUTO_SAMPLE_SIZE, - 4 method opt = ‘for all columns size AUTO’); What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?()A、The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B、The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.C、The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. D、The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
考题
单选题Which of the following is the proper pronunciation of meet you as a result of assimilation?A
[ma:tju:]B
[mi:tju]C
[mi:tju:]D
[mi: tʃu:]
考题
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A
The SGA Tuning AdvisorB
The SQL Access AdvisorC
The SQL Tuning AdvisorD
The Memory Advisor
考题
单选题Consider the following statement: SQL EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (- 2 ownname = ‘OE’, - 3 estimate_percent = DBMS_STATS.AUTO_SAMPLE_SIZE, - 4 method opt = ‘for all columns size AUTO’); What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?()A
The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B
The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.C
The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. D
The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
考题
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A
The SGA Tuning AdvisorB
The SQL Access AdvisorC
The SQL Tuning AdvisorD
The Memory Advisor
考题
单选题You executed the following procedure to collect statistics regarding an index: SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE; Which view will you use to determine whether you need to rebuild the index or not?()A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
考题
多选题Which of the following connectors identifies that a motherboard has onboard video capabilities?()ADB-15BDB-9CDB-25DRJ-45EDVI
考题
单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? ()A
Size of typical transactions B
Concurrent transactions C
Size of rows in table most frequently changed D
Number of anticipated disk sorts
考题
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A
When the instance is started B
When the database is mounted C
When the database is opened D
When the database is closed
考题
单选题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:/
考题
单选题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 tableB
Mapping TableC
Clustered TableD
Journal Table
考题
单选题You issued the following statement to monitor the usage of the index: SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE; Which view will you query to ensure that the index is being monitored?()A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
考题
单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?()A
OPTIMAL B
INITIAL C
PCTINCREASE D
NEXT
考题
多选题Examine the following output: SQL SELECT index_name,status FROM dba_indexes WHERE status=’UNUSABLE’; INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true()AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt, and has to be re-created.DThe index is automatically rebuilt when used the next time
考题
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? ()ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
热门标签
最新试卷