EGR 1400 FINAL EXAM QUESTIONS AND
ANSWERS 100% CORRECT!!
Table - ANSWER A rectangular array of data
Field - ANSWER A column in a table
Record - ANSWER A row in a table
DataSource - ANSWER Importating the data source into Visual Studio
DataMember - ANSWER Generates the data to be used in Visual Studio
Primary key - ANSWER Used to uniquely identify each record
Rule of Entity Integrity - ANSWER Every record musth ave an entry in the primary-key
field
Two records cannot have the same entry
Rule of Referential Integrity - ANSWER Every foreign key can be specified when a table
is first created
Foreign key - ANSWER When there is a correlation between two entries
Join - ANSWER Allows Visual Studio to link two tables
LINQ - ANSWER Language Integrated Query
Load event procedure - ANSWER Occurs at the form loads, a good place to assign
values to an array
arrayName.Count() - ANSWER Number of elements
arrayName.Max() - ANSWER Highest value
, arrayName.Min() - ANSWER Lowest value
Query: from - ANSWER Selects where the information is gathered from
Query: where - ANSWER Filters out the results
Query: select - ANSWER Selects what values to use in the variable
Query: let - ANSWER Gives a name to an expression
Query: order - ANSWER Sorts the string values
A-Z - ANSWER Alphabetical ascending
Z-A - ANSWER Alphabetical descending
0-9 - ANSWER Numeric ascending
9-0 - ANSWER Numeric descending
DataSource property - ANSWER Fills a listbox with values returned by a quary
Member - ANSWER Each subvariable in a structure
Structure - ANSWER Used to represent a record
XML - ANSWER Extensible Markup Language
CSV - ANSWER Comma Seperated Values
XML tag - ANSWER Categorization
XML content - ANSWER The value being categorized
XML child of state - ANSWER A branch from a tag
XML siblings - ANSWER All branches in a tag
CVS files - ANSWER Are loaded into arrays
ANSWERS 100% CORRECT!!
Table - ANSWER A rectangular array of data
Field - ANSWER A column in a table
Record - ANSWER A row in a table
DataSource - ANSWER Importating the data source into Visual Studio
DataMember - ANSWER Generates the data to be used in Visual Studio
Primary key - ANSWER Used to uniquely identify each record
Rule of Entity Integrity - ANSWER Every record musth ave an entry in the primary-key
field
Two records cannot have the same entry
Rule of Referential Integrity - ANSWER Every foreign key can be specified when a table
is first created
Foreign key - ANSWER When there is a correlation between two entries
Join - ANSWER Allows Visual Studio to link two tables
LINQ - ANSWER Language Integrated Query
Load event procedure - ANSWER Occurs at the form loads, a good place to assign
values to an array
arrayName.Count() - ANSWER Number of elements
arrayName.Max() - ANSWER Highest value
, arrayName.Min() - ANSWER Lowest value
Query: from - ANSWER Selects where the information is gathered from
Query: where - ANSWER Filters out the results
Query: select - ANSWER Selects what values to use in the variable
Query: let - ANSWER Gives a name to an expression
Query: order - ANSWER Sorts the string values
A-Z - ANSWER Alphabetical ascending
Z-A - ANSWER Alphabetical descending
0-9 - ANSWER Numeric ascending
9-0 - ANSWER Numeric descending
DataSource property - ANSWER Fills a listbox with values returned by a quary
Member - ANSWER Each subvariable in a structure
Structure - ANSWER Used to represent a record
XML - ANSWER Extensible Markup Language
CSV - ANSWER Comma Seperated Values
XML tag - ANSWER Categorization
XML content - ANSWER The value being categorized
XML child of state - ANSWER A branch from a tag
XML siblings - ANSWER All branches in a tag
CVS files - ANSWER Are loaded into arrays
