Exam 10: Incorporating Databases With Adonet

The prefix ole is used for an OleDbDataAdapter.​

A DataSet object is a temporary ____________________ storage for data retrieved from a data source.​

The * symbol in a SQL Select statement means that all fields within a table are available.​

If you are using ADO.NET 5 in Visual Basic 2015,you must create a coded connection for the Windows form.​

Visual Studio provides tools to connect an application to data from ____.​

The Fill command is used to fill a(n)____________________ object with data from a database.​

The process of defining a(n)____________________ to a database is the same for all types of databases.​

The DataSet used in the Database Wizard is a collection of ____________________ objects.​

After you have configured a DataSet with the Data Source Configuration Wizard,the next step is to load the DataSet with the data stored in the database.​

The ToolStrip control used for navigating through database records is called the BindingToolStrip._________________________​

A ____ contains a specific piece of data within a record in a database table.​

Identify the letter of the choice that best matches the phrase or definition.​ a.​BindingNavigator b.​Data Source Configuration Wizard c.​DataTable d.​Data Sources e.​Fill f.​initialize g.​connection h.​databinding i.​Count j.​table REFERENCES: 686 686 699 700 699 715 715 715 715 716 -​Property that can be used to determine the number of columns in a DataTable

A ____ object is a temporary cache storage for data retrieved from a data source.​

Explain in general terms how to establish a database connection.Be sure to include the Data Sources window and the DataSet object in your response.​

Identify the letter of the choice that best matches the phrase or definition.​ a.​BindingNavigator b.​Data Source Configuration Wizard c.​DataTable d.​Data Sources e.​Fill f.​initialize g.​connection h.​databinding i.​Count j.​table REFERENCES: 686 686 699 700 699 715 715 715 715 716 -​The dat prefix is used to do this to a DataTable

Use the Next Record button on the navigation toolbar of an application to move through records in a database.​

A ____ is a field in a table that contains unique values in each record.​

Identify the letter of the choice that best matches the phrase or definition.​ a.​BindingNavigator b.​Data Source Configuration Wizard c.​DataTable d.​Data Sources e.​Fill f.​initialize g.​connection h.​databinding i.​Count j.​table REFERENCES: 686 686 699 700 699 715 715 715 715 716 -​A DataTable object contains this command that is used to fill the data table with data from the selected database table

Case 10-1 ​As you prepare to teach a class on the fundamentals of databases,you want to create a real-world example that will help define some of the key terms for this concept. -You have a table called AutoRepairDetails,which includes elements labeled Make,Model,LicensePlate,RepairCost,and OwnerName.In this table,which term best describes the role that RepairCost plays in the table?​

You cannot complete data binding by coding.​