Internet Programming

lambertminko
Internetprogramming.docx

1-The _______________ represent various components that a database represents, and the _______________ allows communication with the database.

component properties - database property

entity classes - database context class

facade classes - dataset classes

context classes - dataset component

2-Writing entity and database context classes before generating a new database is called

Code First development

Initial Class development

Database First development

Entity Relationship development

3-To establish a many-to-many relationship between two entities, you typically use a

composite entity

linking entity

foreign entity

context entity

4-If one customer can have many invoices, but each invoice can belong to only one customer, what type of relation exists between customers and invoices?

primary-to-foreign

many-to-many

one-to-one

one-to-many

5-You can configure the creation of database tables in each of the following ways except

configuration by convention

data attributes

Fluent API

JSON plugins

6-Which of the following commands would you use in the Package Manager Console if you want to revert a database to a previous migration?

Drop-Database

Add-Migration

Scaffold-DbContext

Update-Database

7-To avoid losing modifications of entity classes that are generated from a database, it’s common to use

entity cloning

code segmentation

direct injection

partial classes

8-The concurrency option in EF Core that throws an exception whenever a row has been changed since its last retrieval is called

refusal concurrency

optimistic concurrency

pessimistic concurrency

last in wins

9-Providing basic CRUD operations for each class and further abstracting their details with use of an interface is a common design pattern named the

requisition pattern

chain of responsibility pattern

observer pattern

repository pattern

10-The unit of work pattern provides a central class that allows several _____________ objects to share a DB context.

observer

requisition

chain of responsibility

repository

11-To commit insert, update, and delete operations on a DbSet<T> object to the database, what method of the DbContext class must you call?

Disconnect()

Update()

SaveChanges()

Commit()

12-To begin encapsulating code for data access, it’s often helpful to begin by adding extention methods to the interface named

ILINQable<T>

IQueryable<T>

IEnumerable<T>

IRunnable<T>