Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （　） functions against a VARCHAR (10000) column quite often. An example of the start of

第1题：

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）

• A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
• E、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

第2题：

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.

第3题：

You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）  

• A、 Flashback Table
• B、 Flashback Query
• C、Flashback Version Query
• D、 Flashback Transaction Query

第4题：

You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

• A、After the query. 
• B、Enter the report and change the column's position in the field tab. 
• C、Alter the column's position in the object navigator. 
• D、Enter the report wizard and change the column's position in the data tab. 
• E、Alter the column's position within its group and change the layout. 

第5题：

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

• A、 Index cluster
• B、 Hash cluster
• C、 Sorted Hash cluster
• D、 Real Application Cluster

第6题：

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）

• A、Mysqlaccess
• B、Mysqldump
• C、Mysqlshow
• D、Mysqlslow
• E、Mysqldumpslow

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

Which two are true about aggregate functions? （）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第15题：

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

• A、Upgrade the hardware/memory to accommodate the data.
• B、Load the data into your database by using the PARALLEL clause.
• C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
• D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

第16题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第17题：

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

• A、 You must configure OMF in your database.
• B、 You must enable block change tracking feature in your database.
• C、 You must enable ROW MOVEMENT feature on the ORDERS table.
• D、 You must use the Flashback Version Query before using the Flashback Table feature.

第18题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized.  Which action should be performed to finish the task？（）

• A、A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
• B、A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.
• C、On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.
• D、A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.

第19题：

第20题：

第21题：

第22题：

第23题：