CE 4347 Exam 1 Review

A Database System is: Collection of data describing one particular enterprise Collection of programs to access data Collection of interrelated data All of the above

All of the above

Data Manipulation Language enables users to Retrieval of information stored in database Insertion of new information into the database Deletion of information from the database All of the above

All of the above

File processing systems have important limitations Data is separated and isolated Data is often duplicated Application programs are dependent on file format All of the above None of the above

All of the above

The property / properties of a database is / are : It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records. Data stored in a database is independent of the application programs using it All of the above

All of the above

Which of the following is Database Language? Data Definition Language Data Manipulation Language Data Query Language All of the above

All of the above

To allow users to manipulate the information, the system has a number of Application programs Application files Manipulation program Manipulation files

Application programs

Domain constraints, functional dependency and referential integrity are special forms of _________. Foreign key Primary key Assertion Referential constraint

Assertion

A characteristic of an entity. Relation Attribute Parameter Constraint

Attribute

Data independence means Data is defined separately and not included in programs Programs are not dependent on the physical attributes of data. Programs are not dependent on the logical attributes of data Both (B) and (C)

Both (B) and (C)

Let R1(A, B, C, D) and R2(P, Q, R, S) be two relations in which A is the foreign key of R1 that refers to the primary key of R2. Which of the following operations causes the referential integrity constraint violation? insert into R1 Delete from R1 Insert into R2 Delete from R2 Both (a) and (d)

Both (a) and (d)

DBMS helps achieve Data independence Centralized control of data Neither A nor B Both A and B

Both A and B

Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible Both the statements are true Statement 1 is correct but Statement 2 is false Statement 1 is false but Statement 2 is correct Both the statements are false

Both the statements are true

Database processing programs: Call the DBMS to access the stored data Cannot be used in more than one process Require at least one dedicated workstation Present problems with storage space

Call the DBMS to access the stored data

The restrictions placed on the data. Relation Attribute Parameter Constraint

Constraint

Data Manipulation Language (DML) is not to Insertion of new information into the Database Modification of information in the Database Create information table in the Database Deletion of information in the Database

Create information table in the Database

Which of the following is not a level of data abstraction? View Level Physical Level Logical Level Critical Level

Critical Level

They design and implement the DBMS modules and interfaces as a software package Real-time and active database technology Data warehouses and online analytical processing (0LAP) DBMS system designers and implementors System protection

DBMS system designers and implementors

A type of data abstraction that is used to provide a conceptual representation Big data Data model Transaction Casual end users

Data model

Snapshot of the data in the database at a given instant of time is called Database Instance All of the options Database Schema Database Snapshot

Database Instance

Logical design of database is called All of the options Database Schema Database Instance Database Snapshot

Database Schema

_____ are considered database architects. Database administrators Systems administrators Database designers Systems analysts and programmers

Database designers

DBMS manages the interaction between __________ and database. System Analysts Compilers End Users Stake Holders

End Users

Which would most likely NOT be an entity on an ERM? Student Professor Class Enroll

Enroll

Which of the following in true regarding Referential Integrity? Every primary-key value must match a primary-key value in an associated table Every primary-key value must match a foreign-key value in an associated table Every foreign-key value must match a primary-key value in an associated table Every foreign-key value must match a foreign-key value in an associated table

Every foreign-key value must match a primary-key value in an associated table

In an entity called STUDENT, you might find attributes of PROFESSOR-ID, Last-Name, First-Name, and CLASSROOM. True False

False

With the traditional fi le processing approach, each application shares data files, thus enabling much data sharing. True False

False

Data redundancy and Data Inconsistency are one of the major drawbacks of File processing system File retrieval system File storage system File updating system

File processing system

Can store and analyze maps, weather data, and satellite images. Program - data Independence Geographic information systems (G I S) Operation interface Operators and maintenance personnel

Geographic information systems (G I S)

Which of the following is not involved in DBMS? End Users Data Application Request HTML

HTML

The actual content in the database at a particular point. Schema Attribute Parameter Instance

Instance

An entity: Is the association between two related processes Has cardinality (1:1, 1:N, or M:N) Shows if it can be null or no null Is a person, place or thing Is described with a verb phrase

Is a person, place or thing

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A. One-to-many One-to-one Many-to-many Many-to-one

Many-to-one

Which of the following in not a function of DBA? Network Maintenance Schema Definition Authorization for data access Routine Maintenance

Network Maintenance

Which of the following is a navigational data model model? Network Model Object oriented model E-R Model None of these

Network Model

The subset of a super key is a candidate key under what condition? No proper subset is a super key All subsets are super keys Subset is a super key Each subset is a super key

No proper subset is a super key

The subset of super key is a candidate key under what condition? No proper subset is a super key All subsets are super keys Subset is a super key Each subset is a super key

No proper subset is a super key

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A. This is called as One-to-many One-to-one Many-to-many Many-to-one

One-to-one

Which of the following can be a multivalued attribute? Phone_number Name Date_of_birth All of the mentioned

Phone_number

What is TRUE about Entity Integrity Constraints? Primary key values cannot be null according to the entity integrity constraint. Primary key values can be null according to the entity integrity constraint. Primary key values cannot be zero according to the entity integrity constraint. None of the above

Primary key values cannot be null according to the entity integrity constraint.

DBMS is a set of __________ to access the data. Codes Programs Information Metadata

Programs

Relationships among entities of the same type are called_______? IS-A relationships Recursive relationships HAS-A relationships None

Recursive relationships

A logical structure of the database. Schema Attribute Parameter Instance

Schema

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time. Instance Snapshot Both Instance and Snapshot All of the mentioned

Snapshot

It is better to use files than a DBMS when there are Stringent real-time requirements Multiple users wish to access the data Complex relationships among data All of the above

Stringent real-time requirements

Which of the following is a completeness constraint? Total specialization Partial generalization Total recall Partial hybridization

Total specialization

A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship. True False

True

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

True

An entity instance of a subtype represents the same entity instance of the supertype. True False

True

____ command can be used to modify a column in a table. alter update set create

alter

A "candidate key" is: any set of fields that determines the values of all other fields functionally dependent on non-key attributes an attribute or set of attributes that can be the primary key the primary key of a relation

an attribute or set of attributes that can be the primary key

The Tuples of the relations can be of ____ order. any same sorted constant

any

The property by which subtype entities possess the values of all attributes of a supertype is called: hierarchy reception. class management. multiple inheritance. attribute inheritance.

attribute inheritance.

Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________ transparent concrete elaborate cascade

cascade

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype. disjoint overlap completeness weak

completeness

An attribute that can be broken down into smaller parts is called a(n) ________attribute. associative simple composite complex

composite

A(n) ____ model is independent of both hardware and software. conceptual external developmental Physical

conceptual

A ____ focuses primarily on storing data used to generate information required to make tactical or strategic decisions. distributed database workgroup database data warehouse production database

data warehouse

The number of entity types that participate in a relationship is called the: number. identifying characteristic. degree. counter.

degree.

An attribute of an entity that is computed is a(n): optional attribute. composite attribute. derived attribute. fuzzy attribute.

derived attribute.

The ________ rule specifies that an entity can be a member of only one subtype at a time. exclusion disjoint removal inclusion

disjoint

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. disjointness constraint disjoint rule partial specialization total specialization

disjointness constraint

Customers, cars, and parts are examples of: entities. attributes. cardinals. relationships.

entities.

The process of defining a more general entity type from a set of more specialized entity types is called: generalization. specialization. normalization. extrapolation.

generalization.

The first step to building an Entity Relationship Diagram is to _____ Identify data flows from the level 0 DFD diagram draw the relationships between the entities identify the attributes for each entity identify the entities identify the processes, data flows and data stores

identify the entities

A(n) ________ is the relationship between a weak entity type and its owner. member chain identifying relationship jump path chain link

identifying relationship

A level that describes data stored in a database and the relationships among the data. physical logical user view

logical

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. optional unidirectional partial mandatory

mandatory

The number of entity types that participate in a Unary relationship is: zero. one. two. three.

one.

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. semi-specialization total specialization partial specialization disjointness

partial specialization

A level that describes how a record is stored. physical logical user view

physical

Data ____ exists when the same data are stored unnecessarily at different places. dependency redundancy inconsistency fragmentation

redundancy

A ......... is used to define the overall design of the database schema application program data definition language code

schema

The most common types of entities are: strong entities. weak entities. associative entities. smush entities.

strong entities.

The set of entities in a union (category) class is subset of the intersection of all its superclasses subset of the union of all its superclasses do not belong to any of its superclasses all of the above

subset of the union of all its superclasses

An attribute of the supertype that determines the target subtype(s) is called the: determinant. subtype decision. disjoint indicator. subtype discriminator.

subtype discriminator.

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________in the hierarchy. subtypes supertypes constraints dimensions

supertypes

The hierarchical database model is based on a ____. tree structure lack of a parent segment lack of a child segment matrix

tree structure

Which of the following isn't a level of abstraction? physical logical user view

user

The ______level helps application programs hide the details of data types. physical logical user view

view

An entity type whose existence depends on another entity type is called a________ entity. strong weak codependent variant

weak