Deck 10: Incorporating Databases With Adonet

Question 1

ADO.NET 5 can connect to ____.

A) Oracle
B) Access
C) SQL
D) PowerPoint

Answer 1

A,B,C

Question 2

Database tables store information in ____.

A) records
B) links
C) rows
D) connections

Answer 2

A,C

Question 3

To support databases that use Visual Basic 2017, a library called Primary Project Resources works within all Windows, Office, and Web applications. _________________________

Answer 3

False

Question 4

The Disconnect command should be used to disconnect the program from a database. _________________________

Question 5

Data stored in a database is organized into ____

A) reports
B) queries
C) tables
D) files

Question 6

ADO.NET works with ____.

A) Access 2016
B) Access 2013/2010
C) SQL
D) Oracle

Question 7

The data access technology called ____ allows applications to connect to a variety of database sources from within the Visual Studio environment.

A) ADO.DAT
B) ADO.REP
C) ADO.XSD
D) ADO.NET

Question 8

A ____ is a collection of related information stored in a structured format.

A) database
B) project
C) form
D) query

Question 9

A ____ in a database structures data into rows and columns.

A) file
B) query
C) report
D) table

Question 10

In a database, the term ____ is another name for row.

A) column
B) field
C) file
D) record

Question 11

A ____ in a database is a stored collection of data about a specific topic.

A) report
B) form
C) table
D) file

Question 12

To connect a Visual Basic 2017 application to data in a database, use the Connect to Data Configuration Wizard

Question 13

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

A) databases
B) indices
C) web services
D) objects

Question 14

A primary key is a(n) ____ in a table that contains a unique value to identify each record in a table.

A) row
B) field
C) index
D) column

Question 15

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

Question 16

A column in a database table is referred to as a ____.

A) field
B) record
C) row
D) table

Question 17

Which of the following must be installed on your computer before you can incorporate databases with ADO.net?

A) Data Source Manager
B) ADO 2017
C) Database Grid v.4
D) Access 2016

Question 18

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

A) field
B) file
C) query
D) row

Question 19

A user can permanently remove a database record by clicking or tapping the ____ button on the navigation toolbar.

A) Remove
B) Exit
C) Delete
D) Purge

Question 20

ADO.NET can be used to connect applications to a variety of database sources in Visual Studio.

Question 21

The first step in accessing database information is to establish a ____ with the database.

A) connection
B) dialog
C) data exchange path
D) pipeline

Question 22

To support databases using Visual Basic 2017, a library called ____ Data Objects works within all Windows, Office, and Web applications.

A) Indexed
B) Basic
C) ActiveX
D) Virtual

Question 23

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

A) Database
B) DataSet
C) DataSource
D) DataRecord

Question 24

Data ____ is the term that is used to refer to loading the DataSet string.

A) binding
B) connecting
C) reflecting
D) establishment

Question 25

A ____ control allows actions such as navigating through data, adding data, and deleting data.

A) BindingNavigator
B) BindingToolStrip
C) DataNavigator
D) DataToolStrip

Question 26

A BindingNavigator control consists of a(n) ____ containing objects for common data-related actions.

A) DataToolStrip
B) ToolStrip
C) DataNavigator
D) Connector

Question 27

To connect a Visual Basic 2017 application to data in a database, use the ____ Wizard.

A) Data Source Connection
B) Database Source Configuration
C) Data Source Configuration
D) Database Source Connection

Question 28

You create a connection to a database by specifying a(n) ____ from the Windows application to the database source.

A) link
B) path
C) keyline
D) index

Question 29

A navigation toolbar control called the ____ appears on the Windows form after a database field is placed on the form.

A) ToolStrip
B) BindingNavigator
C) Connector
D) DataNavigator

Question 30

Data ____ allows you to display each field in a database table as an object on a form.

A) binding
B) objectification
C) reflection
D) referral

Question 31

When adding a data source to a Windows application, use the Add New Data Source command on the ____ menu.

A) Edit
B) Project
C) Source
D) File

Question 32

The Data Source Configuration Wizard uses the ____ method to populate a DataSet object with table rows and columns from a selected table within a database.

A) Populate
B) Fill
C) Arrange
D) Cache

Question 33

When you want to select which database objects you want in the DataSet, ____ next to the Tables option.

A) hover
B) right-click or press-hold
C) click the small table icon
D) click the expand icon

Question 34

After establishing a connection with a database, data is available in the ____ window of the Visual Basic environment.

A) Database
B) DataSet
C) Data Sources
D) Tables

Question 35

A(n) ____ key is used in relational databases to avoid duplicate records.

A) primary
B) origin
C) foreign
D) duplicate

Question 36

A(n) ____ string contacts the data source and establishes a connection with the database using the Data Source Configuration Wizard.

A) linkage
B) index
C) connection
D) keyline

Question 37

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

A) primary key
B) record
C) row
D) table

Question 38

On the BindingNavigator control, the Add new button inserts a new ____ to add a new ____ to the original database table.

A) field, record
B) field, column
C) column, record
D) row, record

Question 39

Database field objects can be dragged on a Windows form from the ____ window.

A) Debug
B) Data Sources
C) Navigation
D) Objects

Question 40

You can run an application by tapping or clicking the ____ button on the Standard toolbar.

A) Debug
B) Start
C) Run
D) Execute

Question 41

The number of rows or columns in the DataTable can be computed using the ____ property.

A) Total
B) Sum
C) Count
D) Aggregate

Question 42

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

Question 43

The only valid source for a database is a local hard drive.

Question 44

You cannot complete data binding by coding.

Question 45

To ensure that the system resources of the computer and network are not overloaded, the program should use a database in ____ form.

A) bound
B) connected
C) disconnected
D) unbound

Question 46

A database can contain only one record.

Question 47

The ____ command is used to disconnect a DataTable object from the database.

A) Disconnect
B) Break
C) Dispose
D) Unlink

Question 48

The only way you can complete data binding is by dragging the fields on the form.

Question 49

The ____ is a bridge created by the Database Wizard between the DataSet and the database that contains the data.

A) BridgeAdapter
B) DataBridgeAdapter
C) OleDataAdapter
D) OleDbDataAdapter

Question 50

The DataSet object is not part of the ADO.NET architecture.

Question 51

When creating tables in a database, for coding purposes the table name may contain spaces.

Question 52

Visual Basic 2017 allows you to change a TextBox object to another ____ object of your choice.

A) Toolkit
B) Navigation
C) Dynamic
D) Toolbox

Question 53

In the Solution Explorer, the code for the database file path is found in the App.config file.

Question 54

The DataTable object can be used to access individual fields within a database by using the ____ procedure.

A) Field
B) Fields
C) Row
D) Rows

Question 55

A DataSet permanently stores database data in the application.

Question 56

A ____ object is needed to hold data retrieved from a database via the OleDbDataAdapter connection.

A) DataFile
B) DataRecord
C) DataSource
D) DataTable

Question 57

A SQL ____ statement is a query statement that requests data from one or more database tables.

A) DataRequest
B) DataSelect
C) Request
D) Select

Question 58

To connect to the database using the Data Source Configuration Wizard, with Visual Studio 2017 open, click the Connect Project button on the Connection toolbar.

Question 59

By default, each database table item is displayed as a TextBox object in the ____ window of the Visual Studio environment.

A) Database Items
B) Data Sources
C) Table Items
D) Table Elements

Question 60

When running a Windows form application that uses a database, click the ____ button on the navigation toolbar to add a new record to the database table.

A) New record
B) Add record
C) Add new
D) Create record

Question 61

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

Question 62

In a database, a(n) ____________________ is referred to as a record.

Question 63

To view the data available in the source database, you need to click Show Data Sources on the View menu.

Question 64

In the Data Sources window, you cannot change the type that is associated with each table object.

Question 65

In a database, a(n) ____________________ is referred to as a field.

Question 66

To fill a ComboBox object with data from a field in a database, the ComboBox object must be bound to that field.

Question 67

A Windows form application can be used to view but not update records within a database.

Question 68

The prefix ole is used for an OleDbDataAdapter.

Question 69

The OleDbDataAdapter consists solely of a path statement to connect to the database to fill the DataSet.

Question 70

A(n) ____________________ is a collection of related information stored in a structured format.

Question 71

____________________ in a database store information about a specific topic.

Question 72

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

Question 73

A user cannot delete a record from a database table using the BindingNavigator control.

Question 74

Data binding can only be accomplished by writing code.

Question 75

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.

Question 76

By default, the BindingNavigator control contains standard buttons for adding new records and deleting records.

Question 77

A(n) ____________________ is one column in a table.

Question 78

The Delete button on the BindingNavigator control deletes a record from the program's displayed data but does not delete the record permanently from the database.

Question 79

When using the BindingNavigator control in an application, the only way in which the user may move throughout the data in the associated table is by using the arrow navigation buttons.

Question 80

In the Visual Studio design window, you can delete the Add Record button on the BindingNavigator to remove that capability so that the user can only read the information in the form but not add a record.