Question 1

COGNITIVE ASSESSMENT What is another term for data dictionary?

Accepted Answer

A data dictionary is often referred to as a repository because it stores metadata about the data, such as definitions, relationships, and formats.

Question 2

COGNITIVE ASSESSMENT Your database was damaged due to hardware failure. What can you use to restore it?

Accepted Answer

A backup is a copy of data stored separately that can be used to restore the original data in case of loss or damage.

Question 3

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Accepted Answer

Validation is the process of comparing data with a set of rules or values to determine if the data is correct.

Question 4

COGNITIVE ASSESSMENT Which of the following is true about the database approach?

Accepted Answer

The answer of COGNITIVE ASSESSMENT Which of the following is...

Question 5

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

Accepted Answer

Megan's Law was designed to create a registry of individuals convicted of crimes against children, making their information available to the public to enhance community safety.

Question 6

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

Accepted Answer

A log is a record of all activities that modify the contents of a database, used for recovery and auditing purposes.

Question 7

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

Accepted Answer

A front end is a user-friendly interface that allows users to interact with a database management system (DBMS) without needing to understand the complexities of the DBMS itself.

Question 8

COGNITIVE ASSESSMENT Which of the following statements is not true about report writers?

Accepted Answer

Most modern Database Management Systems (DBMS) include report writing capabilities, making it common rather than rare.

Question 9

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

Accepted Answer

A wizard in a database context is a tool that guides users through the steps of creating or modifying database objects, making the process easier and more user-friendly.

Question 10

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Accepted Answer

A form is a window on the screen that provides areas for entering or modifying data in a database.

Question 11

COGNITIVE ASSESSMENT A data dictionary contains details about data. What term is used to describe this characteristic?

Accepted Answer

Metadata is the term used to describe data that provides information about other data, such as details contained in a data dictionary.

Question 12

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

Accepted Answer

Setting Durham as the default value will automatically fill the field with "Durham" for each new entry, simplifying the data entry process for students living in Durham.

Question 13

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Accepted Answer

Completeness checks are used to ensure that required fields contain data and meet minimum character requirements.

Question 14

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Accepted Answer

The principle of least privilege is a security concept that states that users should only be granted the minimum level of access necessary to perform their tasks. This helps to reduce the risk of unauthorized access to sensitive data.

Question 15

COGNITIVE ASSESSMENT Which of the following does not improve with the database approach?

Accepted Answer

Data security is not improved with the database approach.

Question 16

COGNITIVE ASSESSMENT What is data redundancy?

Accepted Answer

Data redundancy occurs when the same piece of data is stored in multiple places, which is common when each department maintains its own files.

Question 17

COGNITIVE ASSESSMENT Which of the following statements is NOT true about the database approach?

Accepted Answer

The database approach eliminates isolated data by integrating data into a centralized system, which is one of its main advantages.

Question 18

COGNITIVE ASSESSMENT What database term is used to describe a request for specific data from the database?

Accepted Answer

A query is a request for specific data from a database.

Question 19

COGNITIVE ASSESSMENT If you are running a check that applies a formula to the primary key, what kind of check are you running?

Accepted Answer

A check digit is a form of redundancy check used for error detection on identification numbers, which are often primary keys. It involves applying a formula to the primary key to verify its accuracy.

Question 20

COGNITIVE ASSESSMENT What does the S in SQL stand for?

Accepted Answer

SQL stands for Structured Query Language, where "Structured" refers to the way the language is designed to manage and manipulate structured data in databases.

Quiz 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing