Database Final - Exam 1 Questions

The creation of a database and its tables is a function of which component of the database system?a.DBMS b.Application c.Web server d.Database e.Users

A.DBMS

Which of the following is not one of the five SQL built in functions? MAX AVERAGE SUM AVG COUNT

AVERAGE

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS). True False

False

While the relational model for databases appears to hold much purpose, few commercial databases have implemented it. T/F

False

With the traditional filing processing approach, each application shares data files, thus enabling much data sharing.

False

Program data dependence is caused by: Data descriptions being stored on a server Data cohabiting with programs Data descriptions being written into programming code File descriptions being stored in each database application

File descriptions being stored in each database application

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

HAVING

The SDLC phase in which database processing programs are created is the ____ phase.

Implementation

In SQL, the IS NULL keyword can be used to select on records containing NULL values in a particular column.

True

In a 1:1 relationship, a single entity instance of one type is related to a single entity instance of the same or another type.T/F

True

One or more entities can be associated together in relationships.

True

To represent a relationship in the relational model, the primary key of one relation is placed into a second relation

True

Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character?

_

A departmental multi~tiered client/server database is stored on a central device called a: a.Server b.Network c.Remote PC d.Client

a. Server

Which of the following is an entity that exists independently of other entity types? a.Strong b.Variant c.Weak d. Codependent

a. Strong

Relational databases establish the relationships between entities by means of common fields included in a file called a(n): a) relation b) entity c) association d) relationship

a.relation

The number of entity classes involved in a relationship is known as the relationship's ____ Degree Minimum cardinality Ordinarily Class Maximum cardinality

degree

An attribute of an entity that is computed is a(n) Fuzzy attribute Derived attribute Optional attribute Composite attribute

derived attribute

A key must be unique True False

false

In the relational model, each row of a table contains data that represents an attribute of the entity True False

false

There is usually only one instance of an entity in an entity class True False

false

When used to represent a relationship, the primary key must have the same name as the corresponding foreign key. True False

false

Business policies and rules govern all of the following except: Updating data, Removing data, Creating data, Managing employees

managing employees

Data that describe the properties of other data are: Metadata, Relationships, Physical, Logical

metadata

The number of entity types that participate in a Unary relationship is One Zero Two Three

one

With the database approach, data descriptions are stored in a central location known as a: server PC Mainframe Repository

repository

Which of the following terms is synonymous with "tuple"? Field Row Relation Attribute Table

row

Which of the following terms is synonymous with "relation"? Record Attribute Table Row Tuple

table

A data model is a graphical system used to capture the nature and relationships among data.

true

A person is an example of an entity. True False

true

A possible problem with keeping data in files is that if you delete a row of data from a file, you may also delete some data items that you want to keep. True False

true

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of referential integrity constraint. True False

true

In SQL, the LIKE keyword can be used to select on partial values True False

true

Information is processed data True False

true

It is possible for an entity to have a relationship to itself. True False

true

Standard SQL does not allow built in functions to be used in a WHERE clause True False

true

A relationship between the instances of a single entity type is called a ____ relationship Primary Ternary Binary Unary

unary

Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column? WHERE hours = 10 and hours = 50 WHERE hours between 10 and 50 WHERE hours = min(10) and max(50) WHERE Hours RANGE 10 to 50 WHERE Hours IN [10,50]

where hours between 10 and 50

By separating data into tables containing data on only one time each, making changes to the data is simplified.

True

E.F. Codd developed the relational model in the:

1970s

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL select query? ORDER BY SORT DISTINCT UNIQUE REDUCE

DISTINCT

In the entity relationship data model, all instances of an entity of a given type are grouped into _____. Entity classes Class objects Entity attributes Identifiers Entity objects

Entity classes

Which SQL keyword can be used in conjunction wildcards to select partial values? SUBSTRING FIND SELECT SEARCH LIKE

LIKE

A database is an organized collection of ____ related data

Logically

A property or characteristic of an entity type that is of interest to the organization is called a(n) Relationship Cross function Attribute Coexisting entity

attribute

A _____ defines or constrains some aspect of the business.

business rule

Which of the following is NOT an advantage of database systems? a.Reduced program maintenance b.Better data quality c.Redundant data d.Program data independence

c. Redundant Data

Languages, menus, and other facilities by which users interact with the database are collectively called a(n): a. client b. development environment c. user interface d. icon

c. user interface

A ____ specifies the number of instances of one entity that can be associated with each instance of another entity Limit Degree Cardinality constraint Counter constraint

cardinality constraint

A rule that CANNOT be violated by database users is called a: Password View Constraint Program

constraint

A key that contains more than one attribute is called a(n) _____. a.Multi~key b.Complex key c.Multivalued key d.Composite key e.Candidate key

d. composite key

A graphical system used to capture the nature and relationships among data is called a(n): RAD Data model XML data model SDLC

data model

Which organizational function should set database standards? Database administration Management Technical services Application development

database administration

Microsoft SQL server is an example of a _____. Table Database Database management system List manager

database management system