Deck 10: Overview of Dbms Functionalities and Database Administration

Question 1

Which of the following is NOT a data administration task?

A)Monitoring and maintaining the database system
B)Securing the database against unauthorized access
C)Creating a conceptual database model
D)Providing database backup and recovery

Answer 1

C

Question 2

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

Answer 2

D

Question 3

In a role-based access control system,users can be assigned several database roles.

Answer 3

True

Question 4

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

Question 5

If,during the use of the database system,it becomes apparent that a new relation needs to be added to the database,the decision to add the new relation to the database will rest with the:

A)Database developer
B)DBA
C)End user
D)DBMS software developer

Question 6

The data manipulation DBMS component uses the SQL commands from the DCL category.

Question 7

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

Question 8

The application development component is a part of every DBMS package.

Question 9

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

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

Question 10

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
GRANT SELECT,INSERT,ALTER,UPDATE ON client TO shannon;
REVOKE INSERT ON client FROM shannon;

A)Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT,insert data in CLIENT
B)Shannon can read data from CLIENT,change data in CLIENT,insert data in CLIENT
C)Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT
D)Shannon can insert data in CLIENT

Question 11

The data manipulation DBMS component is used:

A)By end users,directly only
B)By end users,via front-end applications only
C)By end users,either directly or via front-end applications
D)By no end users

Question 12

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

Question 13

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

Question 14

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

Question 15

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
CREATE ROLE supervisor;
GRANT SELECT,INSERT,UPDATE ON client TO supervisor;
GRANT SUPERVISOR TO shannon;

A)Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT,insert data in CLIENT
B)Shannon can read data from CLIENT,change data in CLIENT,insert data in CLIENT
C)Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT
D)Shannon can change the metadata of CLIENT

Question 16

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

Question 17

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;

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

Question 18

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

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

Question 19

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

Question 20

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;

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

Question 21

What is an encryption key?

Question 22

What is a complete mirrored backup?

Question 23

What is data backup?

Question 24

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

Question 25

What is a checkpoint?

Question 26

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

Question 27

What is a data dictionary?

Question 28

What is a query optimizer?

Question 29

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

Question 30

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

Question 31

What is the purpose of the COMMIT command?

Question 32

What is query optimization?

Question 33

What is the purpose of the ROLLBACK command?

Question 34

What is a single-user DBMS?

Question 35

What is database recovery?

Question 36

What is the query cost?

Question 37

What is update failure?

Question 38

What is view materialization?

Question 39

What is a multiuser DBMS?

Question 40

What is a recovery log?

Question 41

What is a query hint?

Question 42

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