Exam 12: Databases, Controls, and Security

Data elements in a relational database are organized into ____.

Which of the following is NOT a factor that affects the risk of fraud?

When it is necessary to update one database copy with changes made to the other database,it is called _________.

The encoding of a message with a private key is called ____________________.

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if no non-key field is functionally dependent on any other non-key field.

A(n)____ is a field or set of fields stored in one table that also exists as a primary key in another table.

A control that checks the value of a field to ensure that it is within the correct range is a(n)_______ control.

Invented keys in a relational database are dangerous and require careful scrutiny.

Non-key ("bad")redundancy can be systematically identified and eliminated from a relational database by ____________________ of the database.

A model of fraud that states that opportunity,motivation,and rationalization must all exist for fraud to occur is called the ________.

A(n)______ control restricts which persons or programs can add,modify or view information.

In a database a two-dimensional data structure consisting of columns and rows is called a(n)_______.

A ____ database server architecture stores different parts of a database on different servers.

A relational database table is in ____________________ normal form if it has no repeating fields or groups of fields,i.e.if it has the same number of columns for every row.

Which is NOT an objective of integrity controls?

A(n)______ control is a control that rejects invalid inputs,prevent unauthorized outputs,and protects data and programs against tampering.

Explain how a digital certificate works.

In ____________________ encryption,the same key encrypts and decrypts the data.

_________________________ is a consistent relational database state in which every foreign key value also exists as a primary key value.

A(n)____________________ is a field or set of fields stored in one table that also exist as a primary key in another table.