Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

The BindingNavigator allows the user _________.

Accepted Answer

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

SQL is an acronym for:

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Today's most popular database systems are ________.

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A LINQ query may contain only one from clause.

Accepted Answer

A) True 
 B)False

Question 19

Relational databases can be thought of as ________.

Accepted Answer

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

Question 20

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

Accepted Answer

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

Exam 12: Databases and LINQ to SQL

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

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

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

The BindingNavigator allows the user _________.

SQL is an acronym for:

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

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

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

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

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

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

Today's most popular database systems are ________.

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

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

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

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

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

A LINQ query may contain only one from clause.

Relational databases can be thought of as ________.

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

Introduction to Computers, the Internet and Visual Basic

Dive Into Visual Basic Express 2012 Express

Introduction to Visual Basic Programming

Introduction to Problem Solving and Control Statements

Problem Solving and Control Statements

Methods

Arrays

Files and Streams

Object-Oriented Programming: Classes and Objects

Object-Oriented Programming: Inheritance

Introduction to Linq

Web App Developing in Aspnet With Vb

Windows Forms Gui: a Deeper Look

Graphics and Multimedia

Exception Handling

Strings and Characters: a Deeper Look

Files and Streams

Xml and Linq to Xml

Windows 8 Ui Xaml

Windows 8 Graphics and Multimedia

Windows Phone 8 Case Study

Asynchronous Programming With Async and Await

Web App Development With Aspnet: a Deeper Look

Web Services

Windows Azure Cloud Computing Case Study

Visual Basic 2012 How to Program

Visual Basic 2012 How to Program

Data Structures and Generic Collections

Filters