MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 49 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
DataContext object is constructed in LINQ to SQL using _____________ |
| A. | NorthwindDataContext db = new malloc NorthwindDataContext(); |
| B. | NorthwindDataContext db = new NorthwindDataContext(); |
| C. | NorthwindDataContext db = new NorthwindData(); |
| D. | None of the mentioned |
| Answer» C. NorthwindDataContext db = new NorthwindData(); | |
| 2. |
__________object is used to fill a DataSet/DataTable with query results in ADO.net. |
| A. | DataReader |
| B. | Dataset |
| C. | DataAdapter |
| D. | DataTables |
| Answer» D. DataTables | |
| 3. |
If SSIS is not able to drive close to 100% CPU load, this may be indicative of ____________ |
| A. | Software Contention |
| B. | Application contention |
| C. | Processor contention |
| D. | None of the mentioned |
| Answer» C. Processor contention | |
| 4. |
The key counters for Integration Services and SQL Server are _______________ |
| A. | Process Bytes |
| B. | Public Bytes |
| C. | Private Set |
| D. | All of the mentioned |
| Answer» B. Public Bytes | |
| 5. |
LINQ query to retrieve a selection of customers, each with their high-value purchases is _____________ |
| A. | FROM c IN db.Customers |
| B. | FROM c IN db.Customers |
| C. | FROM c IN db.Customers |
| D. | All of the mentioned |
| Answer» B. FROM c IN db.Customers | |
| 6. |
Syntax for closing and opening the connection in ADO.net is _______________ |
| A. | sqlConn.Open() and sqlConn.close() |
| B. | sqlConn.open() and sqlConn.Close() |
| C. | sqlConn.Open() and sqlConn.Close() |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 7. |
Which of the following gives trusted Connection from a CE device? |
| A. | connetionString="Data Source=ServerName; |
| B. | connetionString="Data Source=ServerName; |
| C. | connetionString="Data Source=ServerName; |
| D. | All of the mentioned |
| Answer» B. connetionString="Data Source=ServerName; | |
| 8. |
Which of the following code snippet would traverse through all result objects ? |
| A. | foreach(USER USER IN userResults) |
| B. | FOR(USER USER IN userResults) |
| C. | While(USER USER IN userResults) |
| D. | None of the mentioned |
| Answer» B. FOR(USER USER IN userResults) | |
| 9. |
LINQ to SQL in SQL Server fully supports ____________ |
| A. | Transactions |
| B. | Functions |
| C. | Stored Procedures |
| D. | All of the mentioned |
| Answer» E. | |
| 10. |
Which of the following steps should be carried out using data types in SSIS for efficient results? |
| A. | Make data types as wide as possible so you will allocate more memory for your transformation |
| B. | Do not perform excessive casting of data types |
| C. | Do not watch precision issues when using the money, float, and decimal types |
| D. | None of the mentioned |
| Answer» C. Do not watch precision issues when using the money, float, and decimal types | |
| 11. |
Which of the following is the event logged by the Integration Services? |
| A. | SQLISService_255 |
| B. | SQLISService_256 |
| C. | SQLISService_155 |
| D. | SQLISService_156 |
| Answer» C. SQLISService_155 | |
| 12. |
Which of the following change took place in JULY 2014 release of SSMA? |
| A. | Added support of MS SQL Server 2014 |
| B. | Set cascade actions for circular references to No Action |
| C. | Fixed bugs regarding invisible report pages in IE 10 |
| D. | Highlighting of “well known” LOB schemas |
| Answer» E. | |
| 13. |
Purpose of SQLISPackage_12546 event in SQLIS package is to _____________ |
| A. | Indicate that a package started |
| B. | Indicate that a task or other executable in a package has finished its work |
| C. | Indicate that a warning message was raised in a package |
| D. | All of the mentioned |
| Answer» C. Indicate that a warning message was raised in a package | |
| 14. |
Which of the utility is used for reporting the issue in Service Broker? |
| A. | diagnose |
| B. | ssiagnose |
| C. | ssbdiagnose |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 15. |
Which of the following sample code is used to select data Using LinQ To SQL? |
| A. | public bool IsValidUser(string userName, string passWord) |
| B. | public bool IsValidUser(string userName, string passWord) |
| C. | public bool IsValidUser(string userName, string passWord) |
| D. | All of the mentioned |
| Answer» B. public bool IsValidUser(string userName, string passWord) | |
| 16. |
Which of the following SQL syntax elements is dictated by the SQL dialect levels? |
| A. | LIKE support |
| B. | Parameter marker support |
| C. | Nested query support |
| D. | None of the mentioned |
| Answer» E. | |
| 17. |
The main features of dotConnect for SQL Server includes ___________ |
| A. | Extra data binding capabilities |
| B. | Ability of monitoring query execution |
| C. | Supports the latest versions of SQL Server |
| D. | All of the mentioned |
| Answer» E. | |
| 18. |
Which of the following will increase the Rows/sec calculation in SSIS? |
| A. | Improve drivers and driver configurations |
| B. | Start single connections |
| C. | Use single NIC cards |
| D. | None of the mentioned |
| Answer» B. Start single connections | |
| 19. |
The easiest way to start is to create a linked server ‘localhost’ by using _____________ |
| A. | sp_addlinkedserv ‘localhost’ |
| B. | sp_addlinkedsrvlogin ‘localhost’ |
| C. | sp_addlinkedserverlogin ‘localhost’ |
| D. | sp_addlinkedserver ‘localhost’ |
| Answer» E. | |
| 20. |
Which of the following code will retrieve all products in the Beverages category sorted by product name? |
| A. | Enumerable<Product> beverages = FROM p IN db.Products |
| B. | IEnumerable<Product> beverages = FROM p IN db.Products |
| C. | IEnumerable<Product> beverages = FROM p IN db.Products |
| D. | All of the mentioned |
| Answer» C. IEnumerable<Product> beverages = FROM p IN db.Products | |
| 21. |
Valid Code for Creating a SqlConnection Object would be ____________ |
| A. | SqlConnection conn = NEW SqlConnection( |
| B. | SqlConnect conn = NEW SqlConnection( |
| C. | SqlConnection conn = NEW SqlConnect( |
| D. | All of the mentioned |
| Answer» B. SqlConnect conn = NEW SqlConnection( | |
| 22. |
Which of the following is enumeration for ADO.net with SQL Server? |
| A. | SqlInfo |
| B. | SqlBulkCopyOptions |
| C. | SqlNotification |
| D. | All of the mentioned |
| Answer» C. SqlNotification | |
| 23. |
Replication in SQL Server is used to overcome ________________ |
| A. | Performance problems |
| B. | Availability problems |
| C. | Maintenance problems |
| D. | All of the mentioned |
| Answer» E. | |
| 24. |
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” |
| Answer» B. “Server=local\sqlexpress” | |
| 25. |
Two types of subscriptions present for replication is _____________ |
| A. | push and pull |
| B. | throw and pull |
| C. | push and throw |
| D. | none of the mentioned |
| Answer» B. throw and pull | |
| 26. |
sp_addlinkedserver command creates a distributed server entry called _________ in the following code. |
| A. | Access 97 |
| B. | Microsoft.Jet.OLEDB.3.51 |
| C. | nwind |
| D. | Northwinds |
| Answer» E. | |
| 27. |
Which of the following function mainly used for bulk load data is referenced in the following code? |
| A. | OpenRowset |
| B. | Microsoft.Jet.OLEDB |
| C. | admin |
| D. | All of the mentioned |
| Answer» B. Microsoft.Jet.OLEDB | |
| 28. |
Which of the following function will be preferred for faster execution in following code? |
| A. | OpenRow |
| B. | OpenSQL |
| C. | OpenQuery |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 29. |
Which of the following query combines data from more than one SQL Server instance? |
| A. | USE SCRATCH |
| B. | USE SCRATCH |
| C. | USE SCRATCH |
| D. | None of the mentioned |
| Answer» B. USE SCRATCH | |
| 30. |
Which of the following command tells that all local users are logged in as “sa” in the following code? |
| A. | sp_addlinkedsrv |
| B. | sp_addlinkedserver |
| C. | sp_addlinkedsrvlogin |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 31. |
LINQ Query to list all purchases of $1000 or greater made by customers who live in Washington. |
| A. | FROM p IN db.Purchases |
| B. | FROM p IN db.Purchases |
| C. | FROM p IN db.Purchases |
| D. | None of the mentioned |
| Answer» B. FROM p IN db.Purchases | |
| 32. |
Query alternative to the following SQL code in LINQ is ____________ |
| A. | var query = |
| B. | var query = |
| C. | var query = |
| D. | var query = |
| Answer» B. var query = | |
| 33. |
The following code is used will perform _________ operation in LINQ. |
| A. | update |
| B. | select |
| C. | insert |
| D. | All of the mentioned |
| Answer» C. insert | |
| 34. |
Query alternative to the following LINQ code in SQL is ____________ |
| A. | SELECT p.* |
| B. | SELECT p.* |
| C. | SELECT p.* |
| D. | None of the mentioned |
| Answer» B. SELECT p.* | |
| 35. |
The following Network perfom counters can help you tune your topology? |
| A. | Total Bandwidth |
| B. | Current Bandwidth |
| C. | Bandwidth bound |
| D. | All of the mentioned |
| Answer» C. Bandwidth bound | |
| 36. |
Which of the following sample code is used to retrieve single row at a time? |
| A. | public USER GetUser(string userName) |
| B. | public USER GetUser(string userName) |
| C. | public USER GetUser(string userName) |
| D. | All of the mentioned |
| Answer» B. public USER GetUser(string userName) | |
| 37. |
Which of the following is a Service Broker Related Dynamic Management View? |
| A. | sys.dm_broker_activated |
| B. | sys.dm_broker_activated_tasks |
| C. | sys.dm_broker_tasks |
| D. | dm_broker_activated_tasks |
| Answer» C. sys.dm_broker_tasks | |
| 38. |
What is the syntax for using linked server stored procedure in SQL Server? |
| A. | sp_linkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] |
| B. | sp_addlinked [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] |
| C. | sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] |
| D. | sp_addlinkedser [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] |
| Answer» D. sp_addlinkedser [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] | |
| 39. |
Which of the following is a bulk import operation? |
| A. | BULK INSERT |
| B. | INSERT..SELECT |
| C. | bcp |
| D. | All of the mentioned |
| Answer» E. | |
| 40. |
Under the _______ recovery model, all bulk operations are fully logged. |
| A. | Simple |
| B. | Partial |
| C. | Full |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 41. |
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 mentioned |
| Answer» C. Constraint checking of NULL constraints | |
| 42. |
Which of the following operation cannot be performed in bulk? |
| A. | Copy |
| B. | Insert |
| C. | Import |
| D. | All of the mentioned |
| Answer» E. | |
| 43. |
___________ does not allow bulk export operation in SQL Server. |
| A. | INSERT … SELECT |
| B. | DELETE |
| C. | UPDATE |
| D. | None of the mentioned |
| Answer» B. DELETE | |
| 44. |
________ parameter specifies the number of rows in a batch in bulk insert script. |
| A. | KEEPNULLS |
| B. | KEEPIDENTITY |
| C. | FIRE_TRIGGERS |
| D. | None of the mentioned |
| Answer» E. | |
| 45. |
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 mentioned |
| Answer» C. dcp utility | |
| 46. |
Which is the default field terminator for bulk insert in SQL Server? |
| A. | Comma |
| B. | Full stop |
| C. | Parenthesis |
| D. | Brackets |
| Answer» B. Full stop | |
| 47. |
___________ represents how many network transfers per second are occurring. |
| A. | Network Bytes |
| B. | Network Transfers |
| C. | Memory reads |
| D. | None of the mentioned |
| Answer» C. Memory reads | |
| 48. |
Which of the following code in LINQ performs functionality similar to joins in SQL ? |
| A. | var categoryProducts = FROM c IN db.Categories SELECT NEW {c.CategoryName, productCount = products.Count()}</ |
| B. | var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO products SELECT NEW |
| C. | var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO productsforeach (var cp IN cate |
| D. | None of the mentioned |
| Answer» C. var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO productsforeach (var cp IN cate | |
| 49. |
_________ shows information about Access databases that have been added to the project. |
| A. | SQL Server Metadata Explorer |
| B. | Access Metadata Explorer |
| C. | Access Metadata Expl |
| D. | None of the mentioned |
| Answer» C. Access Metadata Expl | |