Deck 10: Working With Databases

Question 1

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

Answer 1

B

Question 2

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

A) DataTransfer j. DataSet
K) Connection
L) TableAdapter

Answer 2

D

Question 3

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

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

Answer 3

B

Question 4

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 5

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 6

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

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

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

Question 8

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

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

Question 9

A ____statement in SQL retrieves data from a database.

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

Question 10

A is a column (or columns) that uniquely identifies each row of data in a database.

A) selector
E) main key
F) identifier
G) primary key

Question 11

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

Question 12

A _____connects data bound controls to a dataset

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

Question 13

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

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

Question 14

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

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

Question 15

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 16

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 17

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 18

A database _____________is organized into rows and columns.

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

Question 19

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

A) data control
B) dataset m. connection
N) data adapter

Question 20

The SelectedValue property of a data-bound ListBox returns the value in the column specified by the ____property.

A) ValueMember
B) ReturnColumn h. ReturnField
I) DisplayMember

Question 21

______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 22

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 23

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 24

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 25

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 26

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

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

Question 27

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.

Question 28

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

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

Question 29

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 30

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

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

Question 31

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

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

Question 32

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