MSA 8040 MIDTERM EXAM 2025 QUESTIONS WITH 100% VERIFIED ANSWERS

Data and information are essentially the same thing - Correct Ans-False Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. - Correct Ans-False raw facts of interest to the end user - Correct Ans-End-user data is ____. a. raw facts of interest to the end-user DBMS - Correct Ans-_____ serve as the intermediary between the user and the database a. DBMSs b. Metadata c. End-user data d. Programming languages Semistructured - Correct Ans-An XML database supports the storage and management of _____ XML data. a. structured b. multistructured c. fullystructured d. Semistructured File - Correct Ans-A _____ is a collection of related records. Data integrity - Correct Ans-_____ is defined as the condition in which all of the data in the database are consistent with the False - Correct Ans-An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. False - Correct Ans-Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. In an SQL-based relational database, each table is dependent on every other table. - Correct Ans-False The external model is the representation of the database as "seen" by the DBMS. - Correct Ans-False A(n) _____ is the equivalent of a field in a file system. - Correct Ans-attributes _____ are important because they help to ensure data integrity. - Correct Ans-constraints In the _____ model, the basic logical structure is represented as an upside-down tree. - Correct Ans-hierarchical MySQL is an example of the _____. - Correct Ans-relational data model A(n) _______ enables a database administrator to describe schema components. - Correct Ans-DDL The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage. - Correct Ans-True the 3NF and the BCNF - Correct Ans-When a table contains only one candidate key, _____ are considered to be equivalent. data integrity - Correct Ans-_____ is defined as the condition in which all of the data in the database are consistent with real-world events and conditions False - Correct Ans-SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language. False - Correct Ans-normalization is a process that is used for changing attributes to entities cardinality - Correct Ans-____ Expresses the minimum and maximum number of entity occurrences associated with one occurrence of related entity inner join - Correct Ans-A(n) ____ only returns matched records from the tables that are being joined -2 because rounds up the nearest whole number - Correct Ans-what's the result for Select Ceil(-1.5)in my SQL foreign key - Correct Ans-A____is the primary key of one table that has been placed into another table to create a common attribute False - Correct Ans-Data is the result of processing raw facts to reveal its meaning. Foreign key - Correct Ans-A___ is the primary key of one table that has been placed into another table to create a common attribute provide fault tolerance - Correct Ans-noSQL database object-oriented - Correct Ans-the___data model uses the concept of inheritance True - Correct Ans-A data model is us False - Correct Ans-An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. True - Correct Ans-An implementation-ready data model should contain a description of the data structure that will store the end-user data Outer joins - Correct Ans-_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems. SELECT - Correct Ans-_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. system catalog - Correct Ans-The _____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents. integrity - Correct Ans-Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. data dictionary - Correct Ans-A(n) _____ provides a detailed description of all tables found within the user/designer-created database. index - Correct Ans-A(n) _____ is an orderly arrangement used to logically access rows in a table. secondary - Correct Ans-A _____ key is defined as a key that is used strictly for data retrieval purposes. candidate - Correct Ans-A primary key is a(n) ______ key chosen to be the primary means by which rows of a table are uniquely identified. inner join - Correct Ans-A(n) _____ only returns matched records from the tables that are being joined. column - Correct Ans-Each table _____ represents an attribute. superkey - Correct Ans-A _____ is any key that uniquely identifies each row. NOT NULL - Correct Ans-The _____ constraint can be placed on a column to ensure that every row in the table has a value for that column. M:N - Correct Ans-_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities. foreign - Correct Ans-The proper use of ________ keys is crucial to controlling data redundancy. unique - Correct Ans-A(n) _______ index is an index in which the index key can have only one pointer value (row) associated with it. keys - Correct Ans-In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable 1:1 - Correct Ans-The _____ relationship should be rare in any relational database design. 1:M - Correct Ans-The _____ relationship is the "relational model ideal." False - Correct Ans-In an SQL-based relational database, each table is dependent on every other table.(T/F) True - Correct Ans-M:N relationships are not