EGR 1400 FINAL EXAM QUESTIONS &
ANSWERS(RATED A)
Table - ANSWERA rectangular array of data
Field - ANSWERA column in a table
Record - ANSWERA row in a table
DataSource - ANSWERImportating the data source into Visual Studio
DataMember - ANSWERGenerates the data to be used in Visual Studio
Primary key - ANSWERUsed to uniquely identify each record
Rule of Entity Integrity - ANSWEREvery record musth ave an entry in the primary-key
field
Two records cannot have the same entry
Rule of Referential Integrity - ANSWEREvery foreign key can be specified when a table
is first created
Foreign key - ANSWERWhen there is a correlation between two entries
Join - ANSWERAllows Visual Studio to link two tables
LINQ - ANSWERLanguage Integrated Query
Load event procedure - ANSWEROccurs at the form loads, a good place to assign
values to an array
arrayName.Count() - ANSWERNumber of elements
arrayName.Max() - ANSWERHighest value
arrayName.Min() - ANSWERLowest value
arrayName.First() - ANSWERFirst element
arrayName.Last() - ANSWERLast element
numArrayName.Average() - ANSWERAverage value of elements
numArrayName.Sum() - ANSWERSum of values of elements
, Split - ANSWERConverts a string containing a delimiter into a string array
Delimited - ANSWERTo establish the limits and boundaries
str.Split(null); - ANSWERSpace is the delimiter
Query - ANSWERRequest for information from a database
Query: from - ANSWERSelects where the information is gathered from
Query: where - ANSWERFilters out the results
Query: select - ANSWERSelects what values to use in the variable
Query: let - ANSWERGives a name to an expression
Query: order - ANSWERSorts the string values
A-Z - ANSWERAlphabetical ascending
Z-A - ANSWERAlphabetical descending
0-9 - ANSWERNumeric ascending
9-0 - ANSWERNumeric descending
DataSource property - ANSWERFills a listbox with values returned by a quary
Member - ANSWEREach subvariable in a structure
Structure - ANSWERUsed to represent a record
XML - ANSWERExtensible Markup Language
Line specifier - ANSWERChanges the properties of the line
Line specifier: - - ANSWERSolid line
Line specifier: -- - ANSWERDashed line
Line specifier: : - ANSWERDotted line
Line specifier: -. - ANSWERDash dotted
Line specifier: r - ANSWERMakes the line red
ANSWERS(RATED A)
Table - ANSWERA rectangular array of data
Field - ANSWERA column in a table
Record - ANSWERA row in a table
DataSource - ANSWERImportating the data source into Visual Studio
DataMember - ANSWERGenerates the data to be used in Visual Studio
Primary key - ANSWERUsed to uniquely identify each record
Rule of Entity Integrity - ANSWEREvery record musth ave an entry in the primary-key
field
Two records cannot have the same entry
Rule of Referential Integrity - ANSWEREvery foreign key can be specified when a table
is first created
Foreign key - ANSWERWhen there is a correlation between two entries
Join - ANSWERAllows Visual Studio to link two tables
LINQ - ANSWERLanguage Integrated Query
Load event procedure - ANSWEROccurs at the form loads, a good place to assign
values to an array
arrayName.Count() - ANSWERNumber of elements
arrayName.Max() - ANSWERHighest value
arrayName.Min() - ANSWERLowest value
arrayName.First() - ANSWERFirst element
arrayName.Last() - ANSWERLast element
numArrayName.Average() - ANSWERAverage value of elements
numArrayName.Sum() - ANSWERSum of values of elements
, Split - ANSWERConverts a string containing a delimiter into a string array
Delimited - ANSWERTo establish the limits and boundaries
str.Split(null); - ANSWERSpace is the delimiter
Query - ANSWERRequest for information from a database
Query: from - ANSWERSelects where the information is gathered from
Query: where - ANSWERFilters out the results
Query: select - ANSWERSelects what values to use in the variable
Query: let - ANSWERGives a name to an expression
Query: order - ANSWERSorts the string values
A-Z - ANSWERAlphabetical ascending
Z-A - ANSWERAlphabetical descending
0-9 - ANSWERNumeric ascending
9-0 - ANSWERNumeric descending
DataSource property - ANSWERFills a listbox with values returned by a quary
Member - ANSWEREach subvariable in a structure
Structure - ANSWERUsed to represent a record
XML - ANSWERExtensible Markup Language
Line specifier - ANSWERChanges the properties of the line
Line specifier: - - ANSWERSolid line
Line specifier: -- - ANSWERDashed line
Line specifier: : - ANSWERDotted line
Line specifier: -. - ANSWERDash dotted
Line specifier: r - ANSWERMakes the line red
