ITE 152 EXAM 3 |QUESTIONS AND ANSWERS|
VERIFIED AND WELL DETAILED ANSWERS| ALREADY
GRADED A+| LATEST UPDATE
Which field could serve as the primary key for a list of students in your school? -
(ANSWER)Student ID number
A field's data type determines what kind of information can be stored there. -
(ANSWER)True
Dana is creating a table that will show books for sale on a bookstore's website.
Which field in the table would best serve as its primary key? -
(ANSWER)ProductID
All the pet names in a veterinarian's database are stored in a _______ called
PetName. - (ANSWER)Field
Which of the following is a way to sort data? - (ANSWER)All of the above
(Alphabetically, Numerically, Chronologically)
What does SQL stand for? - (ANSWER)Structured Query Language
What is a query? - (ANSWER)A question you ask a database
What are the columns in a Microsoft Access table called? - (ANSWER)Fields
, In a record, each separate piece of data, such as a last name, a first name, or an
address, is called a _____________. - (ANSWER)Field
Which data type would be best suited to a field that lists a product's clearance
price? - (ANSWER)Currency
A query lets you speed up the browsing process by finding information that
matches specifically to your criteria. - (ANSWER)True
What are the different views to display a table? - (ANSWER)All of the above
(Pivot Table & Pivot Chart View, Datasheet View, Design View)
Databases typically store their data in one big table. - (ANSWER)False
Kian needs to sort a list of patients by birthdate to show the oldest patients first.
What sort order on the birthdate field will give him this result? -
(ANSWER)Smallest to largest
In a database, each _________________ contains a collection of related data. -
(ANSWER)Table (?)
A database is an organized collection of information. - (ANSWER)True
VERIFIED AND WELL DETAILED ANSWERS| ALREADY
GRADED A+| LATEST UPDATE
Which field could serve as the primary key for a list of students in your school? -
(ANSWER)Student ID number
A field's data type determines what kind of information can be stored there. -
(ANSWER)True
Dana is creating a table that will show books for sale on a bookstore's website.
Which field in the table would best serve as its primary key? -
(ANSWER)ProductID
All the pet names in a veterinarian's database are stored in a _______ called
PetName. - (ANSWER)Field
Which of the following is a way to sort data? - (ANSWER)All of the above
(Alphabetically, Numerically, Chronologically)
What does SQL stand for? - (ANSWER)Structured Query Language
What is a query? - (ANSWER)A question you ask a database
What are the columns in a Microsoft Access table called? - (ANSWER)Fields
, In a record, each separate piece of data, such as a last name, a first name, or an
address, is called a _____________. - (ANSWER)Field
Which data type would be best suited to a field that lists a product's clearance
price? - (ANSWER)Currency
A query lets you speed up the browsing process by finding information that
matches specifically to your criteria. - (ANSWER)True
What are the different views to display a table? - (ANSWER)All of the above
(Pivot Table & Pivot Chart View, Datasheet View, Design View)
Databases typically store their data in one big table. - (ANSWER)False
Kian needs to sort a list of patients by birthdate to show the oldest patients first.
What sort order on the birthdate field will give him this result? -
(ANSWER)Smallest to largest
In a database, each _________________ contains a collection of related data. -
(ANSWER)Table (?)
A database is an organized collection of information. - (ANSWER)True
