Question 1

A field in the logical design of a database is represented by what in the physical database?

Accepted Answer

A)  column 
B)  row 
C)  field 
D)  row. 
A)  column 
B)  row 
C)  field 
D)  row.

Question 2

Data mining refers to analyzing historical data stored in a database.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is used to create and maintain the physical database?

Accepted Answer

A)  Data mining 
B)  Database Management System (DBMS) 
C)  E-R Model 
D)  Systems Development Life Cycle (SDL
C)  
A)  Data mining 
B)  Database Management System (DBMS) 
C)  E-R Model 
D)  Systems Development Life Cycle (SDL
C)

Question 4

Which of the following is used to uniquely identify each record?

Accepted Answer

A)  primary key 
B)  row 
C)  partial dependency 
D)  account number 
A)  primary key 
B)  row 
C)  partial dependency 
D)  account number

Question 5

What is added to a relational database to eliminate many-to-many relationships?

Accepted Answer

A)  bridging table 
B)  transitive dependency 
C)  primary entity 
D)  secondary entity 
A)  bridging table 
B)  transitive dependency 
C)  primary entity 
D)  secondary entity

Question 6

A DBMS includes which of the following capabilities?

Accepted Answer

A)  security 
B)  data dictionary 
C)  multiuser access 
D)  all of the above 
A)  security 
B)  data dictionary 
C)  multiuser access 
D)  all of the above

Question 7

-What type of relationship is depicted in Figure 2?

Accepted Answer

A)  one-to-many 
B)  many-to-many 
C)  one-to-all 
D)  one-to-one 
A)  one-to-many 
B)  many-to-many 
C)  one-to-all 
D)  one-to-one

Question 8

A bridging table can be used to eliminate a many-to-many relationship in a relational database.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is used to determine the correct organization for data that is to be stored in a database?

Accepted Answer

A)  E-R model 
B)  normalization process 
C)  systems implementation and review 
D)  systems analysis 
A)  E-R model 
B)  normalization process 
C)  systems implementation and review 
D)  systems analysis

Question 10

-If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?

Accepted Answer

A)  Each customer can only own one car, but each car can be owned by many customers. 
B)  Each customer can only own one car and each car can only be owned by one customer. 
C)  Each customer can own many cars and each car can be owned by many customers. 
D)  Each customer can own many cars, but each car can be owned by only one customer. 
A)  Each customer can only own one car, but each car can be owned by many customers. 
B)  Each customer can only own one car and each car can only be owned by one customer. 
C)  Each customer can own many cars and each car can be owned by many customers. 
D)  Each customer can own many cars, but each car can be owned by only one customer.

Question 11

The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.

Accepted Answer

A) True 
 B)False

Question 12

-Which statement best describes the relationship shown in Figure 1?

Accepted Answer

A)  For every occurrence of A, there can only be one occurrence of B. 
B)  For every occurrence of A, there can be multiple occurrences of B. 
C)  There can be multiple occurrences of A and B. 
D)  For every occurrence of B, there can be multiple occurrences of A. 
A)  For every occurrence of A, there can only be one occurrence of B. 
B)  For every occurrence of A, there can be multiple occurrences of B. 
C)  There can be multiple occurrences of A and B. 
D)  For every occurrence of B, there can be multiple occurrences of A.

Question 13

A foreign key is usually found on which side of a relationship?

Accepted Answer

A)  one 
B)  many 
C)  unnormalized 
D)  primary entity 
A)  one 
B)  many 
C)  unnormalized 
D)  primary entity

Question 14

A foreign key appears on the many side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 15

Partial dependency exists if what conditions exist?

Accepted Answer

A)  a column is dependent on a portion of the table that is not identified as the primary key 
B)  a column is dependent only on a portion of a composite primary key 
C)  the data contains repeating groups 
D)  the table is not in first normal form (1NF) 
A)  a column is dependent on a portion of the table that is not identified as the primary key 
B)  a column is dependent only on a portion of a composite primary key 
C)  the data contains repeating groups 
D)  the table is not in first normal form (1NF)

Question 16

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

Accepted Answer

A)  entity 
B)  row 
C)  attribute 
D)  file 
A)  entity 
B)  row 
C)  attribute 
D)  file

Question 17

A collection of records is a file.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following committees are responsible for establishing SQL guidelines?

Accepted Answer

A)  ANSI and ASCII 
B)  ANSI and ISO 
C)  IEEE and OSI 
D)  OSI and ASCII 
A)  ANSI and ASCII 
B)  ANSI and ISO 
C)  IEEE and OSI 
D)  OSI and ASCII

Question 19

A foreign key uniquely identifies each row in a table.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following terms is considered the basic unit of data in a database?

Accepted Answer

A)  character 
B)  field 
C)  record 
D)  file 
A)  character 
B)  field 
C)  record 
D)  file

A field in the logical design of a database is represented by what in the physical database?

Data mining refers to analyzing historical data stored in a database.

Which of the following is used to create and maintain the physical database?

Which of the following is used to uniquely identify each record?

What is added to a relational database to eliminate many-to-many relationships?

A DBMS includes which of the following capabilities?

-What type of relationship is depicted in Figure 2?

A bridging table can be used to eliminate a many-to-many relationship in a relational database.

Which of the following is used to determine the correct organization for data that is to be stored in a database?

-If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?

The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.

-Which statement best describes the relationship shown in Figure 1?

A foreign key is usually found on which side of a relationship?

A foreign key appears on the many side of a one-to-many relationship.

Partial dependency exists if what conditions exist?

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

A collection of records is a file.

Which of the following committees are responsible for establishing SQL guidelines?

A foreign key uniquely identifies each row in a table.

Which of the following terms is considered the basic unit of data in a database?

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 1: Overview of Database Concepts

A field in the logical design of a database is represented by what in the physical database?

Data mining refers to analyzing historical data stored in a database.

Which of the following is used to create and maintain the physical database?

Which of the following is used to uniquely identify each record?

What is added to a relational database to eliminate many-to-many relationships?

A DBMS includes which of the following capabilities?

-What type of relationship is depicted in Figure 2?

A bridging table can be used to eliminate a many-to-many relationship in a relational database.

Which of the following is used to determine the correct organization for data that is to be stored in a database?

-If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?

The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.

-Which statement best describes the relationship shown in Figure 1?

A foreign key is usually found on which side of a relationship?

A foreign key appears on the many side of a one-to-many relationship.

Partial dependency exists if what conditions exist?

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

A collection of records is a file.

Which of the following committees are responsible for establishing SQL guidelines?

A foreign key uniquely identifies each row in a table.

Which of the following terms is considered the basic unit of data in a database?

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters