What is a data dictionary?

• A type of database

• A repository of metadata

• A coding language

• A dictionary for words

Answer explanation

A data dictionary is a repository of metadata that provides information about data elements, their meanings, relationships, and usage within a database, making 'A repository of metadata' the correct choice.

What is the primary purpose of a data dictionary?

• To store data

• To write code

• To describe a table’s columns

• To create databases

Answer explanation

The primary purpose of a data dictionary is to describe a table’s columns, including their names, data types, and constraints. This helps users understand the structure and organization of the data.

Which of the following is NOT a common data type in a data dictionary?

• Float

• Date

• Image

• Integer

Answer explanation

The common data types in a data dictionary typically include Float, Date, and Integer, which represent numerical and temporal data. Image is not a standard data type in this context, making it the correct answer.

What does 'NULL' represent in a data dictionary?

• A boolean value

• A text value

• A non-existent or missing value

• A mandatory field

Answer explanation

'NULL' signifies a non-existent or missing value in a data dictionary, indicating that no data is present for that field. This distinguishes it from other types like boolean or text values.

Which of the following is an example of a numeric data type?

• Text

• Integer

• Varchar

• Char

Answer explanation

The correct answer is 'Integer' because it represents a numeric data type, specifically whole numbers. In contrast, 'Text', 'Varchar', and 'Char' are string data types, not numeric.

What is an active data dictionary?

• A dictionary that updates automatically with database changes

• A dictionary that requires manual updates

• A dictionary used for text data

• A dictionary stored in a document

Answer explanation

An active data dictionary automatically updates with changes in the database, ensuring that it reflects the current structure and metadata. This is crucial for maintaining accurate documentation and data management.

What is the main difference between active and passive data dictionaries?

• Passive dictionaries update automatically

• Passive dictionaries are used for text data

• Active dictionaries are stored in Excel

• Active dictionaries update automatically

Answer explanation

The main difference is that active dictionaries update automatically, reflecting real-time changes, while passive dictionaries do not. This makes active dictionaries more dynamic and useful for ongoing data management.

Which of the following is a character and string data type?

• Integer

• Date

• Boolean

• Char

Answer explanation

The correct answer is 'Char' because it represents a character data type, while the other options (Integer, Date, Boolean) represent different data types that do not specifically denote character or string values.

What is the purpose of abbreviating fields in a data dictionary?

• To make the dictionary more complex

• To simplify references to long names

• To store more data

• To create new data types

Answer explanation

Abbreviating fields in a data dictionary serves to simplify references to long names, making it easier for users to work with the data without confusion or excessive typing.

Which of the following is NOT a type of data object in a data dictionary?

• Views

• Tables

• Clusters

• Graphs

Answer explanation

Graphs are not a type of data object in a data dictionary. Data dictionaries typically include views, tables, and clusters, which are essential for defining and managing data structures.