InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	Code snippet for having a named instance of SQL Server would be ___________(a) “Server=localhost\sqlexpress”(b) “Server=local\sqlexpress”(c) “Server=host\sqlexpress”(d) “Ser=localhost\sqlexpress”I had been asked this question in an interview.This question is from ADO.NET in division Data Connectivity of SQL Server
Answer» Correct OPTION is (a) “SERVER=localhost\sqlexpress” For explanation: An INSTANCE of the SqlConnection CLASS in .NET Framework is supported by the Data Provider for SQL Server Database.

52.	Point out the wrong statement.(a) The goal of dotConnect for SQL Server is to enable developers to maintain database applications(b) dotConnect for SQL Server combines connected and disconnected data access models in single SqlDataTable component(c) dotConnect for SQL Server supports new ADO.NET features and technologies as soon as they are released(d) None of the mentionedI got this question in an online quiz.My question is from ADO.NET topic in division Data Connectivity of SQL Server
Answer» Right option is (a) The goal of DOTCONNECT for SQL SERVER is to enable developers to maintain database applications To elaborate: The goal of dotConnect for SQL Server is to enable developers to write efficient and FLEXIBLE database applications. The dotConnect for SQL Server assemblies are implemented using OPTIMIZED code and ADVANCED data access algorithms.

53.	Which is the default field terminator for bulk insert in SQL Server?(a) Comma(b) Full stop(c) Parenthesis(d) BracketsI got this question in an interview for job.I want to ask this question from Bulk Operations in chapter Data Connectivity of SQL Server
Answer» RIGHT option is (a) Comma Explanation: Field Terminator is used to delimit columns in the source file. There are some cases where I have seen “\|” also. “,” can be part of Name. So in that CASE the BULK INSERT may fail.

54.	________parameter specifies the number of rows in a batch in bulk insert script.(a) KEEPNULLS(b) KEEPIDENTITY(c) FIRE_TRIGGERS(d) None of the mentionedThe question was posed to me during a job interview.I want to ask this question from Bulk Operations topic in section Data Connectivity of SQL Server
Answer» The CORRECT answer is (d) None of the mentioned Best explanation: BATCHSIZE =batch_size specifies the number of ROWS in a batch. Each batch is copied to the SERVER as ONE TRANSACTION.

55.	___________ does not allow bulk export operationin SQL Server.(a) INSERT … SELECT(b) DELETE(c) UPDATE(d) None of the mentionedThe question was asked at a job interview.This interesting question is from Bulk Operations in chapter Data Connectivity of SQL Server
Answer» The correct option is (a) INSERT … SELECT Best explanation: INSERT … SELECT is a Transact-SQL statement that USES the OPENROWSET bulk rowset PROVIDER to bulk import DATA into a SQL Server table by specifying the OPENROWSET(BULK…) function to select data in an INSERT statement.

56.	Which of the following performance considerations are regarding bulk operations?(a) Column locking(b) Batch switches(c) Constraint checking of NULL constraints(d) All of the mentionedThe question was asked during an internship interview.I'd like to ask this question from Bulk Operations in section Data Connectivity of SQL Server
Answer» RIGHT OPTION is (b) Batch switches The explanation is: Performance considerations can ALSO be significant when large amounts of DATA are being imported.

57.	Which of the following utility supports bulk exports and bulk imports data and generates format files?(a) icp utility(b) bcp utility(c) dcp utility(d) all of the mentionedI have been asked this question during a job interview.I need to ask this question from Bulk Operations in division Data Connectivity of SQL Server
Answer» Right option is (B) BCP utility The best explanation: bcp is a COMMAND line utility for bulk import and export.

58.	Point out the wrong statement.(a) In Bulk-logged recovery model, few transactions are completely logged(b) 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(c) Backups under BULK_LOGGED recovery model will include log records and the data pages changed by bulk operations(d) None of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.This question is from Bulk Operations topic in portion Data Connectivity of SQL Server
Answer» The CORRECT choice is (a) In BULK-LOGGED recovery model, few transactions are COMPLETELY logged The best explanation: In Bulk-logged recovery model, all most all the transaction are completely logged EXCEPT Bulk operation.

59.	Which of the following is a bulk import operation?(a) BULK INSERT(b) INSERT..SELECT(c) bcp(d) All of the mentionedThis question was posed to me during an online interview.This interesting question is from Bulk Operations in chapter Data Connectivity of SQL Server
Answer» The correct CHOICE is (d) All of the mentioned The best explanation: SQL Server bulk-import operations do not SUPPORT IMPORTING data from comma-separated value (CSV) files.

60.	Under the _______ recovery model, all bulk operations are fully logged.(a) Simple(b) Partial(c) Full(d) All of the mentionedI have been asked this question in an interview for internship.My query is from Bulk Operations in division Data Connectivity of SQL Server
Answer» The correct answer is (c) Full For explanation: You can minimize logging for a set of BULK operations by SWITCHING the database to the bulk-logged recovery MODEL TEMPORARILY for bulk operations.

61.	Point out the correct statement.(a) Bulk Copy is mainly used to transfer the data from outside world to SQL Server(b) Bulk Insert is mainly used to transfer the data from outside world to SQL Server(c) Bulk Import is mainly to transfer the data from outside world to SYBASE(d) None of the mentionedI got this question in an interview.The question is from Bulk Operations in portion Data Connectivity of SQL Server
Answer» RIGHT choice is (b) Bulk Insert is mainly used to TRANSFER the data from outside world to SQL Server The EXPLANATION: The bulk insert COMMAND can be used within T-SQL script or in a STORED procedure to import data into SQL Server.

62.	Which of the following operation cannot be performed in bulk?(a) Copy(b) Insert(c) Import(d) All of the mentionedThe question was posed to me by my school teacher while I was bunking the class.The origin of the question is Bulk Operations in division Data Connectivity of SQL Server
Answer» Right answer is (d) All of the mentioned The best EXPLANATION: SQL Server SUPPORTS BULK EXPORTING data from a SQL Server table and for bulk importing data into a SQL Server table or non partitioned VIEW.