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

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Accidental misuse refers to data updates...

View Answer

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

What is the purpose of the ROLLBACK command?

Correct Answer

verified

The ROLLBACK command...

View Answer

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

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

What is query optimization?

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;

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

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 DCL commands are used by the business end users of a database system.

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

What is an encryption key?

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

What is a checkpoint?

The application development component provides functionalities to the developers of:

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

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

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

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

What is a single-user DBMS?