Test Number:6-Topic Name: ADO.NET

.Net Framework and C# Basics - Test No : 01   Test Number:2 Topics :Assembly, Event, Delegates_exceptions  Test No : 03 - Collections ,Generics , System.IO, Serialisation ,WinForms Test 04 - Reflection, Custom Attributes, Threading, Windows Service

Test No : 05 -Remoting ,Webservices

Topic Name: ADO.NET _______ is namespace for  the SQL Server provider classes. a) Sysytem.Data.Oracle b)  System.Data.SqlClient c) System.Data.Sql d) System.Data.Odbc _________ contains SQL Server data types. a)System.Data.SqlserverTypes b) System.Data.Oralce.Types c) System.Data.OdbcTypes d)System.Data.SqlTypes ______ Used as wrappers for SQL statements or stored procedure calls. a)SqlCommand b)OracleCommand c)OleDbCommand and ODBCCommand d) All the above A syntax for connection string a)"Server;datbasename=;uid=id;pwd=pwd" b)“Server=servername;database=dbName;uid=id;pwd=pwd” c)"add name=con1 ;databasename=db1 ;connectionstring=con1;uid=id;pwd=pwd" d) None of the above Can we directly assign a datareader to a gridview a)Yes b)No d) None of above ________is describes the database instance to connect to; each SQL Server process can  expose several database instances a) integrated security = SSPI b) server=(local) c) None of above d) database=Northwind( Any database name)  ______________is Executes the command but does not return any output a) ExecuteNonQuery() b) ExecuteScalar() c) ExecuteReader() d) None of above ____________is Executes the command and returns a typed IDataReader a) ExecuteNonQuery() b) ExecuteReader() c) ExecuteScalar d)None of above ______________is Executes the command and returns a single value a) ExecuteNonQuery() b) ExecuteReader() c) ExecuteScalar() d) None of above ____________is  Executes the command and returns an XmlReader object, which can be used to traverse the XML fragment returned from the database a) ExecuteNonQuery() b) Executescalar() c) ExecuteXmlReader() d) None of above Can we get a XML presentation of a table from Dataset? a)Yes b)NO ____________class consists of a set of data tables, each of which will have a set of data columns and data rows a) Data Adapter b) DataTable c)  DataSet d) DataRow Data adapter includes _______________command objects a) Select command b) insert command c) update command, delete command d) All of above A ___________is very similar to a physical database table — it consists of a set of columns with particular  properties, and might have zero or more rows of data a)  dataset b) data table c) datacoloumn d) All of above  ________,______________,_____________ and ________________.Used to generate SQL  commands (such as INSERT, UPDATE, and DELETE statements) from a SELECT statement a) SqlCommandBuilder b) OleDbCommandBuilder,   ODBCCommandBuilder c) OracleCommandBuilder d) All of above   where we should  write a connection string a) in web.config b)in App.config file c) Machine Config d)all of the above If we use a DataAdapter, we don’t need to open or close database connection explicitly. a)Yes b)No _________________,________________,__________,________________  Used as a forward only,  connected data reader a) OleDbDataReader b) OracleDataReader c) SqlDataReader d)  All of the above  Which method is used to return the database table in XML format? a)Serialization format b) Binary format c)ReadXML d)Soap Format What object is used to generate the commands automatically for a specific SqlDataAdapter? a) sqlConnection b) sqlCommandBulider c) dataset d) sqlDataReader Which method  of DataTable can copy all the content from DataReader to DataTable.? a)Copy b)Load c)Unload d)all of the above __________ object is designed for disconnected use and can contain a set of DataTables  and include relationships between these tables a) Data Adapter b) system.Data c) Constraint d) DataSet  ___________a container of data that consists of one or more DataColumns and, when populated, will have one or more DataRows containing data a) DataSet b) DataTable c) Datacoloumn d) DataRow ____________class which represent a number of values, akin to a row from a database table,  or a row from a spreadsheet a) DataRow b) DataColoumn c) DataAdapter d) DataTable ______________ object contains the definition of a column, such as the name and data type. a) DataColoumnMapping b) DataColumn c) DataTable d) DataSet  _______________a link between two DataTable classes within a DataSet class. Used for foreign  key and master/detail relationships a) DataAdapter b) DataSet c) Constraint d) DataRelation _______________class defines a rule for a DataColumn class (or set of data columns), such as unique values a) DataRow b) Constraint c) DataTable d) DataSet  __________________Maps the name of a column from the database with the name of a  column within a DataTable. a) DataTableMapping b) DataColumnMapping c) Constraint d) DataAdapter ______________________ Maps a table name from the database to a DataTable within a DataSet a) DataColoumnMapping b) DataTableMapping c) DataSet d) DataRow Namespaces expose the ____________________  used in OLE DB .NET data access. a) Sqlprovider classes b) Oracleprovider classes c) ODBCprovider classes d)  OLE DB provider classes ________________denotes the database server to connect to. SQL Server permits a number  of separate database server instances to be running on the same machine, and here you're connecting to the default SQL Server instance a) database=Northwind (lets say) b) integrated security=SSPI  c) server=(local) d) None of above ________________ uses Windows Authentication to connect to the database, which is highly recommended over using a username and password within the source code a) database=Northwind (lets say) b) integrated security=SSPI  c) server=(local) d) None of above    Which namespace contains following classes: DataSet, DataTable, DataColumn, and DataRow? a)System.Data.SqlserverTypes b)System.data.sqlclient c) system.data d)system.configuration Which object can point to the parameter in stored procedure? a) parametirsed b)AddParameter c)ConnectionParameter d)Parameter __________ method executes the command and returns a typed data reader object, depending  on the provider in use a) ExecuteNonQuery() b) ExecuteXmlReader() c) ExecuteReader() d) None of Above ______________method is commonly used for UPDATE, INSERT, or DELETE statements, where the only returned value is the number of records affected a) ExecuteNonQuery() b) ExecuteScalar() c) ExecuteReader() d) None of Above In many times, it is necessary to return a single result from a SQL statement, such as the count  of records in a given table than _________ method is used a) ExecuteNonQuery() b) ExecuteScalar() c) ExecuteReader() d) None of Above A ___________ is the simplest and fastest way of selecting some data from a data source,  but also the least capable a) Datarecorder b) Datareader c) XMLReader d) All the above The_______________has been designed as an offline container of data. It has no notion of  database connections a)  DataSet class b) DataAdapter c) DataTable d) All of above A ___________ consists of a set of data tables, each of which will have a set of data columns  and data rows a)  DataSet class b) DataAdapter c) DataTable d) All of above ________________property of  DataColumnObject  is true, permits the column to be set to DBNull a) AllowNull b) AllowDBNull c) Null d) None of above ________________ property of DataColumnObject  defines that this column value is automatically generated as an incre- menting number a) AllowIncrement b) AutoIncrement c) Increment d) All of above ________________property of DataColumnObject  defines the initial seed value for an AutoIncrement column a) None of below b)  AllowIncrement c) IncrementSeed d) AutoIncrementSeed ________________property of  DataColumnObject   defines the step between automatically generated  column values, with a default of one a) AllowIncrement b) AutoIncrement c) AutoIncrementSeed d) AutoIncrementStep ________________ property of DataColumnObject can be used for displaying the name of the  column on screen. a) ColumnName b) ColumnMapping c) Caption d) All of above ________________property of DataColumnObject can define a default value for a column a) DefaultValue b) DataType c) Current d) Default Can we add one SQL Server table and another Oracle table inside a single DataSet? a)Yes b)NO _____________________is datarowstate which indicates that the row has not been changed  since the last call to AcceptChanges(). a) Original b) Modified c) Expression d) Proposed _____________________ is datarowstate which  indicates that the row has not been changed since the last call to AcceptChanges(). a) Added b) Deleted c) Depatched d) Unchanged _____________________ is datarowstate state which indicates that the row has been newly added to a DataTable's Rows collection a) Added b) Deleted c) Depatched d) Unchanged ________________returns an integer representing how many table rows were affected by the query a) ExecuteNonQuery() b) ExecuteScalar() c) ExecuteReader() d) None of Above __________- these are the extreamly useful controls to output the data on the web pages a) All of below b) Repeater c) DetailsView, FormView d) GridView, DataList All data-bindable controls support  the top- level  ________________ method. a) Eval() b) Bind() c) DataBind() d) All of above Changes made to the DataSet need to save on Server, which method helps to do this? a)Updation b)Update c)Updatemethod() d)update() The _____________ expression is identical but allows to insert data into attributes of server controls a) Eval() b) Bind() c) DataBind() d) All of above Which is a set of operations that must either succeed or fail as a unit? a)Triggers b)Sql query c) Transaction d)function What are the 2 methods of DataAdapter, when the connection is open? a)open connection b)fill,update c)fill,open d)sql connection.open If we are specifying windows authentication in connection string what element we should add? a)pool=false; b)intial integrated=db1; c)IntegratedSecurity= true d)None of the above Which class can be used to implement relationship on client side? a)Dataset b)DataRelation c)DataAdpter d)DataReader Which object is used to point location of database?  a) ConnectionSQlstring b)ConnectionString c)ConnectionParameter d)Connection