Question 1

__________ is an organization that receives the encrypted data from a data owner and makes them available for distribution to clients.

Accepted Answer

A)  User
B)  Client
C)  Data owner
D)  Server D

Question 2

A __________ is a suite of programs for constructing and maintaining the database and for offering ad hoc query facilities to multiple users and applications.

Accepted Answer

database management system (DBMS)

Question 3

The database management system operates on the assumption that the
computer system has authenticated each user.

Accepted Answer

A) True 
 B)False  True

Question 4

A query language provides a uniform interface to the database.

Accepted Answer

A) True 
 B)False

Question 5

A _________ is the result of a query that returns selected rows and columns from one or more tables.

Accepted Answer

The answer of A _________ is the result of a...

Question 6

SQL Server allows users to create roles that can then be assigned access
rights to portions of the database.

Accepted Answer

A) True 
 B)False

Question 7

_________ is a model for enabling ubiquitous,convenient,on-demand network access to a shared pool of configurable computing resources that can be rapidly provisioned and released with minimal management effort or service provider interaction.

Accepted Answer

The answer of _________ is a model for enabling ubiquitous,convenient,on-demand...

Question 8

A foreign key value can appear multiple times in a table.

Accepted Answer

A) True 
 B)False

Question 9

The basic building block of a __________ is a table of data,consisting of rows and columns,similar to a spreadsheet.

Accepted Answer

A)  relational database
B)  query set
C)  DBMS
D)  perturbation

Question 10

Random-sample query is a simple output perturbation technique.

Accepted Answer

A) True 
 B)False

Question 11

In a discretionary access control environment database users are classified into three broad categories: administrator,end user other than application owner,and __________.

Accepted Answer

The answer of In a discretionary access control environment database...

Question 12

To create a relationship between two tables,the attributes that define the
primary key in one table must appear as attributes in another table,where they are referred to as a foreign key.

Accepted Answer

A) True 
 B)False

Question 13

The __________ cloud infrastructure is a composition of two or more clouds that remain unique entities but are bound together by standardized or proprietary technology that enables data and application portability.

Accepted Answer

A)  hybrid
B)  community
C)  private
D)  public

Question 14

Statistics are derived from a database by means of a ___________.

Accepted Answer

A)  characteristic formula
B)  compromise
C)  partition
D)  data perturbation

Question 15

A _________ is defined to be a portion of a row used to uniquely identify a row in a table.

Accepted Answer

A)  foreign key
B)  query
C)  primary key
D)  data perturbation

Question 16

In a relational database columns are referred to as _________.

Accepted Answer

The answer of In a relational database columns are referred...

Question 17

__________ is the process of performing authorized queries and deducing unauthorized information from the legitimate responses received.

Accepted Answer

A)  Perturbation
B)  Inference
C)  Compromise
D)  Partitioning

Question 18

In addition to granting and revoking access rights to a table,in a ___________ administration the owner of the table may grant and revoke authorization rights to other users,allowing them to grant and revoke access rights to the table.

Accepted Answer

The answer of In addition to granting and revoking access...

Question 19

The __________ is a human entity that presents requests (queries)to the system.

Accepted Answer

The answer of The __________ is a human entity that...

Question 20

Fixed server roles operate at the level of an individual database.

Accepted Answer

A) True 
 B)False

Exam 5: Database Security

__________ is an organization that receives the encrypted data from a data owner and makes them available for distribution to clients.

A __________ is a suite of programs for constructing and maintaining the database and for offering ad hoc query facilities to multiple users and applications.

The database management system operates on the assumption that the computer system has authenticated each user.

A query language provides a uniform interface to the database.

A _________ is the result of a query that returns selected rows and columns from one or more tables.

SQL Server allows users to create roles that can then be assigned access rights to portions of the database.

_________ is a model for enabling ubiquitous,convenient,on-demand network access to a shared pool of configurable computing resources that can be rapidly provisioned and released with minimal management effort or service provider interaction.

A foreign key value can appear multiple times in a table.

The basic building block of a __________ is a table of data,consisting of rows and columns,similar to a spreadsheet.

Random-sample query is a simple output perturbation technique.

In a discretionary access control environment database users are classified into three broad categories: administrator,end user other than application owner,and __________.

To create a relationship between two tables,the attributes that define the primary key in one table must appear as attributes in another table,where they are referred to as a foreign key.

The __________ cloud infrastructure is a composition of two or more clouds that remain unique entities but are bound together by standardized or proprietary technology that enables data and application portability.

Statistics are derived from a database by means of a ___________.

A _________ is defined to be a portion of a row used to uniquely identify a row in a table.

In a relational database columns are referred to as _________.

__________ is the process of performing authorized queries and deducing unauthorized information from the legitimate responses received.

In addition to granting and revoking access rights to a table,in a ___________ administration the owner of the table may grant and revoke authorization rights to other users,allowing them to grant and revoke access rights to the table.

The __________ is a human entity that presents requests (queries)to the system.

Fixed server roles operate at the level of an individual database.