Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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  False

Question 3

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  False

Question 4

Each foreign key can be created independently.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

A LINQ query may contain only one from clause.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 22: Databases and LING

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

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

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

Each foreign key can be created independently.

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

SQL is an acronym for:

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

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

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

Relational databases can be thought of as ________.

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

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

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

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

A LINQ query may contain only one from clause.

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

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

The BindingNavigator allows the user _________.

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

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

Introduction to Computers, the Internet and Visual C#

Dive Into Visual Studio Community

Introduction to C# Apps

Introduction to Classes,Objects,Methods and Strings

Control Statements: Part 1

Control Statements: Part 2

Methods: a Deeper Look

Arrays;Introduction to Exception Handling

Introduction to Linq and Generic Collections

Classes and Objects: A Deeper Look

Object-Oriented Programming: Inheritance

Object-Oriented Programming: Polymorphism

Exception Handling: A Deeper Look

GUI With Windows Forms: Part 1

GUI With Windows Forms: Part 2

Strings,Characters and Regular Expressions

Files and Streams

Searching and Sorting

Data Structures

Generics

Collections

Asynchronous Programming With Async and Await

XML

GUI With Windows Presentation Foundation

Filters