Download ISM 575 Final Practice Exams 2024-2025 and more Exams Advanced Data Analysis in PDF only on Docsity!
ISM 575 Final Practice Exams 2024- 2025
__________ refers to a set of database technologies that are designed to address both structured and unstructured data that are potentially stored across various locations.
- HIPAA
- NoSQL
- SQL
- The relational model - ANS-NoSQL
One disadvantage of file processing systems is __________.
- Reduced data duplication
- Program-data independent
- Limited data sharing
- Enforcement of integrity constraints - ANS-Limited data sharing
Data processed in a way that increases a user's knowledge is __________.
- Text
- Graphics
- Information
- Hyperlink - ANS-Information
A __________ is a centralized knowledge base for all data definitions, data relationships, screen and report formats, and other system components.
- DDA
- Design tool
- Repository - ANS-Repository
Which of the following is not an advantage of the database approach to information management?
- Improved data consistency
- Enforcement of standards
- Improved data sharing
- Program-data dependence - ANS-Program-data dependence
Which of the following is a data quality tool that can be used to reduce the number of customers sent duplicate catalogs by an organization?
- Internet protocols
- Constraints
- External schema
- Data scrubbing - ANS-Data scrubbing
Which of the following is an integrated decision support database with content derived from various operational databases?
- Corporate data structure
- Relational DBMS
- Data warehouse
- Client-server system - ANS-Data warehouse
A rule that can NOT be violated by database users is called a(n) __________.
- Weak entity
- Derived entity - ANS-Weak entity
An associative entity is represented by a __________.
- Box
- Circle
- Diamond
- Rounded box - ANS-Rounded box
A property or characteristic of an entity type that is of interest to the organization is called a(n) __________.
- Attribute
- Coexisting entity
- Relationship
- Cross-function - ANS-Attribute
An attribute that can be broken down into smaller parts is called a(n) __________ attribute.
- Composite
- Associative
- Simple
- Complex - ANS-Composite
An attribute that can be calculated from related attribute values is called a(n) __________ attribute.
- Multivalued - ANS-Derived
Which of the following guidelines should be followed when selecting an identifier?
- Choose an identifier with values that will not change over time
- Choose an identifier that will not have null values
- Choose an identifier that is not composite
- All of the above - ANS-All of the above
A collection of two or more attributes that uniquely identify an entity is called a(n) __________.
- Composite attribute
- Composite identifier
- Identifying attribute
- Relationship identifier - ANS-Composite identifier
The number of entity types that participate in a relationship is called the __________ of the relationship.
- Number
- Identifying characteristics
- Degree
- Counter - ANS-Degree
A simultaneous relationship among the instances of three entity types is called a(n) __________ relationship.
- Ternary
- Tertiary
- Primary
- Binary - ANS-Ternary
The __________ rule specifies that an entity can be a member of only one subtype at a time.
- Exclusion
- Disjoint
- Removal
- Inclusion - ANS-Disjoint
An attribute of a supertype that determines the target subtype(s) is called the ________.
- Determinant
- Subtype decision
- Disjoint indicator
- None of the above - ANS-None of the above
The __________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.
- Disjoint
- Overlap
- Partial specialization
- Total specialization - ANS-Overlap
In a supertype/subtype hierarchy, each subtype has __________.
- Exactly one supertype
- Many supertypes
- At most two supertypes
- At least one subtype - ANS-Exactly one supertype
An entity cluster is __________.
- A formal method for specifying attributes of related entities
- A set of one or more entity types and associated relationships grouped into a single abstract entity type
- A useful way of presenting data for a small and fairly simple organization
- A way of developing a more granular views of the data model - ANS-A set of one or more entity types and associated relationships grouped into a single abstract entity type
A double line extending from an entity type to the circle below the entity type indicates that the __________ rule applies to a supertype/subtype relationship.
- Disjoint rule
- Overlap rule
- Partial specialization
- Total specialization - ANS-Total specialization
An attribute or attributes that uniquely identify each row in a relation is called a __________.
- Column
- Foreign key
- Primary key
- Duplicate key - ANS-Primary key
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a __________.
- Link attribute
- Link key
- Foreign key
- Foreign attribute - ANS-Foreign key
A __________ is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.
- Transitive dependency
- Partial nonkey dependency
- Partial functional dependency
- Determinant - ANS-Partial functional dependency
Which of the following is not a problem that can occur when integrating relations during the process of merging relations.
- Synonyms
- Transitive dependencies
- Normalization
- Supertype/subtype relationships - ANS-Normalization
The primary key of the relation ORDER_LINE is the composite of Order_Number and Part_Number. The non-key attributes of the ORDER_LINE relation are Part_Description, Number_Ordered, and Quoted Price. The attribute Part_Description is functionally dependent on Part_Number. In what normal form in the ORDER_LINE relation?
- First (but not second) normal form
- Second (but not third) normal form
- Third normal form
- None of the above - ANS-First (but not second) normal form
The primary key of the relation PART is the attribute Part_Number. The non-key attributes of the PART relation are Part_Description, Units_On_Hand, Item_Class, Warehouse_Number, Warehouse_Name, and Unit_Price. The attribute Warehouse_Name is dependent on Warehouse_Number. In what normal form is the PART relation?
- First (but not second) normal form
- Second (but not third) normal form
- Third normal form
- None of the above - ANS-Second (but not third) normal form
A coding scheme recognized by database management software for representing data is called a __________.
- DBMS code
- Data type
- SQL
- DB layout - ANS-Data type
Which of the following should be an objective when selecting a data type?
- Representing a small number of possible values
- Maximizing storage space
- Limiting security
- Supporting all required data manipulation - ANS-Supporting all required data manipulation
__________ limits the set of permissible values a field may assume.
- Substitute estimates
- Security
- Range control
- Sensitivity testing - ANS-Range control
Which of the following is not a way of controlling data integrity?
- Default values
- Range control
- Null value control
- Student_First_Name
- Student_Middle_Name
- Student_Last_Name
- Student_Date_of_Birth - ANS-Student_Middle_Name
The database table STUDENT has the fields Student_ID, Student_First_Name, Student_Middle_Name, Student_Last_Name, and Student_Date_of_Birth. The primary key of the table is Student_ID. The university registrar frequently creates reports listing students in alphabetical order by last name. An index created on the __________ field would be most likely to speed up the creation of these reports.
- Student_ID
- Student_First_Name
- Student_Middle_Name
- Student_Last_Name
- Student_Date_of_Birth - ANS-Student_Last_Name
A __________ is the value that a field will assume unless a user enters an explicit value for an instance of that field.
- Default value
- Range control
- Null value control
- Validation rule - ANS-Default value
