Sql Is An International Standard Language For Processing A Database
Question: The purpose of a database is to keep track of lists of data that involve a single theme.
Answer: False
Question: Structured Query Language (SQL) is an international standard language for processing a database.
Answer: True
Question: A data model describes data and relationships that will be stored in the database.
Answer: True
Question: A foreign key is essential in relational databases to represent the relationship between two tables.
Answer: True
Question: The general goal of normalization is to construct tables such that every table has a single topic or theme.
Answer: True
Question:
Answer: primary key
Question: Which of the following refers to the problem that exists in database applications when two users modify the same
data item, but only one of those changes is recorded?
update query problem
bullwhip effect
lost-update problem
crow’s-foot paradigm
Answer: lost-update problem
Question:
Answer: A relationship connects one attribute to another.
Question: What is true about the diagram below?
Phone is a primary key for the Adviser entity.
A department may not have any adviser.
An adviser does not need to belong to any department.
There exists a many-to-many relationship between Adviser and Student.
Answer: A department may not have any adviser.
Question: _________ is a program used to create, process, and administer a database.
DBMS
E-R data model
UML
Normalization
Answer: DBMS