Question 1

Given the tremendously expanding interest in Internet commerce,the importance of transaction processing is projected to diminish.

Accepted Answer

A) True 
 B)False

Question 2

Rules which are stored in the database security system defining authorized users,allowable operations and accessible parts of the database are called _______________________.

Accepted Answer

The answer of Rules which are stored in the database...

Question 3

Metadata can be found in the information resource dictionary.

Accepted Answer

A) True 
 B)False

Question 4

The SQL:2003 ____________________ statement allows you to define a new data type as a subset of a standard data type.

Accepted Answer

The answer of The SQL:2003 ____________________ statement allows you to...

Question 5

One of the responsibilities of the data administrator is to monitor the performance of the enterprise's databases.

Accepted Answer

A) True 
 B)False

Question 6

A(n)___________________ is a special database provided by the DBMS that tracks tables,columns,assertions,indexes,and other objects that are managed by the DBMS.

Accepted Answer

The answer of A(n)___________________ is a special database provided by...

Question 7

The data dictionary of a relational database is organized as a:

Accepted Answer

A)  relational database 
B)  file catalog similar to Windows' file catalog 
C)  hierarchical database 
D)  large file 
A)  relational database 
B)  file catalog similar to Windows' file catalog 
C)  hierarchical database 
D)  large file

Question 8

Which of the following statements is not true of triggers:

Accepted Answer

A)  The DBMS will automatically recompile a trigger if a referenced object is deleted 
B)  Triggers should not perform integrity constraints that can otherwise be performed with CHECK constraints and assertions 
C)  The choice between using a database trigger versus an application trigger is usually fairly clear 
D)  A and C are both not true 
A)  The DBMS will automatically recompile a trigger if a referenced object is deleted 
B)  Triggers should not perform integrity constraints that can otherwise be performed with CHECK constraints and assertions 
C)  The choice between using a database trigger versus an application trigger is usually fairly clear 
D)  A and C are both not true

Question 9

The SQL:2003 Definition_Schema and Information_Schema have not been implemented by most DBMSs.

Accepted Answer

A) True 
 B)False

Question 10

_____________________ is a term for the situation that exists in many organizations in which technology supports the local objectives of the organization but not the global objectives.

Accepted Answer

islands of

Question 11

The protection of databases from unauthorized access and malicious destruction is generally known as ___________________.

Accepted Answer

The answer of The protection of databases from unauthorized access...

Question 12

SQL:2003 ASSERTIONS are more powerful than CHECK constraints because they are not associated with a specific table,and they can involve a SELECT statement of any complexity.

Accepted Answer

A) True 
 B)False

Question 13

After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel1 may:

Accepted Answer

A)  Change the Salary of any Employee 
B)  Access the Salary of any Employee 
C)  Change the Salary of an Employee whose job is 'Clerk' 
D)  All of the above 
A)  Change the Salary of any Employee 
B)  Access the Salary of any Employee 
C)  Change the Salary of an Employee whose job is 'Clerk' 
D)  All of the above

Question 14

Although a DBA writes stored procedures and triggers to help manage databases,the primary responsibilities for a DBA are to manage stored procedures and triggers,not to write them.

Accepted Answer

A) True 
 B)False

Question 15

List the three components of the SQL:2003 GRANT statement: ______________________________

Accepted Answer

the privileges,the o

Question 16

The process of developing enterprise models of an organization's data,processes,and roles is called _______________________.

Accepted Answer

informatio

Question 17

Because benchmarks need to be specific to a particular organization's needs in order to be useful,an organization should develop their own benchmarks for DBMS evaluation.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is primarily used for security?

Accepted Answer

A)  Logical database design rules 
B)  Authentication rules 
C)  View integration 
D)  CREATE TABLE statements 
A)  Logical database design rules 
B)  Authentication rules 
C)  View integration 
D)  CREATE TABLE statements

Question 19

Data that describes the source,use,value,and meaning of other data is known as ______________.

Accepted Answer

The answer of Data that describes the source,use,value,and meaning of...

Question 20

The following three SQL statements are executed one after the other.
SQL#1:
CREATE VIEW Payroll
SELECT EmpName, Salary, Status
FROM Employee
Where Job NOT IN ('Manager', 'Supervisor')
SQL#2:
GRANT SELECT, UPDATE ON Payroll
To Personnel1, Personnel2
SQL#3:
REVOKE UPDATE on Payroll From Personnel2

-After execution of the commands SQL#1 and SQL#2,a member of the user group Personnel2 may:

Accepted Answer

A)  Change the Salary of any Employee 
B)  Access the Salary of any Employee 
C)  Change the Salary of an Employee whose job is 'Clerk' 
D)  All of the above 
A)  Change the Salary of any Employee 
B)  Access the Salary of any Employee 
C)  Change the Salary of an Employee whose job is 'Clerk' 
D)  All of the above

Given the tremendously expanding interest in Internet commerce,the importance of transaction processing is projected to diminish.

Rules which are stored in the database security system defining authorized users,allowable operations and accessible parts of the database are called _______________________.

Metadata can be found in the information resource dictionary.

The SQL:2003 ____________________ statement allows you to define a new data type as a subset of a standard data type.

One of the responsibilities of the data administrator is to monitor the performance of the enterprise's databases.

A(n)___________________ is a special database provided by the DBMS that tracks tables,columns,assertions,indexes,and other objects that are managed by the DBMS.

The data dictionary of a relational database is organized as a:

Which of the following statements is not true of triggers:

The SQL:2003 Definition_Schema and Information_Schema have not been implemented by most DBMSs.

_____________________ is a term for the situation that exists in many organizations in which technology supports the local objectives of the organization but not the global objectives.

The protection of databases from unauthorized access and malicious destruction is generally known as ___________________.

SQL:2003 ASSERTIONS are more powerful than CHECK constraints because they are not associated with a specific table,and they can involve a SELECT statement of any complexity.

After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel1 may:

Although a DBA writes stored procedures and triggers to help manage databases,the primary responsibilities for a DBA are to manage stored procedures and triggers,not to write them.

List the three components of the SQL:2003 GRANT statement: ______________________________

The process of developing enterprise models of an organization's data,processes,and roles is called _______________________.

Because benchmarks need to be specific to a particular organization's needs in order to be useful,an organization should develop their own benchmarks for DBMS evaluation.

Which of the following is primarily used for security?

Data that describes the source,use,value,and meaning of other data is known as ______________.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 14: Data and Database Administration

Given the tremendously expanding interest in Internet commerce,the importance of transaction processing is projected to diminish.

Rules which are stored in the database security system defining authorized users,allowable operations and accessible parts of the database are called _______________________.

Metadata can be found in the information resource dictionary.

The SQL:2003 ____________________ statement allows you to define a new data type as a subset of a standard data type.

One of the responsibilities of the data administrator is to monitor the performance of the enterprise's databases.

A(n)___________________ is a special database provided by the DBMS that tracks tables,columns,assertions,indexes,and other objects that are managed by the DBMS.

The data dictionary of a relational database is organized as a:

Which of the following statements is not true of triggers:

The SQL:2003 Definition_Schema and Information_Schema have not been implemented by most DBMSs.

_____________________ is a term for the situation that exists in many organizations in which technology supports the local objectives of the organization but not the global objectives.

The protection of databases from unauthorized access and malicious destruction is generally known as ___________________.

SQL:2003 ASSERTIONS are more powerful than CHECK constraints because they are not associated with a specific table,and they can involve a SELECT statement of any complexity.

After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel1 may:

Although a DBA writes stored procedures and triggers to help manage databases,the primary responsibilities for a DBA are to manage stored procedures and triggers,not to write them.

List the three components of the SQL:2003 GRANT statement: ______________________________

The process of developing enterprise models of an organization's data,processes,and roles is called _______________________.

Because benchmarks need to be specific to a particular organization's needs in order to be useful,an organization should develop their own benchmarks for DBMS evaluation.

Which of the following is primarily used for security?

Data that describes the source,use,value,and meaning of other data is known as ______________.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters