Question 1

A(n)______________________________ is used to create and maintain the structure of a database.​

Accepted Answer

database management system
(DBMS)

Question 2

Which of the following does not contain repeating groups,but has a primary key and possibly partial dependencies?​

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

Question 3

Which of the following may contain repeating groups of data?​

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

Question 4

A ____ is a storage structure designed to hold a collection of data.​

Accepted Answer

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

Question 5

The occurrence of data anomalies would indicate an unnormalized database design.​

Accepted Answer

A) True 
 B)False

Question 6

A foreign key appears on the many side of a one-to-many relationship.​

Accepted Answer

A) True 
 B)False

Question 7

Which of the following terms refers to a group of related records?​

Accepted Answer

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

Question 8

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

Accepted Answer

A)  ​row 
B)  ​field 
C)  ​record 
D)  ​row. 
A)  ​row 
B)  ​field 
C)  ​record 
D)  ​row.

Question 9

Analyzing historical sales data stored in a database is commonly referred to as ____.​

Accepted Answer

A)  ​data storage 
B)  ​data mining 
C)  ​data manipulation 
D)  ​archived data 
A)  ​data storage 
B)  ​data mining 
C)  ​data manipulation 
D)  ​archived data

Question 10

Which of the following is used to determine the correct organization for data that is to be stored in a database?​

Accepted Answer

A)  ​E-R model 
B)  ​normalization process 
C)  ​systems implementation and review 
D)  ​systems analysis 
A)  ​E-R model 
B)  ​normalization process 
C)  ​systems implementation and review 
D)  ​systems analysis

Question 11

Which of the following committees are responsible for establishing SQL guidelines?​

Accepted Answer

A)  ​ANSI and ASCII 
B)  ​ANSI and ISO 
C)  ​IEEE and OSI 
D)  ​OSI and ASCII 
A)  ​ANSI and ASCII 
B)  ​ANSI and ISO 
C)  ​IEEE and OSI 
D)  ​OSI and ASCII

Question 12

Which of the following is used to uniquely identify each record?​

Accepted Answer

A)  ​primary key 
B)  ​row 
C)  ​partial dependency 
D)  ​account number 
A)  ​primary key 
B)  ​row 
C)  ​partial dependency 
D)  ​account number

Question 13

A(n)____________________ is a group of interrelated files.​

Accepted Answer

The answer of A(n)____________________ is a group of interrelated files.​...

Question 14

SQL commands can be issued in Oracle 12c through ____________________ which is an interface that allows users to interact with the database.​

Accepted Answer

The answer of SQL commands can be issued in Oracle...

Question 15

Analyzing historical data stored in a database is referred to as ____________________.​

Accepted Answer

The answer of Analyzing historical data stored in a database...

Question 16

A(n)____________________ is a group of related fields.​

Accepted Answer

The answer of A(n)____________________ is a group of related fields.​...

Question 17

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.​

Accepted Answer

A) True 
 B)False

Question 18

A(n)____________________ table can be added to the physical database to eliminate a many-to-many relationship.​

Accepted Answer

The answer of A(n)____________________ table can be added to the...

Question 19

Partial dependency exists if what conditions exist?​

Accepted Answer

A)  ​a column is dependent on a portion of the table that is not identified as the primary key 
B)  ​a column is dependent only on a portion of a composite primary key 
C)  ​the data contains repeating groups 
D)  ​the table is not in first normal form (1NF) 
A)  ​a column is dependent on a portion of the table that is not identified as the primary key 
B)  ​a column is dependent only on a portion of a composite primary key 
C)  ​the data contains repeating groups 
D)  ​the table is not in first normal form (1NF)

Question 20

If at least one value in a record does not depend upon the primary key,then a _________________________ exists.​

Accepted Answer

transitive

A(n)______________________________ is used to create and maintain the structure of a database.

Which of the following does not contain repeating groups,but has a primary key and possibly partial dependencies?

Which of the following may contain repeating groups of data?

A ____ is a storage structure designed to hold a collection of data.

The occurrence of data anomalies would indicate an unnormalized database design.

A foreign key appears on the many side of a one-to-many relationship.

Which of the following terms refers to a group of related records?

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

Analyzing historical sales data stored in a database is commonly referred to as ____.

Which of the following is used to determine the correct organization for data that is to be stored in a database?

Which of the following committees are responsible for establishing SQL guidelines?

Which of the following is used to uniquely identify each record?

A(n)____________________ is a group of interrelated files.

SQL commands can be issued in Oracle 12c through ____________________ which is an interface that allows users to interact with the database.

Analyzing historical data stored in a database is referred to as ____________________.

A(n)____________________ is a group of related fields.

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

A(n)____________________ table can be added to the physical database to eliminate a many-to-many relationship.

Partial dependency exists if what conditions exist?

If at least one value in a record does not depend upon the primary key,then a _________________________ exists.

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(n)______________________________ is used to create and maintain the structure of a database.​

Which of the following does not contain repeating groups,but has a primary key and possibly partial dependencies?​

Which of the following may contain repeating groups of data?​

A ____ is a storage structure designed to hold a collection of data.​

The occurrence of data anomalies would indicate an unnormalized database design.​

A foreign key appears on the many side of a one-to-many relationship.​

Which of the following terms refers to a group of related records?​

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

Analyzing historical sales data stored in a database is commonly referred to as ____.​

Which of the following is used to determine the correct organization for data that is to be stored in a database?​

Which of the following committees are responsible for establishing SQL guidelines?​

Which of the following is used to uniquely identify each record?​

A(n)____________________ is a group of interrelated files.​

SQL commands can be issued in Oracle 12c through ____________________ which is an interface that allows users to interact with the database.​

Analyzing historical data stored in a database is referred to as ____________________.​

A(n)____________________ is a group of related fields.​

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.​

A(n)____________________ table can be added to the physical database to eliminate a many-to-many relationship.​

Partial dependency exists if what conditions exist?​

If at least one value in a record does not depend upon the primary key,then a _________________________ exists.​

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(n)______________________________ is used to create and maintain the structure of a database.

Which of the following does not contain repeating groups,but has a primary key and possibly partial dependencies?

Which of the following may contain repeating groups of data?

A ____ is a storage structure designed to hold a collection of data.

The occurrence of data anomalies would indicate an unnormalized database design.

A foreign key appears on the many side of a one-to-many relationship.

Which of the following terms refers to a group of related records?

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

Analyzing historical sales data stored in a database is commonly referred to as ____.

Which of the following is used to determine the correct organization for data that is to be stored in a database?

Which of the following committees are responsible for establishing SQL guidelines?

Which of the following is used to uniquely identify each record?

A(n)____________________ is a group of interrelated files.

SQL commands can be issued in Oracle 12c through ____________________ which is an interface that allows users to interact with the database.

Analyzing historical data stored in a database is referred to as ____________________.

A(n)____________________ is a group of related fields.

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

A(n)____________________ table can be added to the physical database to eliminate a many-to-many relationship.

Partial dependency exists if what conditions exist?

If at least one value in a record does not depend upon the primary key,then a _________________________ exists.