Deck 5: Database Processing

Question 1

The purpose of a database is to keep track of lists of data that involve a single theme.

Answer 1

False

Question 2

Metadata refers to special data that describes the structure of a database.

Answer 2

True

Question 3

MySQL is an open source DBMS product that is license-free for most database applications.

Answer 3

True

Question 4

Most organizations develop their own database management system (DBMS) in order to obtain control over data.

Question 5

A database is best described as a collection of unrelated tables.

Question 6

A spreadsheet can be used to store data if the structure of a list is simple.

Question 7

Metadata refers to entities of a database that users want to process.

Question 8

A database management system (DBMS) is a program used to create, process, and administer a database.

Question 9

A user does not need user account credentials to access and process a database.

Question 10

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

Question 11

A DBMS and database are synonymous terms that can be used interchangeably.

Question 12

A key is a column or group of columns that identifies a unique row in a table.

Question 13

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Question 14

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Question 15

SQL is an international standard language for processing a database.

Question 16

Each table in a database must have two or more primary keys.

Question 17

The format of metadata depends on the software product that processes the database.

Question 18

A group of similar rows or records in a table is called a field.

Question 19

Creating a system to record and manage the resolution of problems is the development task of a database administrator.

Question 20

A database is a self-describing collection of integrated records.

Question 21

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

Question 22

Database applications must present data to the users in the same format as the database table.

Question 23

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Question 24

A line in an entity-relationship (E-R) diagram is used to represent the attributes of an entity.

Question 25

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Question 26

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Question 27

In an entity-relationship data model, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

Question 28

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

Question 29

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Question 30

Browser-based applications are more dynamic and better suited in today's world than older database applications.

Question 31

Attributes are used to describe characteristics of entities.

Question 32

An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.

Question 33

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

Question 34

A logical representation of database data, called the data model, is constructed by developers after building a database.

Question 35

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Question 36

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

Question 37

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

Question 38

Browser database application forms, reports, and queries are displayed and processed using html5, css3, and JavaScript.

Question 39

The lost-update problem can be resolved by implementing single-user database processing.

Question 40

In single-user databases, the application, the DBMS, and the database all reside on the user's computer.

Question 41

A foreign key is essential in relational databases to represent the relationship between two tables.

Question 42

The rows in a database are called ________.

A) records
B) tables
C) files
D) fields

Question 43

Normalized tables are faster to process than tables that haven't been normalized.

Question 44

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Question 45

The accuracy of a database design is not dependent on the corresponding data model.

Question 46

Which of the following data elements is placed higher than records in the database hierarchy?

A) file
B) field
C) character
D) byte

Question 47

A primary key in a database is a ________.

A) group of rows that identifies a unique table or file
B) column or group of columns that identifies a unique row in a table
C) group of fields or columns that represent metadata
D) group of tables or files formed to identify a unique field or row

Question 48

In a database, ________ are grouped into columns.

A) fields
B) records
C) bytes
D) files

Question 49

Normalization is the process of combining two or more tables into a single table.

Question 50

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Question 51

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Question 52

The easiest time to change the database structure is after the data modeling stage.

Question 53

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M.

Question 54

The columns in a database are called ________.

A) records
B) tables
C) files
D) fields

Question 55

The data integrity problem occurs only if data are duplicated.

Question 56

1:N, N:M, and 1:1 are common examples of minimum cardinalities, where N and M represent many relationships for two different entities.

Question 57

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Question 58

A group of similar rows or records is known as ________.

A) a prototype
B) a file
C) a field
D) an attribute

Question 59

A database is used instead of a spreadsheet when ________.

A) lists of data involve a single theme
B) structures of data lists are simple
C) lists involve data with multiple themes
D) users do not want to store all data in one place

Question 60

Which of the following is the smallest element in a database?

A) field
B) record
C) byte
D) metadata

Question 61

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

Question 62

Which of the following is True of traditional database application programs?

A) Application forms, reports, and queries are displayed and processed using a browser application.
B) The application logic is contained in a program on the client-side computer.
C) They are written in object-oriented languages such as C++ and VisualBasic.
D) They are thin-client applications that need not be pre-installed on the users' computers.

Question 63

Which of the following is True of MySQL?

A) It is a Microsoft product.
B) It is license-free for most applications.
C) It is a paid and proprietary database product.
D) It uses Static Query Language (SQL) to manage database.

Question 64

Which of the following is True of single-user databases?

A) They are displayed and processed using html5, css3, and JavaScript.
B) They use JavaScript for user-side processing.
C) The Internet is used to access the DBMS server computer.
D) The application, the DBMS, and the database all reside on the user's computer.

Question 65

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.

A) development
B) adaptation
C) backup and recovery
D) operation

Question 66

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

A) MS Excel
B) BigData
C) NoSQL
D) Access

Question 67

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

Question 68

Metadata are ________.

A) codes used for server-side processing
B) error logs of databases
C) data that describe data
D) data that are encrypted

Question 69

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

A) evaluating an application design
B) monitoring backup procedures
C) conducting training for users
D) managing configuration changes in systems

Question 70

________ allow users to read, insert, modify, and delete data in a database.

A) Reports
B) Forms
C) Queries
D) Operations

Question 71

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

Question 72

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

A) Cassandra
B) DB2
C) SQL
D) MS Access

Question 73

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

A) primary key
B) key attribute
C) foreign key
D) functionally dependent record

Question 74

Columns that are keys to different tables than the ones in which they reside are called ________.

A) attributes
B) foreign keys
C) primary keys
D) internal records

Question 75

Relational databases represent relationships using ________.

A) foreign keys
B) file systems
C) metadata
D) primary keys

Question 76

Identify an open source DBMS product.

A) MySQL
B) DB2
C) Access
D) Oracle Database

Question 77

The data in a database are modified and deleted. These operations of DBMS are known as ________.

A) statistical operations
B) analytical operations
C) administrative operations
D) processing operations

Question 78

A 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

Question 79

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

A) form
B) report
C) query
D) application

Question 80

A(n) ________ is a program used to create, process, and administer a database.

A) operating system
B) database management system
C) information system
D) database system