单选题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？（）ABtreeBbitmapCreverse keyDfunction 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
Btree
B
bitmap
C
reverse key
D
function based
参考解析
解析：
暂无解析
相关考题：
单选题You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.
单选题Which statement is true when you run the SQL Tuning Advisor with limited scope？（）AAccess path analysis is not performed for the SQL statements.BSQL structure analysis is not performed for the SQL statements.CSQL Profile recommendations are not generated for the SQL statements.DThe staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）ADisplays only the list of default valuesBDisplays only the list of all basic parametersCDisplays the currently in effect parameter valuesDDisplays only the list of all advanced parametersEDisplays the list of all the parameter files of a databaseFDisplays the current contents of the server parameter file.
多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）AOn startup， SMON coordinates instance recovery.BOn startup， CKPT coordinates instance recovery.COn startup， use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup， perform media recovery and then instance recovery.FOn startup， all the files will be synchronized and you get both committed and uncommitted data.
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）AThe modified blocks would be written to the data files.BThe modified blocks would be written to the temp files.CThe modified blocks would be written to the control file.DThe modified blocks would be written to the redo log files.EThe modified blocks would be written to the archived redo log files.FThe modified blocks would be retained in the database buffer cache.