The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第1题:
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. Composite index on ORDER_ID and ORDER_DATE
第2题:
Which of the following connectors identifies that a motherboard has onboard video capabilities?()
第3题:
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
第4题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
第5题:
A storage specialist needs to create a new host connection using the DSCLI. Which of the following parameters identifies the host()
第6题:
第7题:
Which of the following commands identifies all network adapter types that are installed in a machine?()
第8题:
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
第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?()
第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?()