ADO极限考试复习,有答案.doc

1.Which property of SqlConnection class provides information, such as data source, database name, user name, and password that is used to establish connection with a database?A. Connection B.Open C.Close D. ConnestionString2.Which of the following components of data provides retrieves data from a database into a dataset and updates the database?A. Connectiong B. Command C.DataAdapterD.DataReader3.Which of the following components of a data provider is used to retrieve, insert, delete, or modify data in a data source?A. DataAdapter B. Connection C. Command D.DataReader 4.Consider the following statements:Statement A: The Connection timeout parameter of connection pooling is used to mention the minimum number of connections maintained in the pool.Statement B: Max pool size is used to mention the maximum number of connections allowed in the pool.Which of the following statements is true regarding the above statements?A.A is false , B is true B.Both A and B are false C. A is true, B is false D.Both A and B are true5.Which of the following parameters of ConnectionString is used to specify the name of the database？A.Provider B.Initial Catalog C.Data Source D.Database6.Which of the following controls is used to perform simple data binding:A.DataGridView B.List Box C.Label D.Combo Box7.Which control of the BindingNavigator returns the current position within the data source?A. bindingNavigarotPositionItem text box B. bindingNavigarotMoveFirstItem buttonC. bindingNavigatorMoveLastItem button D. bindingNavigatorCountItem text box8.Which property of DataView is used to specify an expression/condition in a string format used to filter the records A. RowStateFilter B.Filter C.RowFilter D.RowFilterExpression9.Which property of the DataView control specifies the versions of data returned by a DataView?A.Table B.AllowEdit C.RowStateFilter D.GenerateMembers10.Which of the following controls is used to perform simple data binding?A.TextBox B.DataGridView C.ListBox D.ComboBox11.To pass a parameter object in a DataSet, Which of the following object is used?A.SqlDataReader B.SqlParameter C. SqlConnectiuon D.SqlCommand12.The Modifiers property of the DataView control specifies:A. The version of data returned by a DataView objectB. An expression/condition in a string format to filter the recordsC. The visibility level of the DataView objectD. An expression on the basis of which the records will be sorted13.What is the purpose of ApplyDefaultSort property of the DataView control?A. To specify if a member variable will be generated for the controlB. To specify the DataTable to which the data view would refer toC. To specify the default sortD. To specify an expression on the basis of which the records will be sorted14.Which method of the DbCommand object executes a DML statement against a connection and returns the number of rows affected?A.ExecuteReader B.CreateObjRef C.ExecuteNonQuery D.ExecuteScalar15.Which method of the DataRow object accesses a row in a table by its primay key value?A.Find B.SelectC.InsertAtD.Add16.Which property of the DataView object returns a subset of rows on the basis of the column values?A.FindRowsB.RowFilterC.RowStateFilterD.Find17.Which of the following is an advantage of connected environment in ADO.NET?A. Users can easily access the data source any time as there si no network traffic logging.B. Applications are easily scalable and there are no performance issues.C. Data concurrency issues are easy to controlD. Muliple applications can simultaneously interact with the data source with ease. 18.Which of the following statements about the typed dataset are correct?A.A typed dataset is not associated with an XML schema.B.The structure of a typed dataset is not known during compilationC.In a typed dataset,the dataset is saved as an XSLT file.D.A typed dataset has an associated XML schema, which is created at the time of creation of a dataset 19.Which property of the DataView object automatically creates a sorting order, on the basis of the primary key column or any other column(s) of the datatabel?A. ApplyDefualtSortB. DefaultSortC. SortD. ApplySort 20.Which of the following methods of DbDataReader object retrieves and moves the reader to the next record in a result set?A.Equals B.IsDBNullC.ToStringD.Reader21.The BeginExecuteNonQuery method of the SqlCommand classA. Starts the process of asynchronously executing a Transact-SQK statement or stored procedure that return rowsB. Starts the process of asynchronously executing a Transact-SQK statement or stored procedure that does not return rows C. Returns the result as an XMLReader objectD. Returns the requested SqlDataReader objet22.To populate a dataset ds with records from the Sales table, the following code snippet is exectutedA. da.Update(ds,”Sales”)B. cmd.CommandTExt-“insert * from Sales”C. da.Fill(ds,”Sales”)D. cmd.CommandText=”select * from Sales” 23.In which of the following, a conflict resolution screen is used for resolving the data concurrency conflicts?A. Prioritized on timeB. Prioritized on locationC. Prioritized on roleD. User resolves the conflict 24.Which property of the SqlBulkCopy class set the name of the targer table?A. DestinationTableNameB. DestinationNameC. TargerTableNameD. TargetName25.Which of the following statemente enables Service Broker for a database named AdventureWorks?A. ALERT DATABASE AdventureWorks SET ENABLE_SERVICEBROKERB. ALERT DATABASE AdventureWorks SET_ENABLE_BROKERC. ALERT DATABASE AdventureWorks ENABLE ENABLE_ BROKERD. ALERT DATABASE AdventureWorks SET ENABLE_BROKER26.Which of the following code snippets will allow a user to have full access to a data source?A. SqlPermission permission = new SqlPermission(PermissionState.Unrestricted)B. SqlPermission permission = new SqlPermission(Unrestricted)C. SqlClientPermission permission = new SqlClientPermission(Unrestricted)D. SqlClientPermission permission = new SqlClientPermission(PermissionState .Unrestricted)27.Which method is called when a transaction succeeds in its operation?A.RollbackB.CommitC.BeginTransactionD.ExecuteNonQuery28.Which method is invoked to commit the distributed transactionA.CommitB.BeginTransactionC.CompleteD.Rollback29.Which isolation level supports the occurrence of dirty read, nonrepeatable read, and phantom read?A.Read committed with Locks B.SerializableC.Read committed with snapshotsD.Read uncommitted30.Which property enables a committed transaction to recover from system failtures or power failuresA.ConsistencyB.AtomicityC.DurabilityD.Isolation31.Which method creates and returns an instance of a class that implements the IdbTransaction interface?A.CommitB.RollbackC.CompleteD.BeginTransaction32.Which code snippet assigns a transaction to a database connection?A. using(SqlTransactionScope ts = new SqlTransactionScope()B. using(SqlConnection con = new SqlConnection()C. using(SqlCommand com = new SqlCommand ()D. using(TransactionScope ts = new TransactionScope()33.Dirty read:A. Allows a transaction to read data that has not been committedB. Allows a transaction to read data that has been committedC. Allows a transaction to read the same row more than once and a different transaction modifies the row between readsD. Allows a transaction to read a rowset more than once and a different transaction inserts or deletes rows between the first transactions reads34.The code to assign the isolation level of a transaction to Repeatable Read is:A. TransactionOptions options=System.Transactions.RepeatableReadB. TransactionOptions options = new TransactionOptions(); optionsIsolationLevel= System.Transactions.RepeatableRead;C. TransactionOptions options= options.IsolationLevel(Repeatable);D. TransactionOptions options=new TransactionOptions();options.IsolationLevel=RepeatableRead;35.Which XmlWriterSetting property gets or sets a value to indicate whether to do character checking or not?A.CheckCharactersB.CharacterCheckC.ConformanceLevelD.OmitXmlDeclaration36.Which of the following options creates an XML file called Products.xml, where s is an XmlWriterSettings object?A. XmlWriter writer = new XmlWirter(s, ”Products.xml”);B. XmlWriter writer = new XmlWirter(”Products.xml”, s);C. XmlWriter writer = XmlWirter.Create(s,”Products.xml”);D. XmlWriter writer = XmlWirter.Create(”Products.xml”, s);1 What is ADO.NET?ADO.NET 是.NET框架体系架构的一部分。它是.NET应用程序使用的模型，与数据库进行通讯，用来检索，访问和更新数据。The is. T framework system part of the architecture. It is application USES model, and database communication, used to search, access and update data.2. Discribe the ADO.NET Object Model. ADO.NET使应用程序连接到数据源操作数据。它是基于万维网组织（W3C）制订的标