Export and import the mapping table.
Drop and re-create the mapping table.
Truncate the mapping table and reinsert the values.
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
第1题:
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task?()
第2题:
While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第3题:
You have created an Oracle 10g database named SALES, which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option?()
第4题:
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?()
第5题:
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 which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?()
第6题:
You obtain the results retrieved from the public synonym HR created by the database administrator.
You obtain the results retrieved from the HR table that belongs to your schema.
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
第7题:
Rebuild the index.
Coalesce the index.
Drop and re-create the index in the new tablespace.
Relocate the index using the ALTER INDEX...MOVE statement.
第8题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第9题:
The clustered index of the Orders table should be dropped.
The clustered index of the Orders table offline should be rebuilt once a month.
The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.
The clustered index of the Orders table should be reorganized by reducing the fill factor.
第10题:
The index can be changed from NOLOGGING to LOGGING
The index cannot be recovered even in the ARCHIVELOG mode.
The index can only be created if the base table is created with the NOLOGGING option.
The index can be recovered if you perform a backup after the CREATE INDEX statement.
第11题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第12题:
On the Products table, you should create a view.
On the RadioSize column, you should create a clustered index
On the RadioSize column, you should create a filtered index
On the RadioSize column, you should create a unique clustered index
第13题:
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;()
第14题:
In your test database, you have created the ORDERS table as an index-organized 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?()
第15题:
In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query?()
第16题:
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?()
第17题:
export and import the mapping table
drop and re-create the mapping table
truncate the mapping table and reinsert the values
use the ALTER TABLE···REBUILD command to defragment the mapping table
第18题:
disabling the index
making the index invisible
making the index unusable
using the MONITORING USAGE clause for the index
第19题:
Export and import the mapping table.
Drop and re-create the mapping table.
Truncate the mapping table and reinsert the values.
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
第20题:
You must configure OMF in your database.
You must enable block change tracking feature in your database.
You must enable ROW MOVEMENT feature on the ORDERS table.
You must use the Flashback Version Query before using the Flashback Table feature.
第21题:
export and import the mapping table
drop and recreate the mapping table
truncate the mapping table and reinsert the values
use the ALTER TABLE .. REBUILD command to defragment the mapping table
第22题:
disabling the index
making the index invisible
making the index unusable
using the MONITORING USAGE clause for the index
第23题:
A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
A new unique index should be created on the CustName column. And then, IGNORE_DUP_KEY = ON should be specified when creating index.
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.
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.
第24题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.