gs gs116 Data Connectivity - ADO.NET - 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: To use the .NET Framework Data Provider for SQL Server, an application must reference the _____________ namespace.
System.Data.Client
System.Data.SqlClient
System.Data.Sql
None of the mentioned
Question 2: Point out the correct statement.
Using the System.Data.SqlClient, you can fill a memory-resident DataSet that you can use to query and update the database
System.Data.SqlClient includes a tabular data stream (TDS) parser to communicate directly with SQL Server
SqlBulkCopyColumnMapping lets you efficiently bulk load a SQL Server table with data from another source
None of the mentioned
Question 3: Valid Code for Creating a SqlConnection Object would be ____________
SqlConnection conn = new SqlConnection( "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI"); SqlConnect conn = new SqlConnection( "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI"); SqlConnection conn = new SqlConnect( "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI");
All of the mentioned
Question 4: Code snippet for having a named instance of SQL Server would be ___________
“Server=localhost\sqlexpress”
“Server=local\sqlexpress”
“Server=host\sqlexpress”
“Ser=localhost\sqlexpress”
Question 5: Point out the wrong statement.
The goal of dotConnect for SQL Server is to enable developers to maintain database applications
dotConnect for SQL Server combines connected and disconnected data access models in single SqlDataTable component
dotConnect for SQL Server supports new ADO.NET features and technologies as soon as they are released
None of the mentioned
Question 6: Which of the following is enumeration for ADO.net with SQL Server?
SqlInfo
SqlBulkCopyOptions
SqlNotification
All of the mentioned
Question 7: Syntax for closing and opening the connection in ADO.net is _______________
sqlConn.Open() and sqlConn.close()
sqlConn.open() and sqlConn.Close()
sqlConn.Open() and sqlConn.Close()
none of the mentioned
Question 8: Which of the following gives trusted Connection from a CE device?
connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;Integrated Security=SSPI; User ID=myDomain\UserName;Password=Password; connetionString="Data Source=ServerName; Integrated Security=SSPI;User ID=myDomain\UserName;P assword=Password; connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;User ID=myDomain\UserName; Password=Password;
All of the mentioned
Question 9: The main features of dotConnect for SQL Server includes ___________
Extra data binding capabilities
Ability of monitoring query execution
Supports the latest versions of SQL Server
All of the mentioned
Question 10: __________object is used to fill a DataSet/DataTable with query results in ADO.net.
DataReader
Dataset
DataAdapter
DataTables
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
