Question 1

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 2

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

Accepted Answer

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

Question 3

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?

Accepted Answer

A)  record 
B)  file 
C)  field 
D)  database 
A)  record 
B)  file 
C)  field 
D)  database

Question 4

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 5

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

Accepted Answer

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

Question 6

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 7

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 8

Data redundancy is created through a process known as normalization.

Accepted Answer

A) True 
 B)False

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

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

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?

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

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

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

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

Data redundancy is created through a process known as normalization.

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 field in the logical design of a database corresponds to a row in the physical table of a relational database.

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

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?

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

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

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

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

Data redundancy is created through a process known as normalization.

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