2ND EXAM REVIEWER Flashcards
Which of the following is responsible for the daily operation of the database?
a. Data definition language
b. Data query language
c. Data manipulation language
d. Data dictionary
c. Data manipulation language
Which element of the database approach provides a controlled environment to assist and prevent the user from accessing and updating the data?
a. Data dictionary
b. Data management system
c. Database administrator
d. Physical database
b. Data management system
What is the data of the data, or metadata?
a. Data dictionary
b. Data management system
c. Database administrator
d. Physical database
a. Data dictionary
Which of the following is used to generate reports like financial statements?
a. Data definition language
b. Data query language
c. Data manipulation language
d. Data dictionary
b. Data query language
Statement I. Incorrect database data can lead to bad decisions, embarrassment, and angry users.
Statement II. A DBMS is a set of integrated computer programs designed to simplify the tasks of creating, accessing, and managing a database.
Statement III. The physical database view is how the data appear to the user to be stored.
a. All statements are true
b. One statement is true
c. All statements are false
d. One statement is false
d. One statement is false
Statement I. MySQL and Microsoft Access are examples of a database
Statement II. The database administrator (DBA) is responsible for coordinating, controlling, and
managing the Database.
Statement III. The database administrator (DBA) is responsible for coordinating, controlling, and
managing the Database.
a. All statements are true
b. One statement is true
c. All statements are false
d. One statement is false
a. All statements are true
The database environment can be broken down into four primary elements except:
a. Database management system
b. Physical database
c. User application programs
d. Database administrator
c. User application programs
In a database system, relationships, such as the association between selling costs and promotional campaigns, can be explicitly defined and used in the preparation of management reports, this feature is a manifestation of what database approach advantage according to Romney (2015)?
a. Cross-functional analysis
b. Minimal data redundancy
c. Data integration
d. Data independence
a. Cross-functional analysis
According to Romney (2015), using database approach facilitates programming and simplified data management because each data and the programs can be changed without changing the other, this refers to __
a. Cross-functional analysis
b. Minimal data redundancy
c. Data integration
d. Data independence
d. Data independence
This method of database access is only for limited users who are knowledgeable in a query language and requires no formal user programs
a. Database query
b. Direct query
c. User application program
d. Direct user authorization
b. Direct query
What is the primary purpose of the relational database model?
a. To store unstructured data
b. To optimize data retrieval speed
c. To facilitate data transmission over the internet
d. To organize data into structured tables
d. To organize data into structured tables
Which of the following is NOT a characteristic of a relational database?
a. Tables with rows and columns
b. Relationships between tables
c. Hierarchical data structure
d. Use of primary keys to uniquely identify records
c. Hierarchical data structure
What is a foreign key in a relational database?
a. A unique identifier for a table
b. A primary key in a different database
c. A key used for encrypting sensitive data
d. A column that establishes a link between two tables
d. A column that establishes a link between two tables
You are designing a relational database for an e-commerce website. Which type of relationship would best represent the connection between a “Customer” and their “Orders”?
a. One-to-One
b. Many-to-One
c. One-to-Many
d. Many-to-Many
c. One-to-Many
In a university database, a student can enroll in multiple courses, and each course can have multiple students. What type of relationship does this represent?
a. One-to-One
b. Many-to-One
c. One-to-Many
d. Many-to-Many
d. Many-to-Many
You have a database of employees, and each employee has a unique employee ID. What type of attribute is the employee ID in this context?
a. Foreign Key
b. Attribute Key
c. Secondary Key
d. Primary Key
d. Primary Key
Statement I. There should be primary key and foreign key to connect the two tables
Statement II. In a data hierarchy, a collection of related characters constitutes a field.
Statement III. The relational data model portrays data as being stored in table
a. All statements are true
b. One statement is true
c. All statements are false
d. One statement is false
a. All statements are true
Statement I. An attribute is equivalent to a field and may also be known as a row.
Statement II. Update anomaly occurs when you have to remove all records of a person.
Statement III. A secondary key uniquely identifies any row within a relational table
a. All statements are true
b. One statement is true
c. All statements are false
d. One statement is false
c. All statements are false
In the context of relational databases, what is normalization?
a. The process of removing redundant data and ensuring data integrity
b. The process of indexing database tables for faster access
c. The process of converting data into SQL format
d. The process of optimizing database queries
a. The process of removing redundant data and ensuring data integrity
You are managing a small library with a basic cataloging system. Which of the following best describes the database structure you are likely to use?
a. Database system
b. Relational database model
c. Flat file system
d. NoSQL database
c. Flat file system
A local grocery store maintains a simple database to track its inventory. Each product’s information, such as name, price, and quantity, is stored in a separate file. What type of database system is this?
a. Hierarchical database
b. Relational database model
c. Flat file system
d. Database system
c. Flat file system
An accounting firm uses a system where each client’s financial data is stored in a separate file. This system allows easy portability and sharing of data. What type of database architecture is this?
a. Hierarchical database
b. Relational database model
c. Flat file system
d. NoSQL database
c. Flat file system
A company maintains its customer data in separate text files for each year. As the customer base grows, they find it challenging to generate reports that require data spanning multiple years. What disadvantage of a flat-file system does this scenario illustrate?
a. Limited data integrity
b. Difficulty in data retrieval
c. Efficient data storage
d. Data redundancy
b. Difficulty in data retrieval
An online retailer stores product information in individual CSV files for each category. When a new category is added, it becomes cumbersome to modify existing processes to accommodate the change. What issue with scalability does this scenario highlight?
a. Easy data updates
b. Maintenance challenges
c. Lack of data security
d. Flexibility in data structure
b. Maintenance challenges
A small business uses a flat-file system to manage its employee records. When two employees with the same name join the company, their records get mixed up. What problem related to data uniqueness does this represent?
a. Data redundancy
b. Data inconsistency
c. Data isolation
d. Data retrieval issues
b. Data inconsistency
A local event management company stores event details in separate Excel files for each event. When a customer requests a report that includes historical event data, it takes significant time and effort to consolidate the information. What issue related to data consolidation does this exemplify?
a. Data redundancy
b. Data security
c. Data isolation
d. Data fragmentation
d. Data fragmentation
A museum maintains an inventory of artifacts in separate text files for different exhibit halls. When a curator wants to see a complete list of all artifacts, they need to manually combine data from multiple files. What challenge related to data comprehensiveness does this situation portray?
a. Data redundancy
b. Data inconsistency
c. Data isolation
d. Data retrieval efficiency
c. Data isolation
It is how the user sees the data on the computer monitor.
a. Primary View
b. Physical View
c. Logical View
d. Administrator View
c. Logical View
Statement I. The DBMS maintains the data dictionary.
Statement II. The data dictionary describes what the data is
a. Both are true
b. True, False
c. Both are false
d. False, True
a. Both are true
In a sales database, when updating the price of a product, you have to change it in multiple places because the price is stored redundantly. What type of anomaly is this?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
c. Update Anomaly
In an employee database, when adding a new department without any employees assigned, you can’t record it because each department must have at least one employee. What type of anomaly is this?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
a. Insert Anomaly
In a customer order database, when you update the customer’s address, it should propagate to all related orders. What type of anomaly occurs if this does not happen automatically?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
c. Update Anomaly
In a student database, when adding a new course, you must also add a placeholder student record to represent the course instructor. What type of anomaly is this?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
a. Insert Anomaly
In an order processing database, when updating the status of an order, you accidentally change the order details, such as the products ordered. What type of anomaly is this?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
c. Update Anomaly
In an employee database, you cannot delete a department without also deleting all the employee records in that department. What type of anomaly is this indicative of?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
b. Delete Anomaly
In a library database, you cannot delete a book entry without also deleting the associated information about the author. What type of anomaly is this indicative of?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
b. Delete Anomaly
In an inventory database, deleting a product also causes the loss of information about which suppliers provide that product. What type of anomaly is this indicative of?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
b. Delete Anomaly
In a student registration database, when a student withdraws from a course, their name still appears in the course roster. What type of anomaly is this indicative of?
a. Insert Anomaly
b. Delete Anomaly
c. Update Anomaly
d. None of the above
b. Delete Anomaly
A company’s marketing team is analyzing customer feedback data to improve product quality. They receive feedback in various formats, including handwritten notes, scanned documents, and voice recordings. What aspect of “garbage-in, garbage-out” is most relevant in this scenario?
a. Data Integration
b. Data Validation
c. Data Retrieval
d. Data normalization
b. Data Validation
A data analyst is tasked with creating a financial report based on data from multiple sources, including spreadsheets, databases, and external data feeds. The analyst notices discrepancies and inconsistencies in the data. What principle should the analyst keep in mind to address this issue?
a. Data Warehousing
b. Data Validation
c. Data Indexing
d. None of the above
b. Data Validation
