1.Which of the following statements is correct about creating a database connection?
a.An application can have at most one database connection.
b.Connections can be created to different types of databases, such as Microsoft Access or SQL Server.
c.To create a connection, create an instance of the Connection control on a form.
d.There are two types of database connections – strongly typed connections and untyped connections.
2.Which of the following statements is correct of database connections?
a.Connection strings are identical from one database provider to another.
b.The Provider key is used to specify a database management system such as Microsoft Access.
c.To create a database connection, create an instance of the Connect class.
d.Once a connection has been created, it is always open while an application is running.
3.The Data Source key of the ConnectionString property of the OleDbConnection class defines:
a.the directory containing the database file and the name of the file.
b.the file containing the database.
c.the authentication information required by the provider.
d.the source code for the database.
4.____ is a Microsoft technology for interfacing with data stores.
a.OLE DBc.XML
b.HTMLd.COM
5.ADO was based on the ____ standard for interfacing with a data store.
a.XMLc..NET Framework
b.OLE DBd.JDBC
6.ADO.NET, released in 2002, is based on the ____.
a.ODBC protocolc.Microsoft .NET Framework
b.OLE DB standardd.XML format
7.A(n) ____ is a set of classes that provides the link between the dataset and the database.
a.DB2c.data provider
b.datasetd.RDBMS
8.A(n) ____ is a separate memory resident representation of only that part of the database that an application needs.
a.RDBMSc.ADO object
b.datasetd.data provider
9.If an ADO.NET application updates (changes) the data in the dataset, the ____ writes the dataset back to the database.
a.data providerc.ADO.NET class
b.XML objectd.ADO class
10.A ____ simply tells the application where the database is located and allows the user to log on to the database.
a.data connectionc.data source
b.datasetd.data object
11.A ____ specifies exactly which parts of the database (which Tables, Columns, Views, Stored Procedures, and so on) are needed by the application.
a.data tablec.data connection
b.data sourced.DataRow
12.The ____ object is a memory resident cache (store) of data obtained from the underlying database just for this application.
a.DataSetc.TableCollection
b.DataCollectiond.TableAdapterCollection
Contact Author
Email to Friends
Print Article
Make PDF
Bookmark & Share Article
Add a Comment
Report Article
Republish this Article
