Database management Questions and Answers
2024
A foreign key imposes a specific kind of integrity to related tables. What is the name of
this integrity? *** Referential
What the benefits associated with database technology? *** Data sharing, data
integration, and data independence
Which of the following provides the low-level view of the database? *** The internal-
level schema
Which of the following cannot be blank (null)? *** primary key
In an inventory management system for a retail chain, each product can be available at
multiple stores, and each store stocks a variety of products. How should the database
be designed to accurately reflect the relationship between stores and products ***
Create separate tables for stores and products, with a third table that pairs store IDs
and product IDs, reflecting which stores carry which products at any given time
Which of the following are requirements of a relational data base *** All of the above
When a non-null value for the primary key indicates that a specific object exists and can
be identified by reference to its primary key value, it is referred to as *** entity integrity
rule
An entity is something about which information is stored. What is the term for the
characteristics of interest that are stored about an entity of employee such as pay rate
or an address? *** Attribute
Which of the following would be identified as a table *** All inventory records
A customer's name would be a *** Field
The data view that shows how the user or programmer conceptually organizes and
understands the data is the *** Logical view
In a sales table the most likely primary key would be *** Sales invoice ID
In an inventory table, the most likely non-key columns would be *** Color and price
In the books table, the most likely primary key would be *** Book ID
, In the Order Info table, select all attributes that act as foreign keys *** Customer ID
and Book ID
A data dictionary contains information about the structure of the database *** True
The primary difference between the conceptual and external schema is that the external
is an organization-wide view of the entire database *** False
Is it possible that two or more attributes can form a single primary key *** True
A foreign key is an attribute that is primary key in another table *** True
The central organizing tenant of the file-oriented approach is to store data related to ***
A specific program
Which of the following statements about database systems is (are) true? ***
Encourages data sharing, provides data independence, minimizes data redundancy
The logical view of data is *** How people organize, view, and understand
relationships among data items
Which of the following at access rights that can be granted in a subschema *** Create,
read, update, and delete
External level schemas *** Are where rights are set for individual users
The text mentions four guidelines for developing a properly structured relational
database. Which of the following is not on these guidelines? *** Each object identified
by the primary key must have at least three non-key attributes
The referential integrity *** Foreign key must have values that correspond the value of
a primary key in another table
An update anomaly can occur if *** an instance of the same data is stored in two or
more places in the database.
One of the benefits of using a database is to allow an organization to change its data in
one location without concern of affecting its data in another location. This benefit is
called *** Data independence
The relational data model portrays data as being stored in *** Tables
Mary Grossman has been selling cupcakes for the past few years. She keeps
meticulous record of every cupcake that she has ever made and sold. She has also
kept records of customer's comments on all her cupcakes. These have been entered in
a computerized accounting information. Mary is considered rebranding her cupcake
2024
A foreign key imposes a specific kind of integrity to related tables. What is the name of
this integrity? *** Referential
What the benefits associated with database technology? *** Data sharing, data
integration, and data independence
Which of the following provides the low-level view of the database? *** The internal-
level schema
Which of the following cannot be blank (null)? *** primary key
In an inventory management system for a retail chain, each product can be available at
multiple stores, and each store stocks a variety of products. How should the database
be designed to accurately reflect the relationship between stores and products ***
Create separate tables for stores and products, with a third table that pairs store IDs
and product IDs, reflecting which stores carry which products at any given time
Which of the following are requirements of a relational data base *** All of the above
When a non-null value for the primary key indicates that a specific object exists and can
be identified by reference to its primary key value, it is referred to as *** entity integrity
rule
An entity is something about which information is stored. What is the term for the
characteristics of interest that are stored about an entity of employee such as pay rate
or an address? *** Attribute
Which of the following would be identified as a table *** All inventory records
A customer's name would be a *** Field
The data view that shows how the user or programmer conceptually organizes and
understands the data is the *** Logical view
In a sales table the most likely primary key would be *** Sales invoice ID
In an inventory table, the most likely non-key columns would be *** Color and price
In the books table, the most likely primary key would be *** Book ID
, In the Order Info table, select all attributes that act as foreign keys *** Customer ID
and Book ID
A data dictionary contains information about the structure of the database *** True
The primary difference between the conceptual and external schema is that the external
is an organization-wide view of the entire database *** False
Is it possible that two or more attributes can form a single primary key *** True
A foreign key is an attribute that is primary key in another table *** True
The central organizing tenant of the file-oriented approach is to store data related to ***
A specific program
Which of the following statements about database systems is (are) true? ***
Encourages data sharing, provides data independence, minimizes data redundancy
The logical view of data is *** How people organize, view, and understand
relationships among data items
Which of the following at access rights that can be granted in a subschema *** Create,
read, update, and delete
External level schemas *** Are where rights are set for individual users
The text mentions four guidelines for developing a properly structured relational
database. Which of the following is not on these guidelines? *** Each object identified
by the primary key must have at least three non-key attributes
The referential integrity *** Foreign key must have values that correspond the value of
a primary key in another table
An update anomaly can occur if *** an instance of the same data is stored in two or
more places in the database.
One of the benefits of using a database is to allow an organization to change its data in
one location without concern of affecting its data in another location. This benefit is
called *** Data independence
The relational data model portrays data as being stored in *** Tables
Mary Grossman has been selling cupcakes for the past few years. She keeps
meticulous record of every cupcake that she has ever made and sold. She has also
kept records of customer's comments on all her cupcakes. These have been entered in
a computerized accounting information. Mary is considered rebranding her cupcake
