Deck 22: Databases and LING

Question 1

SQL is an acronym for:

A) Smart Query Language
B) Simulated Query Language
C) Structured Query Language
D) None of the above

Answer 1

C

Question 2

Relational databases can be thought of as ________.

A) rows
B) columns
C) tables of rows and columns
D) three-dimensional arrays

Answer 2

C

Question 3

DBExtensions method Load loads an entire database's data into a DbContext.

Answer 3

False
This method loads the specified data-typically a specific table or the result of a LINQ to Entities query.

Question 4

An ADO.NET Entity Data Model cannot represent the relationships between tables in a database.

Question 5

An ADO.NET Entity Data Model contains only classes that represent the database's tables.

Question 6

A query is a request to the database for the data that satisfies the specified criteria.

Question 7

A relational database model is a way of organizing data and considering relationships based on the physical structure of the data.

Question 8

The BindingNavigator allows the user _________.

A)to control which row of the table is currently in view
B) to add new and delete new rows
C) to save changes to the data in view
D) All of the above

Question 9

It's possible to select only a subset of a relational database table's columns.

Question 10

Database management systems enable you to access and store data without worrying about the external representation of databases.

Question 11

An object of a subclass of ________ is used to manage the data flow between your program and the database.

A)DataFlow
B)DatabaseContext
C)DbContext
D)EntityDataModel

Question 12

An ADO.NET Entity Data Model contains only classes that represent the database's tables.

Question 13

A primary key field can be duplicated in other records of the same relational database table,making it easier to manipulate.

Question 14

Tables from databases are commonly shown in a GUI through a ________.

A) DataBoxView
B) DataGridView
C) ListBoxView
D) SpreadSheet

Question 15

There is a ____________ relationship between a primary key and its corresponding foreign key.

A) one-to-one
B) foreign
C) one-to-many
D) structural

Question 16

Today's most popular database systems are ________.

A) management databases
B) structural databases
C) formatted databases
D) relational databases

Question 17

A relational database model allows relationships between data to be considered without concern for the ________.

A) meaning of the data
B) structure of the data
C) application of the data
D) All of the above

Question 18

When various databases are combined,this is known as data binding.

Question 19

Each foreign key can be created independently.

Question 20

A primary key must be unique for each record in the relational database table.

Question 21

A master/detail view app typically allows the user to select an entry to see (and potentially manipulate)the details associated with that entry.

Question 22

The extension method ________ is used to filter the results of a LINQ query.

A)Filter
B)Equals
C)Where
D)None of the above

Question 23

A LINQ query may contain only one from clause.

Question 24

It's possible to nest LINQ queries to produce hierarchical results.

Question 25

You can call a BindingSource's ________ method to move to the first row of the result.

A)First
B)MoveFirst
C)FirstRow
D)None of the above