Databases And Information Systems! Glossary Trivia Quiz

A data dictionary is a tool that provides a detailed description of each field in a database. It includes information such as the data type, length, constraints, and purpose of each field. This helps users understand the structure and meaning of the data stored in the database, ensuring accuracy and consistency in data management.

The given correct answer is "2,2. Character,Character". This answer suggests that the smallest unit of data entered into a field is a character. The repetition of "2,2" indicates that there are two characters being entered into the field.

A distributed database refers to a database that is stored on multiple computers or nodes within a network. This allows for data to be distributed and replicated across different locations, providing benefits such as improved scalability, availability, and fault tolerance. By storing data on multiple computers, a distributed database can handle large volumes of data and accommodate high levels of concurrent access. Additionally, distributing the database enhances data reliability and reduces the risk of data loss or system failure.

The given answer "10,10. Entity,Entity" suggests that the specific category or group of objects within a database is referred to as an entity. The numbers 10,10 might be irrelevant or unrelated to the question and can be ignored.

This answer suggests that the data was created by linking together information from two different tables. The numbers 22,22 could represent the primary keys or unique identifiers from each table, and "Relationship" could refer to the type of connection or association between the linked data.

The given answer states that sorting is the process of placing data records into a set order based on the contents of one or more fields. This means that sorting involves arranging data in a specific order, such as ascending or descending, based on the values in certain fields. This process helps in organizing and retrieving data more efficiently, making it easier to search and analyze.

Encryption is the process of converting data into a format that is unreadable by unauthorized users. It ensures that sensitive information stored in a database remains secure and protected from unauthorized access. By using encryption techniques, the data is transformed into a coded form that can only be deciphered with the correct encryption key. This helps to prevent data breaches and maintain the confidentiality and integrity of the stored data.

Data validation refers to the process of checking for errors in data entry, such as spelling mistakes or keying errors. It ensures that the data entered into a system or database is accurate, consistent, and reliable. By validating the data, organizations can avoid the negative consequences of incorrect or incomplete information, such as flawed analysis, decision-making, or reporting. Data validation helps maintain data integrity and ensures that the data meets the required standards and criteria.

Metadata refers to data that provides information about other data. It describes various attributes of the data such as its format, structure, quality, and meaning. In this case, the given answer "16,16. Metadata,Metadata" indicates that the data being described is "16" and the metadata associated with it is "Metadata". This suggests that the metadata provides additional details or context about the value "16".

The correct answer is "11,11. Field size, Field size." This answer suggests that the number of characters allowed in a field is 11 and the term used to describe this is "Field size." The repetition of the answer options reinforces the idea that both parts of the answer are correct.

Data mining is the process of analyzing large volumes of data in order to discover hidden patterns, relationships, and insights. It involves using various techniques and algorithms to extract valuable information from the data, which can then be used for decision-making, prediction, and optimization purposes. Data mining is widely used in various industries such as finance, marketing, healthcare, and telecommunications to gain a competitive advantage and make informed business decisions.

The correct answer is 24,24. Schema,Schema. A schema is a diagram that shows how tables and their data fields are linked. It provides a visual representation of the structure and relationships between different tables in a database. By looking at the schema, one can understand how the data is organized and how different tables are connected through keys and relationships.

The given correct answer is "27, 27. SQL, SQL". This answer suggests that the standard language used to manipulate data in databases is SQL. SQL stands for Structured Query Language and it is widely used for managing and manipulating relational databases. The repetition of the answer suggests that it is a commonly known and widely accepted answer.

The given answer is correct because a foreign key is a column or a set of columns in a table that refers to the primary key of another table. It establishes a relationship between two tables and ensures referential integrity. In this case, the attribute mentioned is the primary key of another table, making it a foreign key.

This answer suggests that the database file mentioned in the question is designed in a way that requires accessing each record in a sequential order, starting from the first record and moving to the last record. This means that you cannot skip or jump to a specific record directly, but must go through each record in the order they are stored in the file. Therefore, the correct answer is 25,25, indicating that the database file follows a sequential access method.

Special characters placed in the search string to match a variable number of unknown characters are called wildcards. Wildcards are used to broaden the search by allowing for variations in spelling, word endings, or unknown characters. In this case, the answer is 30,30 and "Wildcard" because it accurately describes the concept of using special characters to match unknown characters in a search string.

The given answer "21,21. Relational,Relational" suggests that the operators mentioned in the question (greater than, not equal to, begin with, and contain) are all examples of relational operators. Relational operators are used to compare values and determine the relationship between them. Therefore, it is logical to conclude that these operators fall under the category of relational operators.

Normalization is a set of rules that aim to eliminate redundancy of data in a database. It is a process that organizes data in a structured manner, ensuring that each piece of information is stored only once. This helps to improve the efficiency and accuracy of the database, as well as reduce the chances of data inconsistencies or anomalies. By following normalization rules, databases can be designed to be more flexible, scalable, and maintainable.

An attribute is a defined property of an entity. It represents a characteristic or feature that describes the entity. Attributes provide more information about the entity and help in identifying and distinguishing it from other entities. In this case, the answer 1,1 indicates that the defined property of the entity is an attribute, and the repetition of "Attribute" further emphasizes this.

The given answer is correct because a telephone directory is an example of a manual method of organizing data. It is a physical book that contains a list of names, addresses, and telephone numbers arranged in alphabetical order. This manual method does not involve the use of technology or software to organize the data, but rather relies on a printed book that can be easily accessed and referenced.

The given correct answer states that the view of a table in a database that displays photos stored in a field is "Form view". This means that when viewing the table, the photos will be displayed in a form format, which typically includes fields for each attribute of the photo, such as title, date, and description. This allows the user to easily see and interact with the photo data in a structured manner.

A key field is a field in a database that contains unique data for each record. This means that each record in the database will have a different value in the key field, allowing for easy identification and retrieval of specific records. In this case, the number 14 is given as an example, indicating that the key field in question has a value of 14 for both records.

The given answer "15,15. Logical,Logical" suggests that the operator being referred to is the logical operator AND. This operator allows two or more queries to be combined by specifying that all conditions must be met in order for the combined query to be true. In this case, the number 15 is used to demonstrate that both queries are being combined using the logical operator AND.

The given answer "19, 19. Query, Query" is a response to the instruction to locate certain records in a database. It suggests that the instruction is to search for records with the value "19" in a specific field, and the type of search to be performed is a "Query". The repetition of "19" and "Query" implies that the instruction is to search for multiple records with the value "19" using the same type of query.

The correct answer is "Offsite". Offsite refers to the practice of storing data in a location separate from the primary site where it is generated or used. This is done to protect the data from theft and destruction. By keeping data offsite, organizations can ensure that even if their primary site is compromised, the data remains safe and accessible.

A row in a table represents a record, and in the context of database management systems, this is commonly referred to as a tuple. A tuple is a collection of attributes that represents a single instance of an entity. In this case, the correct answer is "Tuple" because it accurately describes the concept of a row in a table representing a record.

Data integrity refers to the accuracy, consistency, and reliability of data stored in a database. It ensures that the data is complete, valid, and reliable, without any inconsistencies or errors. Data integrity is crucial for maintaining the quality and trustworthiness of the database, as it ensures that the data remains intact and reliable throughout its lifecycle. By enforcing data integrity constraints, such as unique keys, referential integrity, and data validation rules, databases can prevent data corruption and maintain the integrity of the stored data.

The given answer "23,23. Report,Report" is correct because it accurately represents the concept of a report. A report is a method of displaying information from a database for a specific purpose. In this case, the answer includes the numbers "23,23" which could represent specific data or parameters used in the report, followed by the word "Report" repeated twice to emphasize the nature of the display.

Direct access is a method of accessing data stored on a disk where the data can be accessed directly without having to sequentially read through all the preceding data. It allows for random access to any location on the disk, making it efficient for retrieving specific data quickly. In this case, the answer "7,7. Direct access,Direct access" indicates that direct access is the correct method for accessing data stored on a disk.

The given answer "20,20. Record,Record" suggests that the collection of related fields is represented by the numbers 20,20 and the word "Record" is repeated twice. This implies that the collection consists of two fields, both labeled as "Record".