A direct-load insert can be invoked by suing the APPEND hint.
Inserting using the NOLOGGING option is the default for direct-load inserts.
All data loaded using direct-load insert is loaded below the high-water mark.
An object that is modifies using parallel direct-load can be queried within the same Transaction.
第1题:
SQL命令中用于插入数据的命令是 A)INSERT B)APPEND C)INSERT BEFORE D)INSERT INTO
第2题:
Which of the following can be used to insert a new line below the current line inside a vi session?()
第3题:
You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:
BULK INSERT finance.dbo.customers
FROM ‘di\bulk\accts143_10141000.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You want to ensure that response times do not slow when new account information is added to the database. What should you do?
A.Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
B.Remove the TABLOCK option from the BULK INSERT statement.
C.Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
D.Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
第4题:
Which object privileges can be granted on a view? ()
第5题:
Which two statements are true with regard to policy ordering? ()(Choose two.)
第6题:
SQ L*Loader is a utility that can perform which two tasks?()
第7题:
Which two statements are true regarding rescue configurations?()
第8题:
Exhibit:
BULK INSERT Ezonexam.dbo.employees
FROM ‘tk\africe\fubar512.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.
How should you improve the performance of the query in the exhibit above?
A. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 5 percent of the number of rows to be loaded.
B. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 10 percent of the number of rows to be loaded.
C. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 5 percent of the number of rows to be loaded.
D. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 10 percent of the number of rows to be loaded.
E. Insert a line before the BULK INSERT statement that drops the indexes for the customers table. Insert a line after the BULK INSERT statement that recreates the indexes for the customers table.
F. The TABLOCK option should be removed.
G. The ROWTERMINATOR line should be removed.
第9题:
Which three are true?()
第10题:
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? ()