1) Which of the following script is an example of Quick detection in SQL injection attack?
SELECT loginame FROM master..sysprocesses WHERE spid = @@SPID![]()
For integer inputs : convert(int,@@version)![]()
IF condition true-part ELSE false-part (S)![]()
SELECT header, txt FROM news UNION ALL SELECT name, pass FROM members![]()
Answer : B Discuss
2) _____________ is time based SQL injection attack.
3) Which of the following operation cannot be performed in bulk ?
4) Under the _______ recovery model, all bulk operations are fully logged
5) Which of the following is a bulk import operation ?
6) Which of the following utility supports bulk exports and bulk imports data and generates format files ?
7) _________ does not allow bulk export operation in SQL Server.
8) Which of the following performance considerations are regarding bulk operations ?
Column locking![]()
Batch switches![]()
onstraint checking of NULL constraints![]()
All of the mentioned![]()
Answer : B Discuss
9) _______ parameter specifies the number of rows in a batch in bulk insert script.
10) Which is default field terminator for bulk insert in SQL Server ?