Deck 12: Databases and LINQ to SQL

Question 1

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

Answer 1

B

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

Relational databases can be thought of as ________.

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

Question 6

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 7

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

Question 8

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

Question 9

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 10

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

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

Question 11

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

Question 12

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 13

Each foreign key can be created independently.

Question 14

Today's most popular database systems are ________.

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

SQL is an acronym for:

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

Question 20

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

Question 21

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

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

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