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 DB c. XML


b. HTML d. COM











5. ADO was based on the ____ standard for interfacing with a data store.


a. XML c. .NET Framework


b. OLE DB d. JDBC








6. ADO.NET, released in 2002, is based on the ____.


a. ODBC protocol c. Microsoft .NET Framework


b. OLE DB standard d. XML format











7. A(n) ____ is a set of classes that provides the link between the dataset and the database.


a. DB2 c. data provider


b. dataset d. RDBMS





8. A(n) ____ is a separate memory resident representation of only that part of the database that an application needs.


a. RDBMS c. ADO object


b. dataset d. 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 provider c. ADO.NET class


b. XML object d. 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 connection c. data source


b. dataset d. 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 table c. data connection


b. data source d. DataRow











12. The ____ object is a memory resident cache (store) of data obtained from the underlying database just for this application.


a. DataSet c. TableCollection


b. DataCollection d. TableAdapterColle...

Database Connection Questions?
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
Reply:1 c


2 b


3 a


4 a


5 b


6 c


7 b


8 b


9 c


10 a


11 c


12 d
Reply: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