QUIZ 1.docx

**Question 1\ ***Statement:* After processing --- such as formatting and printing --- output data can again be perceived as information.\ **Answer:** True **Question 2\ ***Statement:* Information is produced by processing data.\ **Answer:** True **Question 3\ ***Question:* It combines all rows fro...

**Question 1\ ***Statement:* After processing --- such as formatting and printing --- output data can again be perceived as information.\ **Answer:** True **Question 2\ ***Statement:* Information is produced by processing data.\ **Answer:** True **Question 3\ ***Question:* It combines all rows from two tables, excluding duplicate rows. - - - - **Question 4\ ***Question:* A candidate key must satisfy all of the following conditions EXCEPT: - - - - **Question 5\ ***Question:* Responsible for authorizing access to the database, for coordinating and monitoring its use, and for acquiring software and hardware resources as needed. - - - - **Question 6\ ***Question:* It yields all values for selected attributes, a vertical subset of a table. - - - - **Question 7\ ***Statement:* Raw data may not be properly formatted for storage, processing, and presentation.\ **Answer:** False (Correct Answer) **Question 8\ ***Statement:* A foreign key is an attribute or combination of attributes in a relation whose value matches a primary key in another relation.\ **Answer:** True **Question 9\ ***Question:* These databases are used by groups or departments within larger corporations, or by small businesses. - - - - **Question 10\ ***Question:* The table to which a foreign key refers is known as \_\_\_\_\_\_\_\_\_\_\_\_\_\_. - - **Question 11\ ***Question:* A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a \_\_\_\_\_\_\_\_ dependency. - - - - **Question 12\ ***Question:* First DBMS designed by Charles Bachman at General Electric and was called \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_. - - - If you need me to break down more questions or sections of the test in this style, let me know! 4o ##### **You said:** ALL OF IT ###### **ChatGPT said:** ChatGPT Here's the detailed breakdown of your answers, including the questions, choices, and correct answers: **1. After processing \-- such as formatting and printing \-- output data can again be perceived as information.** - - **2. Information is produced by processing data.** - - **3. It combines all rows from two tables, excluding duplicate rows.** - - - - **4. A candidate key must satisfy all of the following conditions EXCEPT:** - - - - **5. Responsible for authorizing access to the database, for coordinating and monitoring its use, and for acquiring software and hardware resources as needed.** - - - - **6. It yields all values for selected attributes, a vertical subset of a table.** - - - - **7. Raw data may not be properly formatted for storage, processing, and presentation.** - - **8. A foreign key is an attribute or combination of attributes in a relation whose value matches a primary key in another relation.** - - **9. These databases are used by groups or departments within larger corporations, or by small businesses.** - - - - **10. The table to which foreign key refers is known as:** - - **11. A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a:** - - - - **12. First DBMS designed by Charles Bachman at General Electric and was called:** - - - - **13. A cascading delete removes all records in other tables associated with the record to be deleted.** - - **14. Which of the following are properties of relations?** - - - - **15. A homonym is the opposite of a synonym and indicates the use of different names to describe the same attribute.** - - **16. There can be multivalued attributes in a relation.** - - **17. Relation is the association between tables.** - - **18. Information is a collection of facts, while data puts those facts into context.** - - **19. In the relational model, keys are important because they are used to ensure that each row in a table is uniquely identifiable.** - - **20. Sometimes referred to as a transactional or production database.** - - - - **21. The following items are disadvantages of databases, EXCEPT:** - - - - - **22. Secondary keys are also called alternate keys.** - - **23. DBMS systems offer features that ensure that in case of data loss due to hardware failure, human error, or other unforeseen events, data can be restored to a previous state.** - - - - **24. A database that supports data located at a single site.** - - - - **25. Which of the following are anomalies that can be caused by redundancies in tables?** - - - - **26. The tables may not have the same attribute characteristics to be used in the UNION.** - - **27. A key consists of only one attribute that determines other attributes.** - - **28. These users primarily work in isolation and do not rely heavily on networked or interconnected functionalities.** - - - - **29. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:** - - - - **30. Refers to all the single items that are stored in a database, either individually or as a set.** - - - - **31. A DBMS enforces \_\_\_\_\_\_\_\_\_\_\_\_\_\_ constraints, ensuring that data entered into the database follows predefined rules and formats.** - - - - **32. Data processed to increase knowledge in the person using the data.** - **33. One property of a relation is that each attribute within a relation has a unique name.** - - **34. He proposed a new data representation framework called the relational data model.** - - - - **35. The attribute on the left-hand side of the arrow in a functional dependency is the:** - - - - **36. The process of data transformation can also be referred to as ETL, which stands for:** - - - - **Question 38: Storehouse of data.\ Correct Answer:** DATABASE\ **Incorrect Answer Given:** REPOSITORY **Question 39: A software system that is used to create, maintain, and provide controlled access to user databases.\ Correct Answer:** DATABASE MANAGEMENT SYSTEM **Question 40: The table in which foreign key is created is called as \_\_\_\_\_\_\_\_\_\_\_\_.\ Correct Answer:** dependent table\ **Choices Provided:** - - **Question 41: It yields only the rows that appear in both tables.\ Correct Answer:** INTERSECT\ **Choices Provided:** - - - - **Question 42: They concentrate on planning and creating the conceptual and logical design of a database system.\ Correct Answer:** DBMS System Designers\ **Choices Provided:** - - - - **Question 43: A composite key consists of only one attribute.\ Correct Answer:** False\ **Incorrect Answer Given:** True **Question 44: Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.\ Correct Answer:** False\ **Incorrect Answer Given:** True **Question 45: The columns of a relation can be interchanged without changing the meaning or use of the relation.\ Correct Answer:** True\ **Incorrect Answer Given:** False **Question 46: An attribute (or attributes) that uniquely identifies each row in a relation is called a:\ Correct Answer:** primary key\ **Choices Provided:** - - - - **Question 47: Operating system manages data resources like an DBMS manages hardware resources.\ Correct Answer:** False\ **Choices Provided:** - - **Question 48: When information is compiled or used to better understand something or to do something, it becomes knowledge.\ Correct Answer:** True\ **Choices Provided:** - - **Question 49: A foreign key is a primary key of a relation that also is a primary key in another relation.\ Correct Answer:** False\ **Incorrect Answer Given:** True **Question 50: It yields all possible pairs of rows from two tables.\ Correct Answer:** PRODUCT\ **Choices Provided:** - - - - **Question 51: A rule that states that each foreign key value must match a primary key value in the other relation is called the:\ Correct Answer:** referential integrity constraint\ **Choices Provided:** - - - - **Question 52: A primary key that consists of more than one attribute is called a:\ Correct Answer:** composite key\ **Choices Provided:** - - - - **Question 53: The data dictionary contains metadata---data about data.\ Correct Answer:** True\ **Choices Provided:** - - **Question 54: Smallest unit amount of data.\ Correct Answer:** BIT, BITS\ **Incorrect Answer Given:** RAW DATA **Question 55: This type of database is used by the entire organization and supports many users (more than 50, usually hundreds).\ Correct Answer:** enterprise database\ **Choices Provided:** - - - - **Question 56: SQL was standardized in what year? Also, in this year, the current standard, SQL-92, was adopted by the American National Standards Institute (ANSI) and International Standards Organization (ISO).\ Correct Answer:** late 1980s\ **Incorrect Answer Given:** late 1990s **Question 57: Two or more attributes having different names but the same meaning are called:\ Correct Answer:** synonyms\ **Choices Provided:** - - - - **Question 58: When information is entered into and stored in a computer, it is generally referred to as data.\ Correct Answer:** True\ **Choices Provided:** - - **Question 59: A constraint between two attributes is called a(n):\ Correct Answer:** functional dependency\ **Choices Provided:** - - - - **Question 60: They determine the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements.\ Correct Answer:** System analysts\ **Choices Provided:** - - - - **Question 61: Personnels who are responsible for the actual running and maintenance of the hardware and software environment for the database system.\ Correct Answer:** Operators and Maintenance Personnel\ **Choices Provided:** - - - - **Question 62: The database dictionary provides a detailed description of all tables found within the user/designer-created database.\ Correct Answer:** False\ **Choices Provided:** - - **Question 63: A two-dimensional table of data sometimes is called a:\ Correct Answer:** relation\ **Choices Provided:** - - - - **Question 64: Data that describes the properties and context of user data.\ Correct Answer:** METADATA **Question 65: In the relational data model, associations between tables are defined through the use of primary keys.\ Correct Answer:** False\ **Choices Provided:** - - **Question 66: They are capable of using advanced features and functionalities of a system, application, or technology.\ Correct Answer:** Sophisticated End Users\ **Choices Provided:** - - - - **Question 67: In a database context, the word homonym indicates the use of the same attribute name to label different attributes.\ Correct Answer:** True\ **Choices Provided:** - - **Question 68: Limitations of File System Data Processing:\ Choices Provided:** - - - - - - - - **Question 69: Exciting career opportunities within the field of database management:\ Choices Provided:** - - - - - - - - **Question 70: They are individuals who use a product, service, or technology without an in-depth understanding of its underlying technical complexities.\ Correct Answer:** Casual end-users\ **Choices Provided:** - - - - **Question 71: A database system that is designed to be used by only one user at a time. It is typically installed on a single computer and can only be accessed by the user who installed it or the user who is currently logged in.\ Correct Answer:** single-user database\ **Choices Provided:** - - - - **Question 72: The allowable range of values for a given attribute is part of the domain constraint.\ Correct Answer:** True\ **Choices Provided:** - - **Question 73: A collection of bytes.\ Correct Answer:** FIELD **Question 74: In Late 1960s​, IBM developed the \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ DBMS, used even today in many major installations.\ Correct Answer:** Information Management System (IMS) **Question 75: A primary key value must be unique.\ Correct Answer:** True\ **Choices Provided:** - - **Question 76: It yields all rows in one table that are not found in the other table.\ Correct Answer:** DIFFERENCE\ **Choices Provided:** - - - -