Data Table Control
View Control
Repeat Control
Filter by category View Control
第1题:
Which version of a view would you use if you just want a quick, easy view within your XPage?()
第2题:
In which scenario do you use the Flashback Database feature?()
第3题:
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.
第4题:
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?()
第5题:
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
第6题:
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?()
第7题:
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?()
第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?()
第9题:
You are granted the CREATE VIEW privilege. What does this allow you to do?()
第10题:
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()