UCONN NRE 2000 Final Exam
questions with verified answers rated
A+ 2025/2026
What's a record? - ANS ✔✔An individual row in a table representing a single object in the real
world
What's a column? - ANS ✔✔A field in a table representing the attribute of a real-world object,
and it establishes the type of value each record must have for this field
In Access "456.08" (including the quotes) is of type - ANS ✔✔character string
The zip code 06269 is a _________ type - ANS ✔✔text
A database is - ANS ✔✔a mechanism for storing and organizing data
Suppose < Height (m): 1200/3937 [HT] > was typed into the Field: row of an Access query
having Trees and Shrubs only as its row source. Would this be a legitimate expression to convert
plant height in feet to meters? - ANS ✔✔No because the expression is missing a *
What is the value of the expression Null = 3? - ANS ✔✔Null
Which selection criterion finds plants whose value in [HT] is missing? - ANS ✔✔Is Null
In Access, " " is called the - ANS ✔✔empty string
, What's a query? - ANS ✔✔A program run against a row source to insert, view, or manipulate
objects in a database
Like "?x*" matches - ANS ✔✔a string with two or more characters, and the second character is
'x'
"***" matches - ANS ✔✔All strings
In Access syntax [87963] is - ANS ✔✔the name of a column or table
In Access "[x?y]" matches - ANS ✔✔"x&y"
In Access "[x*y]" matches (select all correct answers) - ANS ✔✔"x y" AND "xy" AND "x and y"
"*a*b*" matches - ANS ✔✔strings with 'a' and 'b' in them anywhere but 'a' comes before 'b'
In Access YES is a type of - ANS ✔✔Boolean
Four minutes and thirty-three seconds is - ANS ✔✔A musical composition without notes
In Access "456.0e-8" (including the quotes) is of type - ANS ✔✔character string
What's a table? - ANS ✔✔A set of records in which no two are identical, and a set of records all
of the same type
For maps, the word "scale" is - ANS ✔✔the ratio of distances on the map to distances in the real
world
questions with verified answers rated
A+ 2025/2026
What's a record? - ANS ✔✔An individual row in a table representing a single object in the real
world
What's a column? - ANS ✔✔A field in a table representing the attribute of a real-world object,
and it establishes the type of value each record must have for this field
In Access "456.08" (including the quotes) is of type - ANS ✔✔character string
The zip code 06269 is a _________ type - ANS ✔✔text
A database is - ANS ✔✔a mechanism for storing and organizing data
Suppose < Height (m): 1200/3937 [HT] > was typed into the Field: row of an Access query
having Trees and Shrubs only as its row source. Would this be a legitimate expression to convert
plant height in feet to meters? - ANS ✔✔No because the expression is missing a *
What is the value of the expression Null = 3? - ANS ✔✔Null
Which selection criterion finds plants whose value in [HT] is missing? - ANS ✔✔Is Null
In Access, " " is called the - ANS ✔✔empty string
, What's a query? - ANS ✔✔A program run against a row source to insert, view, or manipulate
objects in a database
Like "?x*" matches - ANS ✔✔a string with two or more characters, and the second character is
'x'
"***" matches - ANS ✔✔All strings
In Access syntax [87963] is - ANS ✔✔the name of a column or table
In Access "[x?y]" matches - ANS ✔✔"x&y"
In Access "[x*y]" matches (select all correct answers) - ANS ✔✔"x y" AND "xy" AND "x and y"
"*a*b*" matches - ANS ✔✔strings with 'a' and 'b' in them anywhere but 'a' comes before 'b'
In Access YES is a type of - ANS ✔✔Boolean
Four minutes and thirty-three seconds is - ANS ✔✔A musical composition without notes
In Access "456.0e-8" (including the quotes) is of type - ANS ✔✔character string
What's a table? - ANS ✔✔A set of records in which no two are identical, and a set of records all
of the same type
For maps, the word "scale" is - ANS ✔✔the ratio of distances on the map to distances in the real
world
