Chapter 10

17. __________ allows individual controls such as text boxes and labels to be linked to and automatically display the contents of a data source. a. Data binding b. A table adapter c. A data grid d. A data relation

a. Data binding

Which table adapter method reads data from the database into the dataset? a. Fill b. Read c. Select d. Retrieve

a. Fill

A unique student ID number could be used as a _________, whereas a student's last name would not be suitable because two students might have the last name. a. Primary Key b. Sort Key c. Record Type d. Data Source

a. Primary Key

. Assume the following table named Student exists in a database: Name Number Address GPA CumHrs Adams, Carol 123 Redford Hall 3.6 67 Baker, Paul 345 Kingman Hall 2.1 34 Jones, Jill 456 Bassett Hall 3.2 89 Smith, Mary 887 Redford Hall 3.8 112 Taylor, Darren 987 Bassett Hall 3.7 55 Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5? a. SELECT Name, GPA FROM Student WHERE GPA >=3.5 b. SELECT * FROM Student WHERE GPA >= 3.5 c. SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5 d. SELECT Student WHERE GPA >= 3.5 And Name, GPA

a. SELECT Name, GPA FROM Student WHERE GPA >=3.5

In Visual Studio, choose the ____________ template when creating a database file. a. Service-based Database b. Local Database c. DataSet d. XML Schema

a. Service-based Database

The SelectedValue property of a data-bound ListBox returns the value in the column specified by the ________ property. a. ValueMember b. ReturnColumn c. ReturnField d. DisplayMember

a. ValueMember

Which of the following SQL WHERE clauses will select all students whose last name begins with "S"? a. Where LastName Like "S%" b. Where LastName Like "S" c. Where LastName = "S%" d. Where LastName = "S*"

a. Where LastName Like "S%"

. Each database ________ is also known as a row in a database table. a. record b. table c. column d. field

a. record

A ________ statement in SQL retrieves data from a database. a. Select b. Search c. Find d. SearchTable

a. select

In SQL the bit type is equivalent to which Visual Basic data type? a. Short b. Boolean c. Integer d. String

b. Boolean

The __________ control displays information from a dataset in row and column format. a. DataAware b. DataGridView c. DataListView d. DataTableView

b. DataGridView

31. ___________ allows you to query many types of data from virtually any source. a. SQL b. LINQ c. OPENGL d. DirectX

b. LINQ

What is the simplest way to update a user's changes to the database? a. No need to save user changes as this occurs automatically b. Use the Update method of a table adapter c. Click the diskette icon to save the dataset to the database d. Call the SaveDataset method of the table adapter

b. Use the Update method of a table adapter

Which item describes the function of the following SQL statement? SELECT ID, Last_Name, First_Name, Address FROM Members WHERE Last_Name = @LastName a. a simple query b. a parameterized query c. a compound query d. a wildcard query

b. a parameterized query

You use to provide multiple selection conditions in an SQL statement. a. relational operators b. compound expressions c. arithmetic operators d. the & operator

b. compound expressions

A _______________ is the design of tables, columns and relationships between tables for the database. a. data table b. database schema c. data set d. relational model

b. database schema

A ________ is an in-memory copy of data read from database tables. a. data control b. dataset c. connection d. data adapter

b. dataset

A table adapter's _________ method is used to add a new row to a table. a. Add b. Append c. Insert d. Update

c. Insert

The correct SQL syntax to sort a table by Last_Name in order of A-Z is ______. a. SORT BY Last_Name ASCENDING b. ORDER BY Last_Name Down c. ORDER BY Last_Name ASC d. ORDER BY Last_Name DESC

c. ORDER BY Last_Name ASC

__________ is a tool provided by Visual Studio for creating and modifying SQL queries. a. Server Explorer b. SQL Explorer c. Query Builder d. SQL Toolbox

c. Query Builder

A complete set of data for a single student that includes the following information is called a __________. Student ID, First Name, Last Name, Major, Class a. Table b. Column c. Row d. Field

c. Row

All of the following are true about SQL except __________. a. SQL provides a standard means of interacting with a database. b. SQL consists of several keywords. c. SQL stands for "Sequenced Query Language" d. SQL is an industry-standard language.

c. SQL stands for "Sequenced Query Language"

Which statement does NOT accurately describe a database row? a. A row contains related data about a single item such as a department. b. A row contains one or more fields. c. When discussing a table, we refer to the rows by name. d. A row is part of a database table.

c. When discussing a table, we refer to the rows by name.

. A _________ connects data bound controls to a dataset a. data source b. dataset c. binding source d. table adapter

c. binding source

1. A database _____________is organized into rows and columns. a. grid b. matrix c. table d. spreadsheet

c. table

In an SQL query, the _____ wildcard character, used with the LIKE operator, will match multiple unknown characters. a. & b. # c. * d. %

d. %

The following statements are true about a data source except a. a data source is usually a database. b. a data source can be a text file. c. Data sets contain data retrieved from a data source. d. Data can be retrieved from but not written back to a data source.

d. Data can be retrieved from but not written back to a data source.

A ________ component passes data from one or more database tables to your program. a. DataTransfer b. DataSet c. Connection d. TableAdapter

d. TableAdapter

Which of the following statements is false? a. A database can store more data more efficiently than sequential text files. b. When using a large amount of data, most developers prefer to use a DBMS. c. Visual Basic is used to interface with the user and a DBMS works directly with the data. d. Visual Basic statements can directly access database fields without using the DBMS.

d. Visual Basic statements can directly access database fields without using the DBMS.

The SQL Select statement retrieves data from a database and returns it in a __________, a set of records matching the selection criteria. a. subset b. dynaset c. data source d. dataset

d. dataset

A is a column (or columns) that uniquely identifies each row of data in a database. a. selector b. main key c. identifier d. primary key

d. primary key

The Where clause of an SQL statement specifies __________. a. the location of the database being queried b. which fields are to be displayed c. specifies the order in which the rows should appear d. specifies which rows should be retrieved

d. specifies which rows should be retrieved