gs gs116 Data Connectivity - SQL Server Bulk Operations - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Connectivity. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following operation cannot be performed in bulk?
Copy
Insert
Import
All of the mentioned
Question 2: Point out the correct statement.
Bulk Copy is mainly used to transfer the data from outside world to SQL Server
Bulk Insert is mainly used to transfer the data from outside world to SQL Server
Bulk Import is mainly to transfer the data from outside world to SYBASE
None of the mentioned
Question 3: Under the _______ recovery model, all bulk operations are fully logged.
Simple
Partial
Full
All of the mentioned
Question 4: Which of the following is a bulk import operation?
BULK INSERT
INSERT..SELECT
bcp
All of the mentioned
Question 5: Point out the wrong statement.
In Bulk-logged recovery model, few transactions are completely logged
The operations that are minimally logged in this recovery model are bulk insert, create index, “bcp” commands, insertion of text , image column and select into query
Backups under BULK_LOGGED recovery model will include log records and the data pages changed by bulk operations
None of the mentioned
Question 6: Which of the following utility supports bulk exports and bulk imports data and generates format files?
icp utility
bcp utility
dcp utility
all of the mentioned
Question 7: ___________ does not allow bulk export operation in SQL Server.
INSERT … SELECT
DELETE
UPDATE
None of the mentioned
Question 8: Which of the following performance considerations are regarding bulk operations?
Column locking
Batch switches
Constraint checking of NULL constraints
All of the mentioned
Question 9: ________ parameter specifies the number of rows in a batch in bulk insert script.
KEEPNULLS
KEEPIDENTITY
FIRE_TRIGGERS
None of the mentioned
Question 10: Which is the default field terminator for bulk insert in SQL Server?
Comma
Full stop
Parenthesis
Brackets
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
