OIM 471 EXAM 2 QUESTIONS WITH
ANSWERS 100% CORRECT
The primary purpose of a database is ______ - ANSWER to keep track of
things
____________ is a standardized language for querying databases -
ANSWER SQL
The purpose of a database is to ___________. - ANSWER keep track of
things
Which is an example of a database? - ANSWER A cellphone contact list
Who knows if a database needs to be updated or changed? - ANSWER
The user
__________ is an international standard language for database
development and querying - ANSWER SQL
What type of software tracks very large amounts of related data? -
ANSWER Database
Two tables in a database contain a common field, say StudentID. This field
is the primary key of the Student table and is a non-key field in the
OFFICE_VISIT table. Which of the following elements of the definition of a
database does this illustrate? - ANSWER Relationships among rows
A database includes __________, which is data within itself that describes
its contents - ANSWER metadata
Another word for field is ________. - ANSWER column
, Which best describes the purpose of a primary key? - ANSWER A unique
identifier
Which of the following is an example of metadata? - ANSWER The data
type of a field
A database consists of the following components - ANSWER Tables
+
Relationships+
Metadata
A ____________ is a self-describing collection of integrated records -
ANSWER database
The columns in a database are also called ________. - ANSWER fields
The records in a database table are generally visualized as ________. -
ANSWER rows
Every record in a table in a database must have a ____________, which is
a column or group of columns that identifies a unique record in the table -
ANSWER primary key
Relational databases store data in the tables of columns and rows by
placing the primary key in another table where it becomes a
____________. - ANSWER foreign key
The data in a database management system that identifies the structure of
the database including names of tables, fields in each table, and the
properties of each of the fields, as well as which fields are primary and
foreign keys, etc., is called ____________. - ANSWER metadata
In a database of telephone customers, which would be the best primary
key? - ANSWER The account number for each customer
A __________ is another name for a database table. - ANSWER file
A ____________ or file includes a group of similar rows or records that
represent a single theme - ANSWER table
ANSWERS 100% CORRECT
The primary purpose of a database is ______ - ANSWER to keep track of
things
____________ is a standardized language for querying databases -
ANSWER SQL
The purpose of a database is to ___________. - ANSWER keep track of
things
Which is an example of a database? - ANSWER A cellphone contact list
Who knows if a database needs to be updated or changed? - ANSWER
The user
__________ is an international standard language for database
development and querying - ANSWER SQL
What type of software tracks very large amounts of related data? -
ANSWER Database
Two tables in a database contain a common field, say StudentID. This field
is the primary key of the Student table and is a non-key field in the
OFFICE_VISIT table. Which of the following elements of the definition of a
database does this illustrate? - ANSWER Relationships among rows
A database includes __________, which is data within itself that describes
its contents - ANSWER metadata
Another word for field is ________. - ANSWER column
, Which best describes the purpose of a primary key? - ANSWER A unique
identifier
Which of the following is an example of metadata? - ANSWER The data
type of a field
A database consists of the following components - ANSWER Tables
+
Relationships+
Metadata
A ____________ is a self-describing collection of integrated records -
ANSWER database
The columns in a database are also called ________. - ANSWER fields
The records in a database table are generally visualized as ________. -
ANSWER rows
Every record in a table in a database must have a ____________, which is
a column or group of columns that identifies a unique record in the table -
ANSWER primary key
Relational databases store data in the tables of columns and rows by
placing the primary key in another table where it becomes a
____________. - ANSWER foreign key
The data in a database management system that identifies the structure of
the database including names of tables, fields in each table, and the
properties of each of the fields, as well as which fields are primary and
foreign keys, etc., is called ____________. - ANSWER metadata
In a database of telephone customers, which would be the best primary
key? - ANSWER The account number for each customer
A __________ is another name for a database table. - ANSWER file
A ____________ or file includes a group of similar rows or records that
represent a single theme - ANSWER table
