Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control

第1题：

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

• A、MERGE
• B、SELECT …CROSS JOIN
• C、INSERT ALL …SELECT
• D、CREATE VIEW …CONSTRAINT

第2题：

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

• A、enable index monitoring and query the DBA_OBJECTS view
• B、enable index monitoring and query the DBA_INDEXES view
• C、enable index monitoring and query the V$OBJECT_USAGE view
• D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

第3题：

第4题：

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

• A、Create a table view.
• B、Create a view in any schema.
• C、Create a view in your schema.
• D、Create a sequence view in any schema.
• E、Create a view that is accessible by everyone.
• F、Create a view only of it is based on tables that you created.

第5题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command on the EMP_DEPT_VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第6题：

In which scenario do you use the Flashback Database feature？（）

• A、 when a table is dropped and you restore it from the Recycle Bin
• B、 when a user’s schema is dropped and you recover the user’s schema
• C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
• D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

第7题：

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package

第8题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第9题：

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

• A、 To recover a dropped table.
• B、 To recover a dropped schema.
• C、 To recover data from a truncated table.
• D、 To view changes made by all the transactions during a given period of time.
• E、 To view changes made by a single transaction during a given period of time.

第10题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

• A、 Query the V$FLASHBACK_DATABASE_LOG view.
• B、 Query the V$FLASHBACK_DATABASE_STAT view.
• C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• D、 Query the V$RECOVERY_FILE_DEST view.