Question 1

In which step of the Systems Development Life Cycle (SDLC)are the logical and physical components defined?​

Accepted Answer

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

Question 2

Data is in second normal form if it is in first normal form and has no ____________________.​

Accepted Answer

partial de

Question 3

A straight line with a crow's foot at one end depicts a(n)____________________ relationship in an E-R Model.​

Accepted Answer

one-to-man

Question 4

If uncontrolled,what can lead to data anomalies?​

Accepted Answer

A)  ​data normalization 
B)  ​data correlation 
C)  ​data redundancy 
D)  ​data suppression 
A)  ​data normalization 
B)  ​data correlation 
C)  ​data redundancy 
D)  ​data suppression

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(n)____________________ is a common field between two tables and is also a primary key for one of the tables.​

Accepted Answer

The answer of A(n)____________________ is a common field between two...

Question 7

A column represents a field in the physical database table.​

Accepted Answer

A) True 
 B)False

Question 8

Structured Query Language (SQL)is generally used to interact with a database.​

Accepted Answer

A) True 
 B)False

Question 9

What name is used to denote a common field that exists between two tables,but is also the primary key for one of the tables?​

Accepted Answer

A)  ​duplicate key 
B)  ​foreign key 
C)  ​composite primary key 
D)  ​distinct key 
A)  ​duplicate key 
B)  ​foreign key 
C)  ​composite primary key 
D)  ​distinct key

Question 10

A(n)____________________ is used to uniquely identify each record.​

Accepted Answer

The answer of A(n)____________________ is used to uniquely identify each...

Question 11

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

The steps used to design and develop a database are commonly referred to as the ______________________________.​

Accepted Answer

Systems De

Question 13

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

A foreign key uniquely identifies each row in a table.​

Accepted Answer

A) True 
 B)False

Question 15

Data in second normal form (2NF)may contain which of the following?​

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A field 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 18

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

Suppose that a patient in a hospital can only be assigned to one room.However,the room may be assigned to more than one patient at a time.This is 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 20

A character is a basic unit of data and can consist of a number,letter,or special symbol.​

Accepted Answer

A) True 
 B)False

In which step of the Systems Development Life Cycle (SDLC)are the logical and physical components defined?

Data is in second normal form if it is in first normal form and has no ____________________.

A straight line with a crow's foot at one end depicts a(n)____________________ relationship in an E-R Model.

If uncontrolled,what can lead to data anomalies?

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

A(n)____________________ is a common field between two tables and is also a primary key for one of the tables.

A column represents a field in the physical database table.

Structured Query Language (SQL)is generally used to interact with a database.

What name is used to denote a common field that exists between two tables,but is also the primary key for one of the tables?

A(n)____________________ is used to uniquely identify each record.

-What type of relationship is depicted in Figure 2?

The steps used to design and develop a database are commonly referred to as the ______________________________.

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

A foreign key uniquely identifies each row in a table.

Data in second normal form (2NF)may contain which of the following?

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

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

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

Suppose that a patient in a hospital can only be assigned to one room.However,the room may be assigned to more than one patient at a time.This is an example of what type of relationship?

A character is a basic unit of data and can consist of a number,letter,or special symbol.

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

In which step of the Systems Development Life Cycle (SDLC)are the logical and physical components defined?​

Data is in second normal form if it is in first normal form and has no ____________________.​

A straight line with a crow's foot at one end depicts a(n)____________________ relationship in an E-R Model.​

If uncontrolled,what can lead to data anomalies?​

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

A(n)____________________ is a common field between two tables and is also a primary key for one of the tables.​

A column represents a field in the physical database table.​

Structured Query Language (SQL)is generally used to interact with a database.​

What name is used to denote a common field that exists between two tables,but is also the primary key for one of the tables?​

A(n)____________________ is used to uniquely identify each record.​

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

The steps used to design and develop a database are commonly referred to as the ______________________________.​

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

A foreign key uniquely identifies each row in a table.​

Data in second normal form (2NF)may contain which of the following?​

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

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

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

Suppose that a patient in a hospital can only be assigned to one room.However,the room may be assigned to more than one patient at a time.This is an example of what type of relationship?​

A character is a basic unit of data and can consist of a number,letter,or special symbol.​

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

In which step of the Systems Development Life Cycle (SDLC)are the logical and physical components defined?

Data is in second normal form if it is in first normal form and has no ____________________.

A straight line with a crow's foot at one end depicts a(n)____________________ relationship in an E-R Model.

If uncontrolled,what can lead to data anomalies?

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

A(n)____________________ is a common field between two tables and is also a primary key for one of the tables.

A column represents a field in the physical database table.

Structured Query Language (SQL)is generally used to interact with a database.

What name is used to denote a common field that exists between two tables,but is also the primary key for one of the tables?

A(n)____________________ is used to uniquely identify each record.

-What type of relationship is depicted in Figure 2?

The steps used to design and develop a database are commonly referred to as the ______________________________.

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

A foreign key uniquely identifies each row in a table.

Data in second normal form (2NF)may contain which of the following?

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

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

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

Suppose that a patient in a hospital can only be assigned to one room.However,the room may be assigned to more than one patient at a time.This is an example of what type of relationship?

A character is a basic unit of data and can consist of a number,letter,or special symbol.