Question 1

What is the purpose of an E-R Model?​

Accepted Answer

The answer of What is the purpose of an E-R...

Question 2

A file is referred to as a(n)____________________ in an Oracle 12c database.​

Accepted Answer

The answer of A file is referred to as a(n)____________________...

Question 3

Which of the following types of relationships cannot exist in a relational database?​

Accepted Answer

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

Question 4

Two tables can be linked or joined together through a common field.​

Accepted Answer

A) True 
 B)False

Question 5

A field in the logical design of a database corresponds to a ____ in the physical database.​

Accepted Answer

A)  ​column 
B)  ​row 
C)  ​table 
D)  ​file

Question 6

A(n)____________________ is a basic unit of data that can consist of a letter,number,or special symbol.​

Accepted Answer

The answer of A(n)____________________ is a basic unit of data...

Question 7

A record in the logical design of a database corresponds to a ____ in the physical database.​

Accepted Answer

A)  ​column 
B)  ​row 
C)  ​table 
D)  ​file

Question 8

A record in the logical design of a database corresponds to a row in the physical table of a relational database.​

Accepted Answer

A) True 
 B)False

Question 9

A field is a basic unit of data also referred to as a record.​

Accepted Answer

A) True 
 B)False

Question 10

Data is in third normal form if it is in second normal form and has no _________________________.​

Accepted Answer

The answer of Data is in third normal form if...

Question 11

Only one type of relationship can be represented in an Entity-Relationship Model.​

Accepted Answer

A) True 
 B)False

Question 12

An entity is represented by a column in the Entity-Relationship Model.​

Accepted Answer

A) True 
 B)False

Question 13

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?​

Accepted Answer

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

Question 14

Which of the following is not a step in the Systems Development Life Cycle (SDLC)?​

Accepted Answer

A)  ​systems analysis 
B)  ​systems investigation 
C)  ​systems design 
D)  ​all of the above are steps in the SDLC

Question 15

A many-to-many relationship cannot exist in a relational database.​

Accepted Answer

A) True 
 B)False

Question 16

A field is a group of related ____________________.​

Accepted Answer

The answer of A field is a group of related...

Question 17

​Which of the following terms represents a collection of fields?​

Accepted Answer

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

Question 18

_________________________ is a data sublanguage that processes sets of data.​

Accepted Answer

The answer of _________________________ is a data sublanguage that processes...

Question 19

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.​

Accepted Answer

A) True 
 B)False

Question 20

The multi-step process used when creating a new system is referred to as ____.​

Accepted Answer

A)  ​the Systems Development Life Cycle 
B)  ​data mining 
C)  ​E-R Modeling 
D)  ​SQL

Exam 1: Overview of Database Concepts

What is the purpose of an E-R Model?

A file is referred to as a(n)____________________ in an Oracle 12c database.

Which of the following types of relationships cannot exist in a relational database?

Two tables can be linked or joined together through a common field.

A field in the logical design of a database corresponds to a ____ in the physical database.

A(n)____________________ is a basic unit of data that can consist of a letter,number,or special symbol.

A record in the logical design of a database corresponds to a ____ in the physical database.

A record in the logical design of a database corresponds to a row in the physical table of a relational database.

A field is a basic unit of data also referred to as a record.

Data is in third normal form if it is in second normal form and has no _________________________.

Only one type of relationship can be represented in an Entity-Relationship Model.

An entity is represented by a column in the Entity-Relationship Model.

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

Which of the following is not a step in the Systems Development Life Cycle (SDLC) ?

A many-to-many relationship cannot exist in a relational database.

A field is a group of related ____________________.

Which of the following terms represents a collection of fields?

_________________________ is a data sublanguage that processes sets of data.

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

The multi-step process used when creating a new system is referred to as ____.

Exam 1: Overview of Database Concepts

What is the purpose of an E-R Model?​

A file is referred to as a(n)____________________ in an Oracle 12c database.​

Which of the following types of relationships cannot exist in a relational database?​

Two tables can be linked or joined together through a common field.​

A field in the logical design of a database corresponds to a ____ in the physical database.​

A(n)____________________ is a basic unit of data that can consist of a letter,number,or special symbol.​

A record in the logical design of a database corresponds to a ____ in the physical database.​

A record in the logical design of a database corresponds to a row in the physical table of a relational database.​

A field is a basic unit of data also referred to as a record.​

Data is in third normal form if it is in second normal form and has no _________________________.​

Only one type of relationship can be represented in an Entity-Relationship Model.​

An entity is represented by a column in the Entity-Relationship Model.​

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?​

Which of the following is not a step in the Systems Development Life Cycle (SDLC) ?​

A many-to-many relationship cannot exist in a relational database.​

A field is a group of related ____________________.​

​Which of the following terms represents a collection of fields?​

_________________________ is a data sublanguage that processes sets of data.​

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.​

The multi-step process used when creating a new system is referred to as ____.​

What is the purpose of an E-R Model?

A file is referred to as a(n)____________________ in an Oracle 12c database.

Which of the following types of relationships cannot exist in a relational database?

Two tables can be linked or joined together through a common field.

A field in the logical design of a database corresponds to a ____ in the physical database.

A(n)____________________ is a basic unit of data that can consist of a letter,number,or special symbol.

A record in the logical design of a database corresponds to a ____ in the physical database.

A record in the logical design of a database corresponds to a row in the physical table of a relational database.

A field is a basic unit of data also referred to as a record.

Data is in third normal form if it is in second normal form and has no _________________________.

Only one type of relationship can be represented in an Entity-Relationship Model.

An entity is represented by a column in the Entity-Relationship Model.

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

Which of the following is not a step in the Systems Development Life Cycle (SDLC) ?

A many-to-many relationship cannot exist in a relational database.

A field is a group of related ____________________.

Which of the following terms represents a collection of fields?

_________________________ is a data sublanguage that processes sets of data.

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

The multi-step process used when creating a new system is referred to as ____.