Deck 11: Databases

Question 1

A ____________ is a source of data with which the application can work.

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

Answer 1

A

Question 2

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 2

D

Question 3

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

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

Answer 3

C

Question 4

Each ____________ in a table holds an individual piece of information about an item.

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

Question 5

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

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

Question 6

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 7

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

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

Question 8

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 9

Once the data is stored using the 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 10

A(n) ____________ is software that is 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 11

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 12

A(n) ____________ is a column that contains unique values that are generated by the DBMS.

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

Question 13

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

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

Question 14

A database management system stores data in a ____________ .

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

Question 15

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 16

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

Question 17

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 18

A ____________ is a set of individual controls that are bound to the columns in a single row.

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

Question 19

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

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

Question 20

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

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

Question 21

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

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

Question 22

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

A) Val keyword
B) # symbol
C) Avg function
D) SQL_Average statement

Question 23

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 24

When you click on the ____________, a tasks panel will pop up, giving you a number of options that you can perform.

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

Question 25

The ____________ identifies a column from the table to display in the data-bound control.

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

Question 26

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

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

Question 27

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 28

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

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

Question 29

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 30

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

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

Question 31

In SQL, strings are enclosed in ____________, not double quotes.

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

Question 32

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 33

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

Question 34

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

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

Question 35

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

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

Question 36

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

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

Question 37

If an application needs to store only a small amount of data, traditional files work well.

Question 38

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 39

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

A) simultaneous query logic
B) structured query language
C) simple quaternion logarithm
D) standard quasi language

Question 40

When you use the ____________ with 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 41

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

Question 42

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

Question 43

The data that is stored in a database is organized into one or more tables.

Question 44

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

Question 45

The data that is stored in column is divided into tables.

Question 46

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

Question 47

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

Question 48

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

Question 49

If a particular column is not allowed to be null, anytime you add a row of data to the table, the DBMS will require a value for the column.

Question 50

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 function properly.

Question 51

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

Question 52

Each column in a table must have a name.

Question 53

When you create a database table, you must specify a data type for the columns.

Question 54

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

Question 55

The application handles the actual reading of, writing of, and searching for data.

Question 56

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

Question 57

The data that stored in a table is organized into rows and columns.

Question 58

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

Question 59

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

Question 60

When you make changes to the dataset in one form, the changes automatically appear in other forms that have their own dataset.

Question 61

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

Question 62

SQL does not support relational operators.

Question 63

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

Question 64

SQL provides several functions for performing calculations.

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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