Question 1

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

Accepted Answer

An E-R Model is used by designers to det

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 
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 
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 
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

transitive

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 
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 
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 
A)  ​field 
B)  ​record 
C)  ​character 
D)  ​file

Question 18

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

Accepted Answer

Structured

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 
A)  ​the Systems Development Life Cycle 
B)  ​data mining 
C)  ​E-R Modeling 
D)  ​SQL

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 ____.

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

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 ____.​

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

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 ____.