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