FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Overview of Dbms Functionalities and Database Administration

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

The application development component provides functionalities to the developers of:

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

E) B) and D)
F) C) and D)

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

What is a checkpoint?

Correct Answer

verified

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 3

Essay

Review LaterAdd Note

What is the purpose of the ROLLBACK command?

What is a single-user DBMS?

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

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

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;

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

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;

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

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

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

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

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

What is query optimization?

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 difference between accidental misuse and malicious data updates?

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

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