Question 1

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.​

Accepted Answer

A) True 
 B)False

Question 2

Which of the following can lead to partial dependencies?​

Accepted Answer

A)  ​composite primary key 
B)  ​common fields 
C)  ​foreign keys 
D)  ​normalization 
A)  ​composite primary key 
B)  ​common fields 
C)  ​foreign keys 
D)  ​normalization

Question 3

Data in third normal form (3NF)contains which of the following?​

Accepted Answer

A)  ​repeating groups 
B)  ​transitive dependencies 
C)  ​partial dependencies 
D)  ​none of the above 
A)  ​repeating groups 
B)  ​transitive dependencies 
C)  ​partial dependencies 
D)  ​none of the above

Question 4

Tables can be linked or joined together through their primary keys.​

Accepted Answer

A) True 
 B)False

Question 5

A ____ is a group of interrelated files.​

Accepted Answer

A)  ​record 
B)  ​character 
C)  ​field 
D)  ​database 
A)  ​record 
B)  ​character 
C)  ​field 
D)  ​database

Question 6

A(n)____________________ is a storage structure that contains data.​

Accepted Answer

The answer of A(n)____________________ is a storage structure that contains...

Question 7

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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?​

Accepted Answer

A)  ​record 
B)  ​file 
C)  ​field 
D)  ​database 
A)  ​record 
B)  ​file 
C)  ​field 
D)  ​database

Question 11

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.​

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which of the following can be used to link the data in two or more tables together?​

Accepted Answer

A)  ​repeating group 
B)  ​relationships 
C)  ​SDLC 
D)  ​common field 
A)  ​repeating group 
B)  ​relationships 
C)  ​SDLC 
D)  ​common field

Question 14

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?​

Accepted Answer

Any repeating groups are eliminated from

Question 15

Which of the following may contain transitive dependencies,but not partial dependencies?​

Accepted Answer

A)  ​unnormalized data 
B)  ​second normal form (2NF) 
C)  ​first normal form (1NF) 
D)  ​third normal form (3NF) 
A)  ​unnormalized data 
B)  ​second normal form (2NF) 
C)  ​first normal form (1NF) 
D)  ​third normal form (3NF)

Question 16

If a primary key has been identified for the data,then the data is considered to be in first normal form (1NF).​

Accepted Answer

A) True 
 B)False

Question 17

A one-to-many relationship cannot be included in a relational database.​

Accepted Answer

A) True 
 B)False

Question 18

In which step of the Systems Development Life Cycle (SDLC)is the system actually used by the end-user on a regular basis?​

Accepted Answer

A)  ​systems investigation 
B)  ​systems analysis 
C)  ​systems deployment 
D)  ​systems implementation and review 
A)  ​systems investigation 
B)  ​systems analysis 
C)  ​systems deployment 
D)  ​systems implementation and review

Question 19

A(n)____________________ relationship cannot exist in a physical relational database.​

Accepted Answer

many-to-ma

Question 20

A collection of fields is a file.​

Accepted Answer

A) True 
 B)False

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.

Which of the following can lead to partial dependencies?

Data in third normal form (3NF)contains which of the following?

Tables can be linked or joined together through their primary keys.

A ____ is a group of interrelated files.

A(n)____________________ is a storage structure that contains data.

A DBMS includes which of the following capabilities?

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

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

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

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

Which of the following can be used to link the data in two or more tables together?

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?

Which of the following may contain transitive dependencies,but not partial dependencies?

If a primary key has been identified for the data,then the data is considered to be in first normal form (1NF).

A one-to-many relationship cannot be included in a relational database.

In which step of the Systems Development Life Cycle (SDLC)is the system actually used by the end-user on a regular basis?

A(n)____________________ relationship cannot exist in a physical relational database.

A collection of fields is a file.

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 one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.​

Which of the following can lead to partial dependencies?​

Data in third normal form (3NF)contains which of the following?​

Tables can be linked or joined together through their primary keys.​

A ____ is a group of interrelated files.​

A(n)____________________ is a storage structure that contains data.​

A DBMS includes which of the following capabilities?​

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

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

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?​

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.​

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

Which of the following can be used to link the data in two or more tables together?​

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?​

Which of the following may contain transitive dependencies,but not partial dependencies?​

If a primary key has been identified for the data,then the data is considered to be in first normal form (1NF).​

A one-to-many relationship cannot be included in a relational database.​

In which step of the Systems Development Life Cycle (SDLC)is the system actually used by the end-user on a regular basis?​

A(n)____________________ relationship cannot exist in a physical relational database.​

A collection of fields is a file.​

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

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.

Which of the following can lead to partial dependencies?

Data in third normal form (3NF)contains which of the following?

Tables can be linked or joined together through their primary keys.

A ____ is a group of interrelated files.

A(n)____________________ is a storage structure that contains data.

A DBMS includes which of the following capabilities?

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

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

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

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

Which of the following can be used to link the data in two or more tables together?

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?

Which of the following may contain transitive dependencies,but not partial dependencies?

If a primary key has been identified for the data,then the data is considered to be in first normal form (1NF).

A one-to-many relationship cannot be included in a relational database.

In which step of the Systems Development Life Cycle (SDLC)is the system actually used by the end-user on a regular basis?

A(n)____________________ relationship cannot exist in a physical relational database.

A collection of fields is a file.