Which part of the connection string specifies the database name?

A. Data Source
B. Initial Catalog
C. Integrated Security
D. User ID

Which method is used to open a database connection?

A. Connect()
B. Start()
C. Open()
D. Begin()

Which object is responsible for executing SQL queries in ADO.NET?

A. SqlConnection
B. SqlCommand
C. SqlDataAdapter
D. SqlDataReader

Which method is most suitable for executing an INSERT, UPDATE, or DELETE statement?

A. ExecuteReader()
B. ExecuteScalar()
C. ExecuteNonQuery()
D. ExecuteTable()

What happens if SqlConnection.Open() is called when the connection is already open?

A. Connection reopens without issue
B. Compile-time error
C. InvalidOperationException
D. Connection is closed automatically

Which sequence correctly represents the query execution process in ADO.NET?

A. SqlCommand → SqlConnection → Execute
B. SqlConnection → SqlCommand → Execute
C. Execute → SqlCommand → SqlConnection
D. SqlDataReader → SqlCommand → SqlConnection

Which scenario is MOST appropriate for using ExecuteReader()?

A. Retrieving a single aggregate value
B. Executing a DELETE statement
C. Reading multiple rows from a SELECT query
D. Executing stored procedures without output

In an ADO.NET program, where should SqlConnection.Close() be placed to ensure the connection is closed even if an exception occurs?

A. Inside try block
B. Inside catch block
C. Inside finally block
D. Outside exception handling

SqlConnection con = new SqlConnection(connStr);

// Missing line

SqlCommand cmd = new SqlCommand("SELECT * FROM Student", con);

A. con.Open();

B. con.Start();

C. con.Connect();

D. con.Begin();

SqlCommand cmd = new SqlCommand(

"INSERT INTO Student VALUES(1,'Arun')", con);

// Missing line

A. cmd.ExecuteReader();

B. cmd.ExecuteScalar();

C. cmd.ExecuteNonQuery();

D. cmd.Execute();

string connStr =

"Data Source=.;_____ = StudentDB;Integrated Security=True";

A. Database

B. Initial Catalog

C. Catalog

D. DBName

SqlCommand cmd = new SqlCommand(

"SELECT * FROM Student", con);

// Missing line

A. cmd.ExecuteNonQuery();

B. SqlDataReader dr = cmd.ExecuteReader();

C. int x = cmd.ExecuteScalar();

D. cmd.Run();

SqlConnection con = new SqlConnection(connStr);

SqlCommand cmd = new SqlCommand(

"INSERT INTO Student VALUES(1,'A')", con);

cmd.ExecuteNonQuery();

What is the issue?

A. SqlCommand missing

B. ExecuteNonQuery() invalid

C. Wrong SQL syntax

D. Connection not opened

SqlCommand cmd = new SqlCommand(

"INSERT INTO Student VALUES(1,'A')", con);

int x = (int)cmd.ExecuteScalar();

What is wrong?

A. SQL syntax error

B. ExecuteScalar used for INSERT

C. Connection not opened

D. Casting error