2ND EXAM REVIEWER Flashcards

1
Q

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

A

c. Data manipulation language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

b. Data management system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the data of the data, or metadata?

a. Data dictionary
b. Data management system
c. Database administrator
d. Physical database

A

a. Data dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

b. Data query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

d. One statement is false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

a. All statements are true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

c. User application programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

a. Cross-functional analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

d. Data independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

b. Direct query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

d. To organize data into structured tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

c. Hierarchical data structure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

d. A column that establishes a link between two tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

c. One-to-Many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

d. Many-to-Many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

d. Primary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

a. All statements are true

18
Q

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

A

c. All statements are false

19
Q

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

a. The process of removing redundant data and ensuring data integrity

20
Q

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

A

c. Flat file system

21
Q

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

A

c. Flat file system

22
Q

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

A

c. Flat file system

23
Q

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

A

b. Difficulty in data retrieval

24
Q

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

A

b. Maintenance challenges

25
Q

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

A

b. Data inconsistency

26
Q

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

A

d. Data fragmentation

27
Q

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

A

c. Data isolation

28
Q

It is how the user sees the data on the computer monitor.

a. Primary View
b. Physical View
c. Logical View
d. Administrator View

A

c. Logical View

29
Q

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

a. Both are true

30
Q

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

A

c. Update Anomaly

31
Q

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

a. Insert Anomaly

32
Q

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

A

c. Update Anomaly

33
Q

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

a. Insert Anomaly

34
Q

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

A

c. Update Anomaly

35
Q

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

A

b. Delete Anomaly

36
Q

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

A

b. Delete Anomaly

37
Q

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

A

b. Delete Anomaly

38
Q

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

A

b. Delete Anomaly

39
Q

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

A

b. Data Validation

40
Q

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

A

b. Data Validation