Question 1

What is data backup?

Accepted Answer

Data backup refers to the prac

Question 2

What is a data dictionary?

Accepted Answer

A data dictionary is a repository of the

Question 3

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;

Accepted Answer

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 
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 4

What is the query cost?

Accepted Answer

The query cost is th

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

What is update failure?

Accepted Answer

Update failure is th

Question 7

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;

Accepted Answer

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 
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 8

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

Accepted Answer

A) True 
 B)False

Question 9

What is a recovery log?

Accepted Answer

A recovery log is a file recorded to the

Question 10

The data manipulation DBMS component is used:

Accepted Answer

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 
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 11

What is view materialization?

Accepted Answer

View materialization refers to saving a

Question 12

What is a complete mirrored backup?

Accepted Answer

A complete mirrored backup is

Question 13

What is a query hint?

Accepted Answer

A query hint is a suggestion f

Question 14

Which of the following is NOT a data administration task?

Accepted Answer

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 
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

Question 15

What is database recovery?

Accepted Answer

Database recovery re

Question 16

What is a multiuser DBMS?

Accepted Answer

In a multiuser DBMS,the data m

Question 17

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:

Accepted Answer

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

Question 18

What is a query optimizer?

Accepted Answer

A query optimizer is a feature

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

What is data backup?

What is a data dictionary?

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;

What is the query cost?

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

What is update failure?

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;

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

What is a recovery log?

The data manipulation DBMS component is used:

What is view materialization?

What is a complete mirrored backup?

What is a query hint?

Which of the following is NOT a data administration task?

What is database recovery?

What is a multiuser DBMS?

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:

What is a query optimizer?

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

The data manipulation 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 data backup?

What is a data dictionary?

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;

What is the query cost?

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

What is update failure?

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;

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

What is a recovery log?

The data manipulation DBMS component is used:

What is view materialization?

What is a complete mirrored backup?

What is a query hint?

Which of the following is NOT a data administration task?

What is database recovery?

What is a multiuser DBMS?

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:

What is a query optimizer?

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

The data manipulation 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