What are the Command object property settings to execute a stored procedure?1. CommandType = Text, CommandText = stored procedure name2. CommandType= Text, CommandText = SQL syntax to execute the storedprocedure3. CommandType = StoredProcedure, CommandText = SQL syntax to execute thestored procedure4. CommandType = StoredProcedure, CommandText = stored procedure name

What are the Command object property settings to execute a stored proc

1.	What are the Command object property settings to execute a stored procedure?1. CommandType = Text, CommandText = stored procedure name2. CommandType= Text, CommandText = SQL syntax to execute the storedprocedure3. CommandType = StoredProcedure, CommandText = SQL syntax to execute thestored procedure4. CommandType = StoredProcedure, CommandText = stored procedure name
A.	1, 2
B.	1, 2, 3
C.	2, 4
D.	1, 4
Answer» D. 1, 4

Discussion

No Comment Found

Related MCQs

The three statements are given below about DataSet and DataReader, choose the correct option according to the statement.Statement 1: DataSet Provides Disconnected environment but DataReader provides Connected environment. Statement 2: DataSet Provides Connected environment but DataReader provides Disconnected environment. Statement 3: DataSet Can store multiple table simultaneously but DataReader Supports a single table based on a single SQL query.
What determines the connection pool that a connection should use? 1. A connection string2. The identity or credentials of the user opening the connection3. The database being connected to4. The connection object used to connect to the database
OleDbConnectionobject works with?1. When connecting to an Oracle database2. When connecting to an Office Access database3. When connecting to SQL Server 6.x or later4. When connecting to SQL Server 2000
What is the minimal information needed by a connection string to open a connection to a SQL Server 2000 or SQL Server 2005 database? 1. A valid data source2. A valid provider name3. A valid file path4. Appropriate credentials or Integrated Security settings
What are the recommended techniques for enabling connection pooling on for a SQL Server 2000 or SQL Server 2005 database? 1. Setting the OLE DB Services connection string keyword to -42. Opening a connection and not explicitly disabling pooling3. Setting the connection string keyword Pooling = True in the connection string4. Using the Connection Pooling tab of the ODBC Data Source Administrator dialogBox
What are the minimum attribute is required to create a connection string using SqlConnection object?
What happens when you call the Close method of a connection object? 1. The connection is destroyed.2. The connection is returned to the connection pool.3. The StateChangeevent is fired.4. All non - committed pending transactions are rolled back.
How will you create the SQL Server Connection Objects in Code? Choose the correct option.
When would you typically use an Input parameter? 1. When the parameter value is created based on user input2. When the parameter is used to send data from the application to the database3. When the command is set to execute a statement with a WHERE clause4. When the parameter value is passed to an INSERT statement
What should you do to access the returned tabular data after starting execution of a command that runs asynchronously? (Choose all that apply.)1. Call the EndExecuteNonQuerymethod.2. Call the EndExecuteReadermethod.3. Wait for the StatementCompletedevent to fire and iterate through the DataReader.4. Wait for the StatementCompletedevent to fire, call the EndExecuteReadermethod, and then iterate through the DataReader.

Discussion

No Comment Found

Related MCQs

Reply to Comment