Exam 14: Data and Database Administration

In the process known as ______________,an algorithm converts data from plaintext into ciphertext to obscure its meaning.

The operational level of management deals with individual transactions and exception reports.

Strategic management would be mostly interested in the following type of data:

The data administrator (DA)is a support role with responsibilities related to individual databases and DBMSs.

___________________ rules are checked when a user first connects to a DBMS.

A database that contains metadata describing the entire information systems life cycle is known as a(n)____________________.

A(n)____________________ is a workload used to evaluate the performance of a system or product.

In a DBMS environment,processing can be distributed over different computers,but the data itself cannot be distributed.

The following level of management deals with external data sources and summarized tactical databases:

The cost of switching to a different DBMS may include data conversion,software recoding,and retraining employees,and can be much higher than the original purchase price of the DBMS.

With discretionary access control,users may be individually given access rights to specific data,or these access privileges may be granted to groups of users.

Distributed environments can be used to support transaction processing,but not data warehousing.

Prior to the final DBMS selection process,the top two or three candidates should be evaluated against a set of benchmarks.

The SQL:2003 statement to create a user role that is allowed to assign their role to another user is ________________________.

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,SQL#2,and SQL#3,a member of the user group Personnel2 may:

One method to ensure data integrity that involves row conditions on columns of the same table is to use a __________ constraint in the CREATE TABLE statement.

In distributed database environments,the word "distributed" refers to the fact that database administration responsibilities may be distributed among various database administrators.

One of the main problems with the independent development of separate operational databases is that decision-making information for the overall organization is not readily available.

For remotely stored procedures and functions,when ____________________ dependency maintenance is used,the DBMS will recompile a dependent object when any change is made to the referenced objects.

Tables with the names USERS,DOMAINS,COLUMNS,and REFERENTIAL_CONSTRAINTS would be examples of important ________________________ found in the SQL:2003 Definition_Schema.