In the relational model, the integrity rules that states that a foreign key must match a value in the home relation or be completely null is:

Question $1$ options:

entity integrity.

referential integrity.

domain integrity.

relational integrity.

Question $2(4$ points$)$

True or False? Database$-$as$-$a$-$Service $($DBaaS$)$ users do not need their own DBMS software.

Question $2$ options:

True

False

Question $3(4$ points$)$

Which of the following is not one of the basic elements in the ER model?

Question $3$ options:

Object

Entity

Attribute

Relationship

Question $4(4$ points$)$

In an EER diagram, a total specialization is indicated by:

Question $4$ options:

the letter t in the specialization circle.

a double line connecting the circle to the superclass.

a single line connecting the circle to the superclass.

a double arrow to the circle.

Question $5(4$ points$)$

In the ER model, if every member of an entity set must participate in a relationship, the participation is described as:

Question $5$ options:

complete.

total.

partial.

constrained.

Question $6(4$ points$)$

Which type of relational table constraint cannot be specified as a column$-$level constraint?

Question $6$ options:

Composite primary key

Uniqueness

Check

Default

Question $7(4$ points$)$

Which of the following is another term for the system data dictionary?

Question $7$ options:

ALL view

System catalog

DBA view

CONSTRAINTS

Question $8(4$ points$)$

If complex data types and methods are added to a relational model, we categorize it as:

Question $8$ options:

semantic.

object$-$oriented.

functional.

object$-$relational.

Question $9(4$ points$)$

True or False? Writing the commands to create a database structure is normally the responsibility of the database administrator.

Question $9$ options:

True

False

Question $10(4$ points$)$

All of the following are record$-$based models except:

Question $10$ options:

entity$-$relationship.

relational.

network.

hierarchical.

Question $11(4$ points$)$

Which of the following storage technologies first offered direct access to stored records?

Question $11$ options:

Paper tape

Magnetic tape

Magnetic disk

Punched cards

Question $12(4$ points$)$

The Census Bureau employee who proposed the use of punched cards for data storage was:

Question $12$ options:

Thomas Watson.

Thomas Edison.

John von Neumann.

Herman Hollerith.

Question $13(4$ points$)$

True or False? One solution to mapping unions to relations is to create a surrogate key that will be the primary key of the union.

Question $13$ options:

True

False

Question $14(4$ points$)$

True or False? Two relations are union compatible if they have the same degree and if their corresponding attributes have the same domain.

Question $14$ options:

True

False

Question $15(4$ points$)$

In the ER model, a key that consists of more than one attribute is described as:

Question $15$ options:

composite.

derived.

a superkey.

a foreign key.

Question $16(4$ points$)$

True or False? The relational algebra SELECT operator is a unary operator.

Question $16$ options:

True

False

Question $17(4$ points$)$

Information about the structure of database records and the logical connections between the data items and records is called:

Question $17$ options:

big data.

traffic data.

enterprise data.

metadata.

Question $18(4$ points$)$

True or False? A primary key can consist of more than one attribute.

Question $18$ options:

True

False

Question $19(4$ points$)$

Making adjustments to physical database structures in order to improve performance is called system:

Question $19$ options:

analysis.

prototyping.

tuning.

evolution.

Question $20(4$ points$)$

The central table in a star schema is called a:

Question $20$ options:

dimension table.

fact table.

logical table.

snowflake table.

Question $21(4$ points$)$

All of the following are potential advantages of using a database except:

Question $21$ options:

control of redundancy.

improved data integrity.

lower cost.

better data consistency.

Question $22(4$ points$)$

True or False? Once a database schema is created, its structure cannot be changed.

Question $22$ options:

True

False

Question $23(4$ points$)$

In the staged database design approach, in what order are the three models developed?

Question $23$ options:

Logical, conceptual, physical

Conceptual, physical, logical

Conceptual, logical$,$ physical

Physical, conceptual, logical

Question $24(4$ points$)$

Which of the following operators allows us to combine pieces of information about an entity that appear on separate relational tables?

Question $24$ options:

SELECT

PROJECT

NATURAL JOIN

UNION

Question $25(4$ points$)$

The organization for which the database is designed is referred to as:

Question $25$ options:

the universe of discourse.

the metadata.

the entity.

the enterprise.