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