Deck 10: Incorporating Databases With Adonet

Question 1

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

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

Answer 1

A

Question 2

​ADO.NET 5 can connect to ____.

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

Answer 2

A,B,C

Question 3

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

Answer 3

False
BindingNavigator

Question 4

ADO.NET 5 works with ____.​

A)​Access 2010
B)​Access 2013
C)​SQL
D)​Oracle

Question 5

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 6

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

Question 7

Database tables store information in ____.​

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

Question 8

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

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

Question 9

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

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

Question 10

​LINQ makes it easy to query data using SQL commands within the Visual Basic code window._________________________

Question 11

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 12

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

A)​Data Source Manager
B)​ADO 2013
C)​Database Grid v.4
D)​Access 2013

Question 13

​Data stored in a database is organized into ____.

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

Question 14

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

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

Question 15

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

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

Question 16

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 17

To use a database in a Windows application,tap or click the Use Database command on the PROJECT menu._________________________​

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

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

Question 20

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

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

Question 21

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

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

Question 22

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 23

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

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

Question 24

​
As shown in the accompanying figure,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)​tap or click the checkbox

Question 25

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 26

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 27

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

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

Question 28

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 29

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

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

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

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 32

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 33

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

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

Question 34

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 35

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

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

Question 36

To connect a Visual Basic 2015 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 37

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

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

Question 38

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

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

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 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 41

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

Question 42

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 43

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

Question 44

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

Question 45

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 46

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 47

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

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

Question 48

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

Question 49

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

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

Question 50

You cannot complete data binding by coding.​

Question 51

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 52

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

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

Question 53

A database can contain only one record.​

Question 54

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

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

Question 55

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

Question 56

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 57

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 58

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

Question 59

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

Question 60

A DataSet permanently stores database data in the application.​

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

The prefix ole is used for an OleDbDataAdapter.​

Question 66

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 67

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

Question 68

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

Question 69

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

Question 70

Data binding can only be accomplished by writing code.​

Question 71

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

Question 72

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 73

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

Question 74

____________________ in a database store information about a specific topic.​

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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