Question 1

The __________ holds a database of
domain names and their respective IP addresses.

Question 1 options:

SQL

DNS

OS

HPPT

Question 2

A(n) __________ key is a field
with values that are not chosen as a primary key, but can be used in cases
where the primary key is not available.

Question 2 options:

composite

alternate

relational

control

Question 3

The __________ relationship is the
ideal type of relationship within a relational database schema.

Question 3 options:

many-to-one

one-to-one

many-to-many

one-to-many

Question 4

__________ consistency refers to
the accuracy and reliability of data within a database.

Question 4 options:

Object

Backup

Read

Store

Question 5

True or False?

Corporations use only structured
data.

Question 5 options:

True

False

Question 6

A(n) __________ is an application
that acts as the interface for the Internet, providing a way for people to
interact with and view pages on the World Wide Web.

Question 6 options:

DNS

HTTP

Web browser

Web server

Question 7

True or False?

An operational database is
sometimes referred to as an enterprise database.

Question 7 options:

True

False

Question 8

A __________ database is a storage
model in which common entities are stored within separate tables that use
unique key identifiers to build relationships among these entities.

Question 8 options:

network

relational

hierarchical

flat

Question 9

A(n) __________ model is a
two-dimensional list of data entries, where all data within a field are
understood to be similar, and all data within a record are understood to be
related to one another.

Question 9 options:

object

flat

relational

network

Question 10

True or False?

Data anomaly is defined as the
condition in which all of the data in the database are consistent with the
real-world events and conditions.

Question 10 options:

True

False

Question 11

Which of the following is true of
NoSQL databases?

Question 11 options:

They do not support distributed
database architectures.

They do not support very large
amounts of sparse data.

They are not based on the
relational model.

They are geared toward transaction
consistency rather than performance

Question 12

__________ logic, used extensively
in mathematics, provides a framework in which an assertion (statement of fact)
can be verified as either true or false.

Question 12 options:

Predicate

Index

Relational

Database

Question 13

NoSQL databases __________.

Question 13 options:

provide fault tolerance

are geared toward transaction
consistency, not performance

are based on the relational model

support only small amounts of
sparse data

Question 14

In the relational model,
__________are important because they are used to ensure that each row in a
table is uniquely identifiable.

Question 14 options:

logical structures

indexes

keys

relations

Question 15

Which of the following is a
disadvantage of the hierarchical data model?

Question 15 options:

It does not promote data sharing.

It does not have standards.

It does not promote data
integrity.

It is not efficient with 1:M
relationships.

Question 16

True or False?

As rare as 1:1 relationships
should be, certain conditions absolutely require their use.

Question 16 options:

True

False

Question 17

True or False?

The DIVIDE operation uses one
single¬column table (e.g., column “a”) as the divisor and one two-column table
(e.g., columns “a” and “b”) as the dividend.

Question 17 options:

True

False

Question 18

The __________ data model uses the
concept of inheritance.

Question 18 options:

entity relationship

object-oriented

relational

network

Question 19

Which of the following types of
HDFS nodes stores all the metadata about a file system?

Question 19 options:

Map node

Data node

Client node

Name node

Question 20

A(n) __________enables a database
administrator to describe schema components.

Question 20 options:

unified modeling language (UML)

query language

extensible markup language (XML)

data definition language (DDL)

Question 21

To generate a surrogate key,
Microsoft Access uses a(n) __________ data type.

Question 21 options:

character

AutoNumber

identity

sequence

Question 22

A(n) __________ exists when there
are functional dependencies such that XY is functionally dependent on WZ, X is
functionally dependent on W, and XY is the primary key.

Question 22 options:

transitive dependency

atomic attribute

partial dependency

repeating group

Question 23

True or False?

In implementation terms, an entity
is existence-dependent if it has a mandatory primary key.

Question 23 options:

True

False

Question 24

A table where every determinant is
a candidate key is said to be in __________.

Question 24 options:

BCNF

1NF

4NF

2NF

Question 25

True or False?

The existence of a mandatory
relationship indicates that the minimum cardinality is 0 or 1 for the mandatory
entity.

Question 25 options:

True

False

Question 26

An atomic attribute __________.

Question 26 options:

displays multiplicity

is always chosen to be a foreign
key

cannot exist in a relational table

cannot be further subdivided

Question 27

True or False?

Unary relationships are common in
manufacturing industries.

Question 27 options:

True

False

Question 28

True or False?

The process of database design is
a sequential process.

Question 28 options:

True

False

Question 29

True or False?

To implement a small database, a
database designer must know the “1” and the “M” sides of each relationship and
whether the relationships are mandatory or optional.

Question 29 options:

True

False

Question 30

True or False?

In Chen notation, there is no way
to represent cardinality.

Question 30 options:

True

False

Question 31

True or False?

To list the contents of a table,
you must use the DISPLAY command.

Question 31 options:

True

False

Question 32

True or False?

Although SQL commands can be
grouped together on a single line, complex command sequences are best shown on
separate lines, with space between the SQL command and the command’s
components.

Question 32 options:

True

False

Question 33

True or False?

Mathematical operators cannot be
used to place restrictions on character-based attributes.

Question 33 options:

True

False

Question 34

True or False?

ANSI-standard SQL allows the use
of special operators in conjunction with the WHERE clause.

Question 34 options:

True

False

Question 35

Which of the following is the
syntax for the UNION query?

Question 35 options:

query + query

UNION: query query

query UNION query

UNION (query, query)

Question 36

Which of the following is a
statement in SQL that combines rows from two queries and returns only the rows
that appear in the first set but not in the second?

Question 36 options:

UNION ALL

MINUS

UNION

INTERSECT

Question 37

True or False?

You cannot insert a row containing
a null attribute value using SQL.

Question 37 options:

True

False

Question 38

__________ is a string function
that returns the number of characters in a string value.

Question 38 options:

LENGTH

CONCAT

UCASE

SUBSTRING

Question 39

True or False?

Any changes made to the contents
of a table are not physically d on disk until you use the <table name> command.

Question 39 options:

True

False

Question 40

When using the Oracle TO_NUMBER
function to convert a character string into a number, __________ represents a
digit.

Question 40 options:

0

#

9

$