The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()
A: Btree
B: bitmap
C: reverse key
D: function based
A: Btree
B: bitmap
C: reverse key
D: function based
举一反三
- The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?() A: B-tree B: bitmap C: reverse key D: function based
- Click the Exhibit(s) button to view the EMPLOYEES table. The EMPLOYEE table contains thousands of rows. The EMP_CODE column is the primary key column. At the end of every month, you are required to perform search queries based on the BASIC_SAL+COMM column values. Which type of index will you create?() A: B-tree Index B: Bitmap Index C: Function-based Index D: Partitioned Index
- You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. Thesales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do?() A: Define the new column as NUL B: Update the FriendlyName column to the same valueas the productName column. Alter the FriendlyName column to be NOT NUL C: D: Define the new column as NOT NULL with a default value of ’Undefined.’ E: Define the new column as NUL F: Use application logic to enforce the data constraint. G: Define the new column as NULL with a default value of ’Undefined.’
- Which one of the followings columns has the highest column efficiency? A: packed column B: WCOT column C: SCOT column D: PLOT column
- In a spreadsheet, a cell is defined as the A: intersection of a table and a row B: intersection of a table and a column C: intersection of a row and column D: intersection of a column and a record