Question 1

When you modify or delete data present in a database,you are ________.
A) creating a new database
B) forming a data model
C) simplifying the data structure
D) processing the database

Accepted Answer

Modifying or deleting data in a database involves processing the existing database to make changes to the data. It does not involve creating a new database, forming a data model, or simplifying the data structure.

Question 2

Which of the following refers to the problem that exists in database applications when two users modify the same data item,but only one of those changes is recorded?
A) lost update problem
B) crow's foot paradigm
C) bullwhip effect
D) update query problem

Accepted Answer

The lost update problem refers to the issue that occurs when two users modify the same data item, but only one of those changes is recorded, leading to the loss of the other user's update. This can happen when the two updates occur simultaneously or very close to each other in time.

Question 3

A(n)________ is a request for data from a database.
A) form
B) report
C) query
D) application

Accepted Answer

A query is specifically designed to request and retrieve data from a database, whereas a form is used for data input, a report is used to display data in a specific format, and an application is a broader term that refers to a software program or suite of programs.

Question 4

In a data model,a(n)________ is something that a user wants to track.
A) record
B) byte
C) entity
D) primary key

Accepted Answer

An entity is something that a user wants to track in a data model. Examples of entities could be a customer, a product, or an order. Records are instances of entities, bytes are units of data storage, and primary keys are unique identifiers for an entity.

Question 5

Which of the following is true of MySQL?
A) It is offered by Oracle.
B) It is license-free for most applications.
C) It is a closed-source database product.
D) It is yet to be widely adopted.

Accepted Answer

MySQL is license-free for most applications, making it a popular choice for businesses and developers. It was originally developed by Swedish company MySQL AB, which was later acquired by Sun Microsystems, which in turn was acquired by Oracle. MySQL is an open-source database product, meaning that its source code is freely available for anyone to use or modify. It is widely adopted and used by many popular websites and applications.

Question 6

Which of the following is an example of a database management system?
A) MS Excel
B) BigData
C) NoSQL
D) Access

Accepted Answer

Access is a database management system developed by Microsoft. MS Excel is a spreadsheet software, BigData is a term used for huge volumes of data and NoSQL is a type of database management system but not a specific software.

Question 7

Which of the following database administration tasks is related to adaptation?
A) monitoring backup procedures
B) conducting training for users
C) monitoring database performance
D) managing configuration changes in systems

Accepted Answer

Managing configuration changes in systems involves adapting to changes in hardware, software and network configurations to ensure that the database runs without interruption. This involves changes such as altering database settings, modifying access permissions, or adding new hardware to accommodate increased database usage. Therefore, D is the correct answer. Monitoring backup procedures (A) involves ensuring that backups are running as scheduled and that backup files can be restored as needed. Conducting training for users (B) involves educating users on how to use the database correctly and efficiently. Monitoring database performance (C) involves tracking database activity to identify bottlenecks and areas for improvement. While all of these tasks are important for database administration, they are not specifically related to adaptation.

Question 8

________ are used by users to read,insert,modify,and delete data in a database.
A) Reports
B) Forms
C) Queries
D) DBMS

Accepted Answer

Forms are user interfaces that allow users to interact with a database. Users can read, insert, modify, and delete data through forms. Reports are used to summarize and present data from a database, while queries are used to retrieve specific data from a database. DBMS (database management systems) are software that manages and controls access to a database.

Question 9

A data model is a ________.
A) logical representation of database data
B) repository of unprocessed data
C) collection of isolated databases
D) set of programs used to retrieve data

Accepted Answer

A data model is a logical representation of database data. It defines the structure, relationships, and constraints of the data stored in the database. It helps to organize and understand the data and provides a framework for building applications that access the data.

Question 10

A ________ describes the data and relationships that will be stored in a database.
A) data aggregator
B) query model
C) data model
D) data application

Accepted Answer

A data model is a conceptual representation of the data and relationships that will be stored in a database. It provides a roadmap for how data will be organized, stored, and accessed. A data aggregator refers to a tool or platform that gathers data from various sources, a query model is a way of representing a query in a database system, and a data application refers to an application that manages and manipulates data within a database.

Question 11

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.
A) database application
B) database design
C) data field
D) data model

Accepted Answer

A database application is a software program that provides an interface between users and the database system. It includes forms, reports, queries, and programs that enable users to interact with the database data in a meaningful way. A database design refers to the process of designing a database schema, while a data field refers to a specific piece of data within a database record. A data model is a conceptual representation of data structures and relationships within a database.

Question 12

Which of the following is a developmental task of database administration?
A) creating and staffing the DBA function
B) monitoring backup procedures
C) conducting training for users
D) managing configuration changes in systems

Accepted Answer

The answer of Which of the following is a developmental...

Question 13

An administrator should create a ________ before developing a database design.
A) data aggregator
B) query model
C) data model
D) data application

Accepted Answer

A data model is a visual representation that outlines the logical structure of a database, including the relationships and constraints between different data elements. Creating a data model helps ensure that the database design meets the requirements of the organization and can help identify potential problems early on. A data aggregator, query model, or data application may be developed after the database design is complete.

Question 14

Entities in a data model have ________ that describe the characteristics of the entity.
A) characters
B) primary keys
C) codes
D) attributes

Accepted Answer

Entities in a data model have attributes that describe their characteristics or properties. Attributes are the specific pieces of information that are recorded about each entity, and they are used to distinguish one entity from another. Primary keys are a type of attribute that uniquely identifies each entity instance within the entity set. Codes and characters are not typically used to describe entity characteristics in a data model.

Question 15

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.
A) development
B) adaptation
C) backup and recovery
D) operation

Accepted Answer

Validating the data model involves designing and developing the structure of the database, which falls under the development aspect of database administration.

Question 16

The database administrator of an organization constantly manages the processing rights and responsibilities of employees.This is an example of a(n)________ task.
A) development
B) recovery
C) adaptation
D) operational

Accepted Answer

Managing processing rights and responsibilities of employees is an operational task that involves day-to-day management of the organization's database systems. This task is part of the routine operations that support the organization's ongoing business processes. The other options, development, recovery, and adaptation, involve more specific objectives that are typically part of larger projects or initiatives.

Question 17

Identify the open source DBMS product among the following.
A) MySQL
B) DB2
C) Access
D) Oracle Database

Accepted Answer

MySQL is an open source DBMS product, while DB2, Access, and Oracle Database are proprietary products.

Question 18

Brenda,the sales manager of a firm,wants to generate a particular report containing sales analyses of the second and third quarter of the year.She should use a ________ to obtain the information that she wants from the database.
A) report
B) data model
C) database administrative function
D) query

Accepted Answer

Brenda should use a query to obtain the specific sales analyses she needs from the database. A query is a request for specific information from the database based on certain criteria or conditions, and it allows the user to extract only the necessary data from the database. This is the most efficient way to obtain the desired information without having to sift through irrelevant data. The other options - report, data model, and database administrative function - do not directly apply to Brenda's need to extract specific sales analyses from the database.

Question 19

Which of the following is an international standard language for processing a database?
A) Cassandra
B) DB2
C) SQL
D) MS Access

Accepted Answer

SQL (Structured Query Language) is an internationally recognized standard language for processing and manipulating relational databases. Cassandra, DB2, and MS Access are all database management systems that may use SQL, but they are not the standard language itself.

Question 20

Brad,a project manager,wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name,percentage completed,and employee name.These aspects that Brad wants to track are called ________.
A) identifiers
B) records
C) primary keys
D) entities

Accepted Answer

Entities are the aspects or objects that a database is designed to store information about. In this case, the entities are employees and tasks, and the information that Brad wants to track are attributes or properties of these entities. Identifiers, records, and primary keys are related concepts in database design but are not the best fit for describing the information that Brad wants to track.

Quiz 4: Database Processing

When you modify or delete data present in a database,you are ________.

Which of the following refers to the problem that exists in database applications when two users modify the same data item,but only one of those changes is recorded?

A(n) ________ is a request for data from a database.

In a data model,a(n) ________ is something that a user wants to track.

Which of the following is true of MySQL?

Which of the following is an example of a database management system?

Which of the following database administration tasks is related to adaptation?

________ are used by users to read,insert,modify,and delete data in a database.

A data model is a ________.

A ________ describes the data and relationships that will be stored in a database.

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

Which of the following is a developmental task of database administration?

An administrator should create a ________ before developing a database design.

Entities in a data model have ________ that describe the characteristics of the entity.

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

The database administrator of an organization constantly manages the processing rights and responsibilities of employees.This is an example of a(n) ________ task.

Identify the open source DBMS product among the following.

Brenda,the sales manager of a firm,wants to generate a particular report containing sales analyses of the second and third quarter of the year.She should use a ________ to obtain the information that she wants from the database.

Which of the following is an international standard language for processing a database?

Brad,a project manager,wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name,percentage completed,and employee name.These aspects that Brad wants to track are called ________.