Database Quiz 1, 2, & 3

A Data Mart is a place that companies can use to purchase external data

False

If a data value is null, then it is 0

False

If a relation's key has more than one column, we say the key is integrated

False

In the database approach to information systems, for small systems sometimes the application can read the data directly without the DBMS

False

Knowledge about databases and how they function is only required for technical careers

False

Only very large and complex databases are required to have a schema

False

The attributes and relationships associated with a particular entity will be somewhat similar across databases

False

The most common career for technicians with database skills is Database Administrator

False

The primary purpose of a Data Warehouse is simply to store, or archive, massive amounts of data

False

The rule that says no key column value may be null is called referential integrity

False

The DBMS itself resides on local computers in which architecture?

File Server Architecture

Which type of architecture will require the most amount of network bandwidth to process queries?

File Server Architecture

The normalization rule that every attribute value must be atomic is called

First Normal Form

A 3NF relation with no multi-valued dependencies is in

Fourth Normal Form

A massively large database that contains current facts about all kinds of world activities is called

Freebase

A normalization rule that says one column's value determines another column's value is called

Functional Dependency

The kind of database that is used for day-to-day business operations is called

Online Transaction Processing

The _________ is the industry standard language used to manipulate data in a relational database

Structured Query Language

If every attribute in a key of a relation is a determinant, then the relation conforms to

Third Normal Form

To eliminate duplicate values, you put into the Select clause the key word:

Distinct

The rule that says no key column value may be null is called

Entity Integrity

A system that is used to support the daily activities of a business is called a

Transaction Processing System

The DBMS sits between the application software and the database

True

Information can be defined as facts that

can be labeled and belong to a context

In the relational model, a possible unique row identifier is called

candidate key

If a relation's key has more than one column, we say the key is

composite

In the relational model, a column that connects a table to another table is called

foreign key

In addition to design issues of very large public databases, another important issue in their development is

how to populate the database with large amounts of data

If a data value is null, then it

may not apply

The three major characteristics of today's society that are impacted by databases include:

persuasive connectivity, universal mobility, and abundant information

In standard relational notation, underlines column names identify the ______ of the relation

primary key

A foreign key that references its own table is called

recursive

The structure and organization of a database is defined by its

schema

In standard relational notation, a comma-separated list of names identifies

the attributes

The column on the left side of a functional dependency is called

the determinant

The first column listed in the Order By clause is

the primary sort key

The primary contributor to the availability of all kinds of information is:

Databse Technology

The SQL statement used to take rows out of a table is

Delete

The From clause can contain a second name for a table called

Alias

If the entities are defined as rows in the database, the individual pieces of information about each entity are called

Attributes

What are two of the most important piece of information stored in a database about an entity?

Attributes and Relationships

Which is NOT one of the responsibilities of a DBMS? A) Execute stored procedures B) Display Query results C) Execute queries D) Define the data

B

Which of the following systems is best described as a TPS System A) Stock Market Price Tracking System B)Google Analytics C)Point of Sale System D) Sales & Market Analysis System

C

An analysis technique to extract and analyze information from massive databases is called

Data Mining

Which of the following is best described as an MIS system> A) QuickBooks Accounting System B)Shipping system C) Point of Sale System D) Google Analytics

D

The SQL statement used to enter new rows into a table is

Insert

* in an SQL select statement means:

List all columns

The rule that says a foreign key must be null or have an actual key value is called

Referential Integrity

If a relation has multiple attributes for the key and only a portion of the key is a determinant of other attributes, then the relation violates

Second Normal Form

In the relational model, a column is called an attribute

True

In the relational model, a row in a table is called a tuple

True

Month in Month(SaleDate) is a function that returns the name of the month in the date

True

In a relational model, a table is called

a relation

In the relational model, a record is called

a tuple

In the relational model, a field is called

an attribute

A unique row identifier that has meaning in the world outside the computer system is called

an external key

An internally generated value that is unique to a row in a table is called

an object identifier