Saint Leo COM506 Midterm Exam

/in /by

Question

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

$