Question

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

Posted under Data Connectivity SQL Server

Answer: (c).sqlConn.Open() and sqlConn.Close()

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Syntax for closing and opening the connection in ADO.net is _______________

Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following gives trusted Connection from a CE device?

View solution

Q. The main features of dotConnect for SQL Server includes ___________

View solution

Q. __________object is used to fill a DataSet/DataTable with query results in ADO.net.

View solution

Q. Point out the correct statement.

View solution

Q. LINQ query to retrieve a selection of customers, each with their high-value purchases is _____________

View solution

Q. LINQ Query to list all purchases of $1000 or greater made by customers who live in Washington.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following sample code is used to select data Using LinQ To SQL?

View solution

Q. Which of the following code snippet would traverse through all result objects ?

View solution

Q. LINQ to SQL is considered to be one of Microsoft’s _______ products.

View solution

Q. LINQ to SQL in SQL Server fully supports ____________

View solution

Q. Point out the wrong statement.

View solution

Q. LINQ to Entities applications requires __________ mapping provider.

View solution

Q. The ______ pre-compiler translates embedded SQL into calls to the Oracle runtime library.

View solution

Q. Point out the correct statement.

View solution

Q. DataContext object is constructed in LINQ to SQL using _____________

View solution

Q. Which of the following code will retrieve all products in the Beverages category sorted by product name?

View solution

Q. Which of the following sample code is used to retrieve single row at a time?

View solution

Q. Which of the following method is used to delete records in LINQ?

View solution

Q. Which of the following code in LINQ performs functionality similar to joins in SQL?

View solution

View All MCQs on Data Connectivity

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Compiler Design

Unravel the process of translating source code into executable programs with our...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...