Question 1

What is the component of a DBMS that is responsible for storing, retrieving, and updating data?

Accepted Answer

Database Engine

Question 2

The logical representation of an organization\'s data is called a(n):

Accepted Answer

Entity-relationship model

Question 3

A(n) _____ is the relationship between a weak entity type and its owner.

Accepted Answer

identify relationship

Question 4

The common types of entitites are

Accepted Answer

strong, associative, weak entities.

Question 5

An entity type whose existence depends on another entity type is called a ___   entity.

Accepted Answer

weak

Question 6

Which of the following is an entity type on which a strong entity depends?

Accepted Answer

Attribute

Question 7

In an E-R diagram, there are ____ business rule(s) for every relationship.

Accepted Answer

two

Question 8

Customers, cars, and parts are examples of

Accepted Answer

entities

Question 9

A person\'s name, birthday, and social security number are all examples of:

Accepted Answer

attributes

Question 10

A business rule:

Accepted Answer

defines or constrains some aspect of the business. asserts business structure. controls or influences the behavior of the business.

Question 11

An attribute that can be broken down into smaller parts is called a(n) ____ attribute

Accepted Answer

composite

Question 12

An attribute that must have a value for every entity (or relationship) instance is a(n):

Accepted Answer

required attribute

Question 13

An entity type name should be all of the following EXCEPT:

Accepted Answer

as short as possible.

Question 14

A property or characteristic of an entity type that is of interest to the organization is called a(n):

Accepted Answer

attribute

Question 15

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n)

Accepted Answer

composite identifier

Question 16

The following figure shows an example of:

Accepted Answer

a composite attribute.

Question 17

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):

Accepted Answer

associative entity

Question 18

A ______ specifies the number of instances of one entity that can be associated with each instance of another entity.

Accepted Answer

cardinality constraint

Question 19

A simultaneous relationship among the instances of three entity types is called a(n) ____ relationship

Accepted Answer

ternary

Question 20

in the figure shown below, which of the following is true ?

Accepted Answer

A person can marry at most one person

Question 21

In the following diagram, what type of relationship is depicted ?

Accepted Answer

Ternary

Question 22

A relationship is where the minimum and maximum cardinality are both one is a(n) ____

Accepted Answer

mandatory one

Question 23

For the relationship represented in the figure below, which of the following is true?

Accepted Answer

A department can have more than one employee.

Question 24

In the following diagram, which answer is true?

Accepted Answer

Each employee can supervise one to many employees.

Question 25

In the figure shown below, which of the following business rules would apply?

Accepted Answer

Each vendor can supply many parts to any number of warehouses, but need not supply any parts

Question 26

Because applications are often developed independently in file processing systems:

Accepted Answer

unplanned duplicate data files are the rule rather than the exception.

Question 27

One disadvantage of file processing systems is:

Accepted Answer

limited data sharing.

Question 28

28) Which of the following types of data can be stored in a database?

Accepted Answer

A) Voice B) Letters C) Numbers

Question 29

A database is an organized collection of _____ related data

Accepted Answer

logically

Question 30

In the following diagram, which of the answers below is true?

Accepted Answer

Both A and C

Question 31

31) A graphical system used to capture the nature and relationships among data is called a(n):

Accepted Answer

data model.

Question 32

A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):

Accepted Answer

entity

Question 33

A user view is:

Accepted Answer

a logical description of some portion of the database.

Question 34

The traditional methodology used to develop, maintain and replace information systems is called the:

Accepted Answer

Systems Development Life Cycle.

Question 35

Which of the following is NOT an advantage of database systems?

Accepted Answer

Redundant data

Question 36

A rule that CANNOT be violated by database users is called a:

Accepted Answer

constraint

Question 37

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ___ phase.

Accepted Answer

analysis

Question 38

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

Accepted Answer

implementation

Question 39

Which of the following are properties of relations?

Accepted Answer

A) Each attribute has a unique name. B) No two rows in a relation are identical. C) There are no multivalued attributes in a relation.

Question 40

40) The SDLC phase in which the detailed conceptual data model is created is the ___ phase.

Accepted Answer

analysis

Question 41

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Accepted Answer

foreign key

Question 42

A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:

Accepted Answer

phyical

Question 43

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Accepted Answer

key match rule.

Question 44

In the SQL language, the _____ statement is used to make table definitions.

Accepted Answer

create table

Question 45

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n): .

Accepted Answer

outer join

Question 46

The outer join syntax does not apply easily to a join condition of more than tables.

Accepted Answer

Two

Question 47

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

Accepted Answer

Natural Join

Question 48

____ takes a value of true if a subquery returns an intermediate results table which contains one or more rows.

Accepted Answer

EXISTS

Question 49

49) A functional dependency between two or more nonkey attributes is called a:

Accepted Answer

transitive dependency.

Question 50

50) What does the following SQL command do?   insert into Customer_T values (001,7ohn Smith\',\'231 West StrBoston\',\'MAI;021151);

Accepted Answer

Adds a new record to the Customer_T

Question 51

Designing physical files requires ________ of where and when data are used in various ways.

Accepted Answer

descriptions

Question 52

In which type of file is multiple key retrieval not possible?

Accepted Answer

Hashed

Question 53

Which of the following is a component of processing logic?

Accepted Answer

Business Rules

Question 54

All of the following are common denormalization opportunities EXCEPT:

Accepted Answer

a one-to-many relationship.

Question 55

A domain definition consists of the following components EXCEPT:

Accepted Answer

integrity constraints.

Question 56

Database access frequencies are estimated from

Accepted Answer

transaction volumes.

Question 57

A disadvantage of partitioning is:

Accepted Answer

extra space and update time.

Question 58

A requirement to begin designing physical files and databases is:

Accepted Answer

A) technology descriptions. B) normalized relations.  C) definitions of each attribute.

Question 59

An index on columns from two or more tables that come from the same domain of values is called a:

Accepted Answer

join index

Question 60

In most cases the goal of ________ dominates the design process.

Accepted Answer

efficient data processing

Question 61

Which type of file is most efficient with storage space?

Accepted Answer

Sequential

Question 62

A method to allow adjacent secondary memory space to contain rows from several tables is called:

Accepted Answer

clustering

Question 63

________ partitioning distributes the columns of a table into several separate physical records.

Accepted Answer

Vertical

Question 64

Which of the following anomalies result from a transitive dependency?

Accepted Answer

A) Deletion B) Insertion C) Modification

Essay On Database – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards