Midterm Review 2

Front 1

events

Back 1

represent responses to the object by external actions; change of state

Front 2

What is the location of mdf file?

Back 2

database files; DATA folder in MSSQL

Front 3

What is a dataset?

Back 3

In-memory copy of data pulled from database.

Front 4

Explain One to Many relationship

Back 4

Primary key column of one table links to a foreign key column in another table; eg: one value in Departments may match many values in Employees

Front 5

Explain the steps in a Delegate

Back 5

1) Define - Creates a new class that inherits from a system.
Public Delegate Sub GreetingDelegate(ByVal MsgString As String)
2) Instantiate - assigns an address to a delegate
Dim MyGreetings As GreetingDelegate
MyGreetings = AddressOf GoodMorning
3) Invoke - invokes action
MyGreetings.Invoke("Raj")

Front 6

Which table in a relationship contains a foreign key: parent or child?

Back 6

child

Front 7

In what type of relationship is a foreign key used as a linking field in both tables.

Back 7

many-to-many

Front 8

How do you create an alternative column name (an alias) when creating a LINQ query?

Back 8

Alias = tblName.Column_Name

Front 9

Name and explain three types of database constraints mentioned in the chapter 5.

Back 9

Primary key constraint
Column check constraint
Referential integrity constraint (aka Reference constraint)

Front 10

Primary key constraint

Back 10

requires that all values in a primary key must be unique

Front 11

Column check constraint

Back 11

defines whether data are valid when adding/updating an entry in a table; applied to each table row; eg: values in "Salary" column must be positive

Front 12

Referential integrity constraint (aka Reference constraint)

Back 12

applies to relationship between 2 tables with the one-to-many relationship; parent table required to contain primary key value that matches each foreign key value found in the child table

Front 13

Classes generally have

Back 13

1) class header (keyword and identifiers)
2) body

Front 14

What is the difference between a Class and an Object?

Back 14

- Class: A design template for objects; defines which properties, methods, and events can be applied to its objects
- Object: A container for members such as properties, fields, methods, and events; often represents an entity in a real-world application

Front 15

Objects are also known as...

Back 15

instances