Deck 12: Adonet and Aspnet

Question 1

With ADO.NET, the connection between an application and a database is a temporary one.

Answer 1

True

Question 2

You create (or design) a Web page in Visual Basic .NET in the Web Form Designer window.

Answer 2

True

Question 3

The WHERE clause of the SELECT statement is a required clause.

Answer 3

False

Question 4

Connecting a DataSet object to a control in the interface is called grouping.

Question 5

The ORDER BY clause of the SELECT statement allows you to limit the records that will be selected.

Question 6

A database is an organized collection of related information stored in a file on a disk.

Question 7

For the user to view the dataset in an application, you need to bind the DataSet object to one or more controls in the interface.

Question 8

Visual Basic .NET uses ADO to connect an application to a database.

Question 9

Each row in a table represents a field.

Question 10

An online form is an example of a static Web page.

Question 11

A Web server is a computer that contains special software that "serves up" Web pages in response to requests from clients.

Question 12

Once you have created the dataset, you can preview its contents by right-clicking the DataAdapter object in the component tray, and then clicking Preview Data.

Question 13

The Web consists of documents called Web browsers that are stored on Web servers.

Question 14

A protocol is an agreement between a sender and a receiver regarding how data are sent and interpreted.

Question 15

A table is a group of related records.

Question 16

The provider is the link between the application and the Connection object.

Question 17

The Internet is the world's largest computer network.

Question 18

Each record in the dataset appears in a column in the DataGrid control.

Question 19

Each relational database can contain only one table.

Question 20

An XML schema definition file defines the tables and fields that make up the dataset.

Question 21

Each time a postback occurs, the Web page is redisplayed on the client's screen.

Question 22

A ____ database is one that stores information in tables, which are composed of columns and rows.

A) dynamic
B) static
C) spreadsheet
D) relational

Question 23

The ____ clause of the SELECT statement allows you to control the order in which the records appear when displayed.

A) SORT
B) ORDER BY
C) LIMIT
D) WHERE

Question 24

The ____ translates the Connection object's request for data into a language that the database can understand.

A) DataSet object
B) provider
C) DataAdapter object
D) DataGrid control

Question 25

You can use a list box on a Web form to display a list of choices from which the user can select one or more choices.

Question 26

You can use the tools contained in the Toolbox window to add controls to a Web form.

Question 27

The intersection of a row and a column in the DataGrid control is called a ____.

A) block
B) dataset
C) list
D) cell

Question 28

The CompareValidator tool is used to verify that an entry is within the specified minimum and maximum values.

Question 29

You can use a Web form's CheckPostBack property to determine whether the Web form is being displayed for the first time or as a result of a postback.

Question 30

When an application needs to access the data stored in a database, it submits the appropriate request using a ____.

A) Connection object
B) DataSet object
C) provider
D) DataAdapter object

Question 31

An XML schema definition file has a(n) ____ filename extension.

A) .xsd
B) .xsh
C) .xs
D) .sdf

Question 32

In most tables, one of the fields uniquely identifies each record and is called the ____ key.

A) independent
B) functional
C) primary
D) foreign

Question 33

Controls in the interface connected to a DataSet object are referred to as ____ controls.

A) bound
B) grouped
C) sorted
D) selected

Question 34

You use a DataAdapter object's ____ method to fill a dataset with data while an application is running.

A) Capture
B) Get
C) Fill
D) Return

Question 35

____ is a set of commands that allows you to access and manipulate the data stored in many database management systems.

A) XML
B) SQL
C) ADO.NET
D) ADO

Question 36

When an application first connects to a database, it makes a copy, called a ____, of the records and fields it wants to access.

A) DataGrid
B) dataset
C) browser
D) connection

Question 37

Each ____ in a table represents a record.

A) row
B) column
C) database
D) page

Question 38

The ____ is responsible for establishing the connection to the database.

A) DataSet object
B) Connection object
C) DataAdapter object
D) provider

Question 39

____ is a text-based language used to store and share data between applications and across networks and the Internet.

A) SQL
B) XML
C) ADO
D) ADO.NET

Question 40

A ____ contains the data you want to access from the database, as specified in the SELECT statement associated with the DataAdapter object.

A) provider
B) Connection object
C) schema file
D) dataset

Question 41

The ____ communication protocol is the protocol used to transmit Web pages on the Web.

A) HTML
B) HTTP
C) URL
D) XML

Question 42

The ____ Web validation tool is used to verify that an entry matches a specific pattern.

A) RequiredFieldValidator
B) RegularExpressionValidator
C) CompareValidator
D) RangeValidator

Question 43

A DataGrid control's ____ method is used to bind the control to the dataset.

A) Connect
B) DataBind
C) SetDataSet
D) Fill

Question 44

A ____ refers to the client requesting data from the server, and the server responding.

A) postback
B) callback
C) refresh
D) binding

Question 45

A URL consists of ____ parts.

A) two
B) three
C) four
D) five

Question 46

The ____ Web validation tool is used to verify that a control contains data.

A) RequiredFieldValidator
B) RegularExpressionValidator
C) CompareValidator
D) RangeValidator

Question 47

The unique address of a Web page that indicates its location on the Web is called a(n) ____.

A) XML
B) HTML
C) HTTP
D) URL

Question 48

A ____ is a computer that requests information from a Web server.

A) schema
B) Web page
C) browser
D) client

Question 49

You can create a static Web page by opening a document in a text editor and then saving the document using a filename extension of ____.

A) .xsd
B) .xml
C) .html
D) .mdb

Question 50

Information from a Web server is requested and subsequently viewed through the use of a program called a Web ____.

A) client
B) browser
C) provider
D) connector