Deck 11: Databases

Question 1

Most database tables have a(n) ____________, which is a column that can be used to identify a specific row.

A) identifier
B) primary key
C) key word
D) column name

Answer 1

B

Question 2

A ____________ is a complete set of information about a single item in a table.

A) bit
B) column
C) cell
D) row

Answer 2

D

Question 3

A ____________ can display an entire database table in a scrollable grid on an application's form.

A) BindingNavigator control
B) DataSet control
C) Chart control
D) DataGridView control

Answer 3

D

Question 4

If a column contains no data, it is said to be ____________.

A) null
B) empty
C) void
D) open

Question 5

In a database, each ____________ holds a collection of related data items.

A) spreadsheet
B) record
C) table
D) object

Question 6

Once data items are stored using a database management system, applications may be written in ____________ to communicate with the DBMS.

A) Java
B) C#
C) Visual Basic
D) any of these

Question 7

A(n) ____________ is a column that contains unique values generated by the DBMS, usually using a counter.

A) primary key
B) identity column
C) key column
D) generated field

Question 8

A ____________ is a component that can connect user interface controls directly to a dataset.

A) table binder
B) grid viewer
C) binding source
D) data source

Question 9

A ____________ connects to a data source and can retrieve and update data from a table in a data source.

A) source reference
B) table connection
C) table adapter
D) binding source

Question 10

The DBMS works directly with the data and sends the results of operations back to the ____________.

A) application
B) data
C) DBMS
D) CPU

Question 11

A(n) ____________ is software specifically designed to store, retrieve, and manipulate large amounts of data in an organized and efficient manner.

A) search engine
B) database management system (DBMS)
C) integrated development environment (IDE)
D) productivity suite

Question 12

A ____________ is a source of data with which the application can work. Examples are databases, and Excel spreadsheets.

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

Question 13

When specifying a data type for the columns in a database table, the data types you can choose from are provided by the ____________.

A) DBMS
B) programming language
C) computer manufacturer
D) compiler

Question 14

A ____________ is a set of individual controls that are bound to the columns in a single row. For example, it might display multiple data items for a single student.

A) Details view
B) Multi-viewer
C) Column browser
D) Row navigator

Question 15

When an application runs for the first time, Visual Studio copies the database file from the project folder to the project's ____________, which is the bin/Debug folder.

A) data folder
B) table folder
C) output folder
D) hidden folder

Question 16

____________ is automatically installed on your system when you install Visual Studio.

A) Oracle
B) DB2
C) MySQL
D) Microsoft SQL Server Express Edition

Question 17

A ____________ gets a copy of a table from the table adapter and keeps the copy of the table in memory.

A) record locker
B) data source
C) table copier
D) dataset

Question 18

A database management system stores data in a ____________ .

A) text file
B) binary file
C) database
D) source file

Question 19

A ____________ is a user interface control that is connected to a data source.

A) table control
B) data-bound control
C) UI data-viewer
D) database module

Question 20

Each _________ in a table holds an individual piece of information about all items in the table.

A) tier
B) row
C) column
D) block

Question 21

In SQL, the ____________ requires that both search criteria be true in order for a row to be qualified as a match.

A) Or operator
B) Also keyword
C) & character
D) And operator

Question 22

The ____________ identifies a column from the table to display in a ListBox control.

A) ShowColumn property
B) column name
C) DisplayMember property
D) DataSource property

Question 23

In SQL, the ____________ can be used to search for a substring.

A) Sub method
B) Contains statement
C) Who instruction
D) Like operator

Question 24

When you use the ____________ in a Select statement, only the rows that meet the search criteria are returned.

A) Ask keyword
B) Where clause
C) ? operator
D) Find expression

Question 25

In SQL, you use keywords to construct statements, which are also known as ____________.

A) queries
B) expressions
C) determinants
D) solutions

Question 26

SQL, which stands for ____________, is a standard language for working with database management systems.

A) simultaneous query logic
B) structured query language
C) sequential query language
D) standard quasi language

Question 27

In SQL, the ____________ is used as a wildcard character, and can be used to represent any sequence of zero or more characters.

A) ^ symbol
B) Wild operator
C) % symbol
D) * character

Question 28

The ____________ identifies the table from which the data-bound control will get its data.

A) DataSource property
B) Table property
C) primary key
D) DisplayMember property

Question 29

In SQL, the ____________ calculates the average value in a particular column.

A) Average function
B) # symbol
C) Avg function
D) SQL_Average statement

Question 30

When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's ____________.

A) Sync method
B) Refresh method
C) Fill method
D) Clear method

Question 31

In SQL, strings are enclosed in ____________.

A) single quotes
B) underscores
C) asterisks
D) brackets

Question 32

In SQL, you use the ____________ to retrieve the rows in a table.

A) Read statement
B) Get expression
C) Select statement
D) Row keyword

Question 33

If you wish to sort the results of an SQL Select query, you can use the ____________.

A) Order By clause
B) List keyword
C) Index method
D) @ operator

Question 34

SQL provides the ____________ for determining the number of matching rows in a table.

A) Rows function
B) Count function
C) Max function
D) Volume function

Question 35

In an SQL statement, a query parameter variable begins with the ____________.

A) param keyword
B) var operator
C) @ symbol
D) ref clause

Question 36

A(n) ____________ is an SQL statement stored in a table adapter object, which can be executed simply by calling a method.

A) dataset macro
B) columnar directive
C) table adapter query
D) referenced subroutine

Question 37

When you click on the ____________ in a data-bound control, a tasks panel will appear, giving you a number of options you can perform.

A) options check box
B) smart tag
C) view button
D) taskbar

Question 38

A ____________ is a file, ending with the .xsd extension, which describes the contents of a dataset.

A) schema definition file
B) extensible schema data file
C) extended source file
D) data exclusion file

Question 39

When developing applications that work with an intensive amount of data, most developers prefer to use a database management system.

Question 40

If an application needs to store only a small amount of data, sequential and binary files are efficient and easy to use.

Question 41

Data stored in databases is organized into one or more tables.

Question 42

When you make changes to a database table in one form, the changes automatically appear in other forms that connect to the same table using their own datasets.

Question 43

A .NET application requires a set of special components that let it connect to, and work with, a database.

Question 44

When you use Visual Studio to create a database, the database file will be created in the project folder.

Question 45

When you place a data-bound control on a form, keep in mind that Visual Studio does not automatically generate the code needed for the control to display any data from the database table.

Question 46

Rather than displaying multiple rows at once, a Details view lets the user see one row at a time.

Question 47

Each column in a table must have a name.

Question 48

SQL is a general purpose programming language, which can be used to write applications.

Question 49

The application handles the mechanical details reading of, writing of, and searching for data in a database.

Question 50

When you create a database table, you must specify a data type for each column.

Question 51

Each subsequent time an application runs, it connects to the copy of the database in the output folder, rather than the project folder.

Question 52

Rather than retrieving or manipulating the data directly, applications send instructions to the DBMS, and the DBMS carries out those instructions and sends the results back to the application.

Question 53

Data stored in a database table's column is divided into tables.

Question 54

Data-bound controls automatically display data from a data source and can be used to modify the data they are bound to.

Question 55

To bind a ListBox control to a column, you must set two of the controls properties: DataSource and DisplayMember.

Question 56

It is possible to change the type of control that a column is bound to in a Details view.

Question 57

Data stored in a database table is organized into rows and columns.

Question 58

The table row designated as the primary key must hold a unique value for each column.

Question 59

The table column designated as the primary key must hold a unique value for each row.

Question 60

There are numerous DBMSs in use today, and Visual C# can interact with many of them.

Question 61

In SQL, if you need to include a single quote as part of a string, simply write two consecutive single quotes in its place.

Question 62

SQL uses database mnemonics to construct statements, which are also known as table adapter queries.

Question 63

The equal to and not equal to operators in SQL are different from those in C#.

Question 64

SQL provides several functions for performing calculations.

Question 65

In SQL, the asterisk symbol is used as a wildcard to represent a single character.

Question 66

The Not operator can be used in SQL to disqualify a character pattern in a search criteria.

Question 67

The Desc operator can be used to sort the results of an SQL Select query in descending order.

Question 68

You can add your own SQL queries to a table adapter and call them from your C# code.

Question 69

SQL does not support relational operators.