Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations
第1题:
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations
第2题:
SQ L*Loader is a utility that can perform which two tasks?()
第3题:
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations
第4题:
Which two prerequisites are needed for performing workload capture and replay?()
第5题:
Which client requests to the database can be captured as a part of the workload capture?()
第6题:
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.
You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)
A.Apply a bulk update lock to the table.
B.Use separate client connections to load the files into the table simultaneously.
C.Create a clustered index on the table.
D.Specify the Full Recovery model for the database.
E.Specify the Bulk-Logged Recovery model for the database.
第7题:
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()
第8题:
A. flashback query
B. distributed transactions
C. logging in and logging out of sessions
D. all DDL statements having bind variables
E. direct path load of data from external files
第9题:
In a Database Replay workload capture, what client request information is gathered?()
第10题:
In which two scenarios do you use SQL* Loader to load data?()