Deck 10: Working With Databases

Question 1

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

Answer 1

A

Question 2

A table adapter's method is used to add a new row to a table.

A) Add
B) Append
C) Insert
D) Update

Answer 2

C

Question 3

A connects data bound controls to a dataset

A) data source
B) dataset
C) binding source
D) table adapter

Answer 3

C

Question 4

You use to provide multiple selection conditions in an SQL statement.

A) relational operators
B) compound expressions
C) arithmetic operators
D) the & operator

Question 5

A ____component passes data from one or more database tables to your program.

A) DataTransfer
B) DataSet
C) Connection
D) TableAdapter

Question 6

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.

Question 7

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.

Question 8

Which table adapter method reads data from the database into the dataset?

A) Fill
B) Read
C) Select
D) Retrieve

Question 9

Each database ____is also known as a row in a database table.

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

Question 10

A ____statement in SQL retrieves data from a database.

A) Select
B) Search
C) Find
D) SearchTable

Question 11

In an SQL query, the _wildcard character, used with the LIKE operator, will match multiple unknown characters.

A) &
B) #
C) *
D) %

Question 12

A ____is an in-memory copy of data read from database tables.

A) data control
B) dataset
C) connection
D) data adapter

Question 13

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

Question 14

_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

Question 15

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

Question 16

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) DataSource
D) Dataset

Question 17

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

Question 18

A database ___is organized into rows and columns.

A) grid
B) matrix
C) table
D) spreadsheet

Question 19

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

Question 20

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.

Question 21

In Visual Studio, choose the ___template when creating a database file.

A) Service-based Database
B) Local Database
C) DataSet
D) XML Schema

Question 22

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

Question 23

__allows you to query many types of data from virtually any source.

A) SQL
B) LINQ
C) OPENGL
D) DirectX

Question 24

The _control displays information from a dataset in row and column format.

A) DataAware
B) DataGridView
C) DataListView
D) DataTableView

Question 25

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*"

Question 26

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

Question 27

In SQL the bit type is equivalent to which Visual Basic data type?

A) Short
B) Boolean
C) Integer
D) String

Question 28

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

Question 29

_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

Question 30

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

Question 31

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

Question 32

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.