Question 1

What is the purpose of a foreign key?​

Accepted Answer

A foreign key is used to link data toget

Question 2

​
-What type of relationship is depicted in Figure 1?​

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 3

A database is a physical storage device for data.​

Accepted Answer

A) True 
 B)False

Question 4

If a recipe contains several ingredients,and those ingredients can also be used in other recipes,this would be an example of what type of relationship?​

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 5

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.​

Accepted Answer

A) True 
 B)False

Question 6

A solid straight line in an E-R Model depicts a(n)____________________ relationship.​

Accepted Answer

one-to-one

Question 7

Which of the following is an interface tool that allows a user to create,edit,and manipulate data in Oracle 12c?​

Accepted Answer

A)  ​SQL 
B)  ​SQL*Plus 
C)  ​ASCII 
D)  ​Script 
A)  ​SQL 
B)  ​SQL*Plus 
C)  ​ASCII 
D)  ​Script

Question 8

Data mining refers to ____.​

Accepted Answer

A)  ​discovering new data to include in the database 
B)  ​analyzing data already stored in a database 
C)  ​selling data to other organizations 
D)  ​all of the above 
A)  ​discovering new data to include in the database 
B)  ​analyzing data already stored in a database 
C)  ​selling data to other organizations 
D)  ​all of the above

Question 9

In which step of the Systems Development Life Cycle (SDLC)is the solution to the identified problem determined and understood?​

Accepted Answer

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

Question 10

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 11

If the data has no partial dependencies,repeating groups,or transitive dependencies,and has a composite primary key,the data is in which form?​

Accepted Answer

A)  ​first normal 
B)  ​second normal 
C)  ​third normal 
D)  ​unnormalized 
A)  ​first normal 
B)  ​second normal 
C)  ​third normal 
D)  ​unnormalized

Question 12

Which of the following may contain partial dependencies,but cannot contain repeating groups?​

Accepted Answer

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

Question 13

Data in first normal form (1NF)does not contain which of the following?​

Accepted Answer

A)  ​primary key 
B)  ​repeating groups 
C)  ​partial dependencies 
D)  ​both a and b 
A)  ​primary key 
B)  ​repeating groups 
C)  ​partial dependencies 
D)  ​both a and b

Question 14

A file is composed of a group of related ____________________.​

Accepted Answer

The answer of A file is composed of a group...

Question 15

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 16

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

Question 17

Which of the following usually correlates to a primary key in another table?​

Accepted Answer

A)  ​transitive dependency 
B)  ​composite primary key 
C)  ​foreign key 
D)  ​partial dependency 
A)  ​transitive dependency 
B)  ​composite primary key 
C)  ​foreign key 
D)  ​partial dependency

Question 18

Which of the following is an example of an attribute?​

Accepted Answer

A)  ​a person's hair color 
B)  ​the people who live in a particular town 
C)  ​the patients in a doctor's office 
D)  ​vendors 
A)  ​a person's hair color 
B)  ​the people who live in a particular town 
C)  ​the patients in a doctor's office 
D)  ​vendors

Question 19

A collection of records is a file.​

Accepted Answer

A) True 
 B)False

Question 20

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

What is the purpose of a foreign key?

-What type of relationship is depicted in Figure 1?

A database is a physical storage device for data.

If a recipe contains several ingredients,and those ingredients can also be used in other recipes,this would be an example of what type of relationship?

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

A solid straight line in an E-R Model depicts a(n)____________________ relationship.

Which of the following is an interface tool that allows a user to create,edit,and manipulate data in Oracle 12c?

Data mining refers to ____.

In which step of the Systems Development Life Cycle (SDLC)is the solution to the identified problem determined and understood?

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

If the data has no partial dependencies,repeating groups,or transitive dependencies,and has a composite primary key,the data is in which form?

Which of the following may contain partial dependencies,but cannot contain repeating groups?

Data in first normal form (1NF)does not contain which of the following?

A file is composed of a group of related ____________________.

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

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

Which of the following usually correlates to a primary key in another table?

Which of the following is an example of an attribute?

A collection of records is a file.

In an E-R Model a person,place,or thing with characteristics to be stored in the database are 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 a foreign key?​

​ -What type of relationship is depicted in Figure 1?​

A database is a physical storage device for data.​

If a recipe contains several ingredients,and those ingredients can also be used in other recipes,this would be an example of what type of relationship?​

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.​

A solid straight line in an E-R Model depicts a(n)____________________ relationship.​

Which of the following is an interface tool that allows a user to create,edit,and manipulate data in Oracle 12c?​

Data mining refers to ____.​

In which step of the Systems Development Life Cycle (SDLC)is the solution to the identified problem determined and understood?​

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

If the data has no partial dependencies,repeating groups,or transitive dependencies,and has a composite primary key,the data is in which form?​

Which of the following may contain partial dependencies,but cannot contain repeating groups?​

Data in first normal form (1NF)does not contain which of the following?​

A file is composed of a group of related ____________________.​

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

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

Which of the following usually correlates to a primary key in another table?​

Which of the following is an example of an attribute?​

A collection of records is a file.​

In an E-R Model a person,place,or thing with characteristics to be stored in the database are 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 a foreign key?

-What type of relationship is depicted in Figure 1?

A database is a physical storage device for data.

If a recipe contains several ingredients,and those ingredients can also be used in other recipes,this would be an example of what type of relationship?

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

A solid straight line in an E-R Model depicts a(n)____________________ relationship.

Which of the following is an interface tool that allows a user to create,edit,and manipulate data in Oracle 12c?

Data mining refers to ____.

In which step of the Systems Development Life Cycle (SDLC)is the solution to the identified problem determined and understood?

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

If the data has no partial dependencies,repeating groups,or transitive dependencies,and has a composite primary key,the data is in which form?

Which of the following may contain partial dependencies,but cannot contain repeating groups?

Data in first normal form (1NF)does not contain which of the following?

A file is composed of a group of related ____________________.

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

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

Which of the following usually correlates to a primary key in another table?

Which of the following is an example of an attribute?

A collection of records is a file.

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