单选题You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）A a table name which has 100s of recordsB a table name which has 10s of 

第1题：

In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

• A、export and import the mapping table
• B、drop and re­create the mapping table
• C、truncate the mapping table and reinsert the values
• D、use the ALTER TABLE .. REBUILD command to defragment the mapping table

第2题：

You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

• A、BFILE 
• B、REF column 
• C、Object table 
• D、Column object 
• E、INSTEAD-OF trigger

第3题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第4题：

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

• A、— quick
• B、— skip-buffer
• C、— single-transaction
• D、— tab

第5题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement， which option should be included？（）

• A、Sort in tempdb 
• B、Online 
• C、Fill factor 
• D、Pad index 

第6题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（）  

• A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. 
• B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. 
• C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header 
• D、You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

• A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
• B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
• C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
• D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

第14题：

You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

• A、a table name which has 100s of records
• B、a table name which has 10s of records
• C、a table name which has empty records
• D、a table name which has 1000s of records
• E、never use a table name

第15题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第16题：

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

• A、 V$DATABASE
• B、 V$UNDOSTAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$FLASHBACK_DATABASE_STAT

第17题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）

• A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; 
• B、ALTER SCHEMA CostsTRANSFER Service.Table; 
• C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; 
• D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;

第18题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）

• A、You should use row compression 
• B、You should use page compression 
• C、You should use backup compression 
• D、You should use windows NTFS file system compression

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：