Question 1

The different classes of relations created by the technique for preventing modification anomalies are called:
A)normal forms.
B)referential integrity constraints.
C)functional dependencies.
D)None of the above is correct.

Accepted Answer

Normal forms are used in database normalization to reduce redundancy and prevent modification anomalies by organizing fields and table of a database to ensure their dependencies are properly enforced.

Question 2

The primary key is selected from the:
A)composite keys.
B)determinants.
C)candidate keys.
D)foreign keys.

Accepted Answer

The primary key is selected from the candidate keys. Candidate keys are those keys that can uniquely identify each row in a table. Among the candidate keys, one is chosen as the primary key.

Question 3

In the relational model, relationships between relations or tables are created by using:
A)composite keys.
B)determinants.
C)candidate keys.
D)foreign keys.

Accepted Answer

Foreign keys are used in the relational model to establish relationships between tables. They are a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table, thus creating a link between the two tables.

Question 4

A relation is considered a:
A)Column.
B)one-dimensional table.
C)two-dimensional table.
D)three-dimensional table.

Accepted Answer

A relation in database terminology is considered a two-dimensional table, where data is organized in rows and columns.

Question 5

For some relations, changing the data can have undesirable consequences called:
A)referential integrity constraints.
B)modification anomalies.
C)normal forms.
D)transitive dependencies.

Accepted Answer

Modification anomalies occur when changes to data (insertions, updates, or deletions) in a database lead to unintended consequences due to the way the data is organized, often indicating a need for normalization to reduce redundancy and improve data integrity.

Question 6

If attribute A determines both attributes B and C, then it is also true that:
A)A ? B.
B)B ? A.
C)C ? A.
D)(B,C) ? A.

Accepted Answer

The answer of If attribute A determines both attributes B...

Question 7

One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme.
A)change the theme.
B)create a new theme.
C)add a composite key.
D)none

Accepted Answer

The answer of One solution to the multivalued dependency constraint...

Question 8

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
A)transitive dependency.
B)insertion anomaly.
C)referential integrity constraint.
D)normal form.

Accepted Answer

Referential integrity constraint ensures that a foreign key value always points to an existing row in another table, maintaining the consistency and integrity of the data across tables.

Question 9

Who developed SEQUEL?
A)Dr. E.F. Codd
B)Chris Date
C)Chamberlin

Accepted Answer

SEQUEL, which stands for Structured English Query Language, was developed by Donald D. Chamberlin and Raymond F. Boyce at IBM in the early 1970s. It later evolved into SQL (Structured Query Language), the standard language for relational database management systems.

Question 10

Which of the following is used to get all the columns of a table ?
A)*
B)@
C)%
D)#

Accepted Answer

The asterisk (*) symbol is used in SQL to select all columns from a table.

Question 11

The first commercial RDBMS is:
A)INGRESS
B)DB2
C)ORACLE
D)None of these.

Accepted Answer

INGRESS was the first commercial RDBMS.

Question 12

Which of the following is not a DCL statement?
A)Rollback
B)Grant
C)Revoke
D)None of these

Accepted Answer

Rollback is a DML statement, not a DCL statement.

Question 13

Which of the following is the result of a select statement?
A)Trigger
B)Index
C)Table
D)None of these

Accepted Answer

A select statement in SQL is used to query or select data from a database, and it returns the data in the form of a table.

Question 14

Which of the following clause specifies the table or tables from where the data has to be retrieved?
A)Where
B)Table
C)From
D)None of these

Accepted Answer

The "FROM" clause specifies the table or tables from where the data has to be retrieved in SQL queries.

Question 15

How many tables can be joined to create a view?
A)1
B)2
C)Database dependent
D)None of these

Accepted Answer

The answer of How many tables can be joined to...

Question 16

Which of the following can be used to get those items that fall within a range?
A)IN
B)BETWEEN
C)DISTINCT
D)LIKE

Accepted Answer

The answer of Which of the following can be used...

Question 17

Which of the following constitutes a basic set of operations for manipulating relational data?
A)Predicate calculus
B)Relational algebra
C)Relational calculus
D)None of the above

Accepted Answer

Relational algebra is a set of operations that can be used to manipulate relational data. These operations include select, project, join, and union.

Question 18

Which of the following is not a relational algebraic operation that is not form the set theory?
A)UNION
B)INTERSECTION
C)CARTESIAN PRODUCT
D)SELECT

Accepted Answer

Select is not a set theory operation; it is specific to relational algebra, used to choose rows from a table that meet certain criteria. Union, Intersection, and Cartesian Product are all operations derived from set theory.

Question 19

Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?
A)SELECT
B)UNION
C)JOIN
D)PROJECT

Accepted Answer

UNION is a set operation that is not developed specifically for relational databases; it is a standard operation in set theory used to combine the elements of two sets. The other options, SELECT, JOIN, and PROJECT, are operations developed specifically for manipulating and querying data in relational databases.

Question 20

Which is the symbol used to denote the SELECT operation?
A)Sigma
B)Rho
C)Pi
D)None of the above

Accepted Answer

Sigma is used to denote the SELECT operation.

Quiz 4: Database Management System: Relational Model and Operations

The different classes of relations created by the technique for preventing modification anomalies are called:

The primary key is selected from the:

In the relational model, relationships between relations or tables are created by using:

A relation is considered a:

For some relations, changing the data can have undesirable consequences called:

If attribute A determines both attributes B and C, then it is also true that:

One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme.

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n) :

Who developed SEQUEL?

Which of the following is used to get all the columns of a table ?

The first commercial RDBMS is:

Which of the following is not a DCL statement?

Which of the following is the result of a select statement?

Which of the following clause specifies the table or tables from where the data has to be retrieved?

How many tables can be joined to create a view?

Which of the following can be used to get those items that fall within a range?

Which of the following constitutes a basic set of operations for manipulating relational data?

Which of the following is not a relational algebraic operation that is not form the set theory?

Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?

Which is the symbol used to denote the SELECT operation?