Database Connection Questions?

Could you please help me with the practice questions. Thank you.

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.TableAdapterColle...

Database Connection Questions?windows media player

This looks awfully like a test paper or homework!

I think people are willing to help but you should really try to learn this stuff for yourself - research it and read.

Start reading here http://en.wikipedia.org/wiki/Database

Database Connection Questions?windows live messenger internet explorer

1. b

2. b

3. a %26amp; b are practically the same thing. Who wrote this?

4. a

5. b

6. c

7. c

8. b

9. a %26amp; c are both involved

10. a

11. poorly structured question... none of those choices are ideal

12. a
1 c

2 b

3 a

4 a

5 b

6 c

7 b

8 b

9 c

10 a

11 c

12 d