网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
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

参考答案

参考解析
解析： 暂无解析
更多 “单选题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­treeB bitmapC reverse keyD 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？（）A The backup is similar to image copy.B The backup contains all used data blocks.C The backup contains only unused data blocks.D The 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？（）A Access path analysis is not performed for the SQL statements.B SQL structure analysis is not performed for the SQL statements.C SQL Profile recommendations are not generated for the SQL statements.D The 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？（）A Displays only the list of default valuesB Displays only the list of all basic parametersC Displays the currently in effect parameter valuesD Displays only the list of all advanced parametersE Displays the list of all the parameter files of a databaseF Displays 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？（）A Restore all the data files and open the databaseB Create the data file and performtablespacerecoveryC No need to restore any file， just recover the databaseD Restore only the system data file and recover the databaseE Restore 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？（）A The modified blocks would be written to the data files.B The modified blocks would be written to the temp files.C The modified blocks would be written to the control file.D The modified blocks would be written to the redo log files.E The modified blocks would be written to the archived redo log files.F The modified blocks would be retained in the database buffer cache.
查看答案
热门标签
最新试卷