Become a GOLD Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. Managed Provider provides a simplified data access architecture that often results in improved performance without the loss of functional capabilities.
b. Managed providers directly expose provider-specific behavior to consumers through methods and properties.
c. Managed providers work within the boundaries of the Common Language Runtime (CLR).
d. All the above.
Reveal Answer
Options:
a. System.Data.SqlClient
b. System.Data.OracleClient
c. System.Data.Oledb
d. System.Data.Odbc
e. All the above
Reveal Answer
Options:
a. System.Data.dll
b. System.Data.SqlClient.dll
c. System.Data.Linq.dll
d. System.Data.Linq.dll
Reveal Answer
Options:
a. System.Data.SqlClient
b. System.Data
c. System.Data.SqlServerCe
d. System
Reveal Answer
Options:
a. Oledb provider is .NET component
b. Oledb is COM component
c. Oledb provider provides standard interface for SQL server only.
d. None
Reveal Answer
Options:
a. Connection String ="server=.\sqlexpress,portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword".
b. Connection String ="server=.\sqlexpress; portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword".
c. Connection String ="server=.\sqlexpress;Database=dbname;Uid=dbuser; Pwd=dbpassword;Port Number=number".
d. Connection String ="server=.\sqlexpress; portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword;Port=Port Number"
Reveal Answer
Options:
a. Databases
b. COM Components
c. RDBMS Products.
d. DCOM Components
Reveal Answer
Options:
a. <add name="Demo" ConnectionString="DataSource=Server;Initial Catalog=pubs;user id=sa;pwd=password"/>
b. <add name= ”Demo” ConnectionString=” server=.\sqlexpress; database=”ADODB“ ;user id=sa ; pwd=password"/>
c. <add name = ”Demo” ConnectionString=” server=.\sqlexpress; database=ADODB ;user id=sa ; pwd=password"/>
d. <add name = ”Demo” ConnectionString=” server=sqlexpress; database=ADODB ;user id=sa ; pwd=password"/>
Reveal Answer
Options:
a. To control objects life time.
b. All The resources are cleaned up deterministically
c. The class which implements IDisposable should be used in the using statement
d. All the above
Reveal Answer
Options:
a. As “DataSet” is connected architecture, has live connection while reading data.
b. “DataSet” carry considerable overhead because of relations; multiple tables etc speed is slower than “DataReader”.
Reveal Answer
Options:
a. It will closes automatically when datareader closes.
b. By using CommandBehavior.CloseConnection enumeration
c. Using Connection.ImmediateClose().
d. Using CommandBehaviour.Connection.Close().
Reveal Answer
Options:
a. SQL wildcards can be used when searching for data in a database
b. SQL wildcards can substitute for one or more characters when searching for data in a database.
c. SQL wildcards must be used with the SQL LIKE operator
d. All the above.
Reveal Answer
Options:
a. Asynchronous ,Connected, Identity ,Disconnected
b. Atomic , Connection, Isolated, Durable.
c. Atomic, Connection, Identity, Disconnected.
d. Atomic, Consistent, Isolated, Durable.
Reveal Answer
Options:
a. The execution plan is cached by the backend.
b. The execution plan cached can be reused for subsequent request.
c. Same execution plan can be reused for different data.
d. All the above
Reveal Answer
Options:
a. DataSource Property and DataBind method
b. DataMember Property and DataBinding method
c. DataSource Property and Dispose method.
d. ItemSource Property and Item Bind Method.
Reveal Answer
Options:
a. Windows Authentication
b. Sql server Authentication
Reveal Answer
Options:
a. Always use Storedprocedures instead of creating SQL commands.
b. Using Parameterized queries
c. By using the controlled input values from user and checking with expected values.
d. All the above.
Reveal Answer
Options:
a. command
b. data object
c. datareader object
d. connection object
Reveal Answer
Options:
a. read only
b. forward-only
c. read-write
d. both read and forward
Reveal Answer
Options:
a. must match
b. can be different
c. Just Data source must be same
d. none of the above
Reveal Answer
Options:
a. MultipleActiveResultSets=False
b. SingleActiveResultSets=True
c. MultipleActiveResultSets=True
d. SingleActiveResultSets=False
Reveal Answer
Options:
a. parameters
b. arguments
c. methods
d. constructors
Reveal Answer
Options:
a. @
b. *
c. ?
d. the name is sufficient
Reveal Answer
Options:
a. takes extra time.
b. efficiency decreases.
c. degrades performance
d. is not to be executed
Reveal Answer
Options:
a. Dependent
b. Independent
c. Can't say
d. Component
Reveal Answer
Options:
a. increased
b. decreased
c. remains same
d. none
Reveal Answer
Options:
a. Reduced
b. Increased
c. Remains same
d. None
Reveal Answer
Options:
a. Data Reader and DataSet
b. XML and Delegates
c. LINQ and XML
d. Dataset and XML.
Reveal Answer
Options:
a. DataSet
b. Data Reader
c. DataAdapter
d. DataGrid
Reveal Answer
Options:
a. Anonymous Data Object
b. Asynchronous Data Objects
c. ActiveX Data Options
d. ActiveX Data Objects
Reveal Answer
Options:
a. SQL Server .Net Data Provider
b. ODBC .net Data Provider
c. OLE DB .NET Data Provider
d. All the above
Reveal Answer
Options:
a. Data Table
b. Data View
c. Data Adapter
d. Data Reader
Reveal Answer
Options:
a. DataColumn & DataCell
b. DataRow & DataField
c. Data field & DataColumn
d. DataRow & DataColumn
Reveal Answer
Options:
a. DataRow
b. DataColumn
c. DataColumnCollection
d. DataRowCollection
Reveal Answer
Options:
a. DataRow
b. DataColumn
c. DataColumnCollection
d. DataRowCollection
Reveal Answer
Options:
a. Execution of statements which do not return any data from backend to front end.
b. Execution of statements which return only one value.
c. Execution of statements which return multiple rows and columns
d. Exection of statements which return only columns.
Reveal Answer
Options:
a. Execution of statements which do not return any data from backend to front end.
b. Execution of statements which return only one value.
c. Execution of statements which return multiple rows and columns
d. None
Reveal Answer
Options:
a. TransactionScope
b. Transaction
c. Using
d. Procedure
Reveal Answer
Options:
a. ArgumentNullException
b. InvalidOperationException
c. DBConcurrencyException
d. NullReferenceException
Reveal Answer
Options:
a. Row State
b. Row Version
c. Row Status
d. All the above
Reveal Answer
Options:
a. Changed
b. Active
c. Updated
d. Deleted
e. All the Above
Reveal Answer
Options:
a. CurrentRow
b. Cascasde
c. Original
d. Prepared
Reveal Answer
Options:
a. To locate a record by Foreign Key
b. To locate a record by Primary Key
c. To locate a record by any column name.
d. To locate a record by Foreign key and Primary key
Reveal Answer
Options:
a. null
b. Nothing
c. “ ”
d. DBNull.Value
Reveal Answer
Options:
a. Memory representation of the database
b. Harddisk
c. In browser
Reveal Answer
Options:
a. SqlConnectionCommand object
b. SqlDataAdapter object
c. SqlCommand object
d. SqlQueryCommand object.
Reveal Answer
Options:
a. Record sets, Client-side Cursors,Dataset
b. DataReader, Client-side Cursors, Server- side Cursors
c. Record sets, Client-side Cursors, Server-side Cursors
d. DataReader, Record sets, Dataset
Reveal Answer
Options:
a. Only Input
b. Only Output
c. Input,Output and InputOutput
d. Only InputOutput
Reveal Answer
Options:
a. Ado.net
b. Dbms
c. Both (a) & (b)
d. None
Reveal Answer
Bestdotnet google plus