Question 1

What is a checkpoint?

Accepted Answer

A checkpoint is a part of a recovery log.When a checkpoint is created,all updates recorded in the recovery log-and as a result any updates to data stored in memory-are written to the database in the data file on the disk.

Question 2

What is query optimization?

Accepted Answer

Query optimization refers to examining multiple ways of executing the same query and choosing the fastest option.

Question 3

The DCL commands are used by the business end users of a database system.

Accepted Answer

A) True 
 B)False  False

Question 4

What is the purpose of the data definition component of a DBMS?

Accepted Answer

The data definition component is used by

Question 5

What is a common purpose for all database policies and standards?

Accepted Answer

A common purpose for all datab

Question 6

What is an encryption key?

Accepted Answer

An encryption key is a scrambling algori

Question 7

What number will the following query in the HAPPY INSURANCE database return?
SELECT count (DISTINCT column_name)
FROM user_tab_columns;

Accepted Answer

A) 2 
B) 3 
C) 10 
D) 13 
A) 2 
B) 3 
C) 10 
D) 13

Question 8

What is the purpose of the data manipulation component of a DBMS?

Accepted Answer

The data manipulation componen

Question 9

What is the purpose of the ROLLBACK command?

Accepted Answer

The ROLLBACK command

Question 10

What is the purpose of the data administration component of a DBMS?

Accepted Answer

The database administration component is

Question 11

What is a single-user DBMS?

Accepted Answer

In a single-user DBMS,the data

Question 12

What is the difference between accidental misuse and malicious data updates?

Accepted Answer

Accidental misuse refers to data updates

Question 13

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
 $\begin{array} { l l c l } \text { CLIENT } & & \ \text { ClientlD } & \text { ClentName } & \text { CientAgent } & \text { ClientSpouseName } \ \text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \ \text { C212 } & \text { Kanin } & A 1 & \text { Bil } \ \text { C333 } & \text { Cole } & A 2 & \text { Amy } \ \text { C444 } & \text { Dorothy } & A 2 & \ \text { C555 } & \text { Anay } & A 3 & \text { Ams } \ \text { C666 } & \text { Tina } & A 3 & \text { Mait } \ \text { C777 } & \text { Christina } & A 4 & \text { Mike } \end{array}$

AGENT
$\begin{array} { l l c l c c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearoffire SupervisedBy } \ \text { A1 } & \text { Kate } & 1 & 101 & 1990 & \ \text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \ \text { A3 } & \text { Luke } & 3 & 100 & 1992 & \ \text { A4 } & \text { James } & 3 & 90 & 2010 & \mathrm {~A} 3 \end{array}$

AREA
$\begin{array}{lll}
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-How many records will the following query in the HAPPY INSURANCE database return?
SELECT table_name,column_name
FROM user_tab_columns;

Accepted Answer

A) 2 
B) 3 
C) 10 
D) 13 
A) 2 
B) 3 
C) 10 
D) 13

Question 14

The application development component provides functionalities to the developers of:

Accepted Answer

A) Database models 
B) Security and backup procedures 
C) Data dictionaries 
D) Front-end applications 
A) Database models 
B) Security and backup procedures 
C) Data dictionaries 
D) Front-end applications

Question 15

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
 $\begin{array} { l l c l } \text { CLIENT } & & \ \text { ClientlD } & \text { ClentName } & \text { CientAgent } & \text { ClientSpouseName } \ \text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \ \text { C212 } & \text { Kanin } & A 1 & \text { Bil } \ \text { C333 } & \text { Cole } & A 2 & \text { Amy } \ \text { C444 } & \text { Dorothy } & A 2 & \ \text { C555 } & \text { Anay } & A 3 & \text { Ams } \ \text { C666 } & \text { Tina } & A 3 & \text { Mait } \ \text { C777 } & \text { Christina } & A 4 & \text { Mike } \end{array}$

AGENT
$\begin{array} { l l c l c c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearoffire SupervisedBy } \ \text { A1 } & \text { Kate } & 1 & 101 & 1990 & \ \text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \ \text { A3 } & \text { Luke } & 3 & 100 & 1992 & \ \text { A4 } & \text { James } & 3 & 90 & 2010 & \mathrm {~A} 3 \end{array}$

AREA
$\begin{array}{lll}
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-How many records will the following query in the HAPPY INSURANCE database return?
SELECT DISTINCT table_name
FROM user_tab_columns;

Accepted Answer

A) 2 
B) 3 
C) 10 
D) 13 
A) 2 
B) 3 
C) 10 
D) 13

Question 16

Regular monitoring helps the DBA recognize instances when maintenance activities are needed.

Accepted Answer

A) True 
 B)False

Question 17

The data dictionary created by the ________ is often referred to as the catalog.

Accepted Answer

A) TCL 
B) DML 
C) DCL 
D) DBMS 
A) TCL 
B) DML 
C) DCL 
D) DBMS

Question 18

The data definition DBMS component uses the SQL commands from the DDL category.

Accepted Answer

A) True 
 B)False

Question 19

In a role-based access control system,the membership of users in roles cannot change.

Accepted Answer

A) True 
 B)False

Question 20

The data definition component is a part of every DBMS package.

Accepted Answer

A) True 
 B)False

What is a checkpoint?

What is query optimization?

The DCL commands are used by the business end users of a database system.

What is the purpose of the data definition component of a DBMS?

What is a common purpose for all database policies and standards?

What is an encryption key?

What number will the following query in the HAPPY INSURANCE database return? SELECT count (DISTINCT column_name) FROM user_tab_columns;

What is the purpose of the data manipulation component of a DBMS?

What is the purpose of the ROLLBACK command?

What is the purpose of the data administration component of a DBMS?

What is a single-user DBMS?

What is the difference between accidental misuse and malicious data updates?

The application development component provides functionalities to the developers of:

Regular monitoring helps the DBA recognize instances when maintenance activities are needed.

The data dictionary created by the ________ is often referred to as the catalog.

The data definition DBMS component uses the SQL commands from the DDL category.

In a role-based access control system,the membership of users in roles cannot change.

The data definition component is a part of every DBMS package.

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Filters

Exam 10: Overview of Dbms Functionalities and Database Administration

What is a checkpoint?

What is query optimization?

The DCL commands are used by the business end users of a database system.

What is the purpose of the data definition component of a DBMS?

What is a common purpose for all database policies and standards?

What is an encryption key?

What number will the following query in the HAPPY INSURANCE database return? SELECT count (DISTINCT column_name) FROM user_tab_columns;

What is the purpose of the data manipulation component of a DBMS?

What is the purpose of the ROLLBACK command?

What is the purpose of the data administration component of a DBMS?

What is a single-user DBMS?

What is the difference between accidental misuse and malicious data updates?

The application development component provides functionalities to the developers of:

Regular monitoring helps the DBA recognize instances when maintenance activities are needed.

The data dictionary created by the ________ is often referred to as the catalog.

The data definition DBMS component uses the SQL commands from the DDL category.

In a role-based access control system,the membership of users in roles cannot change.

The data definition component is a part of every DBMS package.

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Filters