Deck 5: Database Processing

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Question 11

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

Question 12

A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.

Question 13

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

Question 14

SQL is an international standard language for processing a database.

Question 15

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

Question 16

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

Question 17

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

Question 18

Most organizations develop their own DBMS software in order to obtain control over data.

Question 19

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

Question 20

Special data that describes the structure of a database is called metadata.

Question 21

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

Question 22

Developers generally construct a logical representation of database data, called a data model, after building a database.

Question 23

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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 31

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

Question 32

Attributes are used to describe characteristics of entities.

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

A line in an E-R diagram is used to represent the attributes of the entities.

Question 40

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 41

The data integrity problem occurs only if data are duplicated.

Question 42

1:N, N:M, and 1:1 are common examples of minimum cardinalities.

Question 43

A primary key used in a database is a ________.

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

Question 44

The rows in a database are called ________.

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

Question 45

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

Question 46

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

Question 47

In a database, ________ are grouped into columns.

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

The tables that appear in a database are known as ________.

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

Question 53

A database is required instead of a spreadsheet when ________.

A) professionals need to keep a track of things
B) a user requires control over data
C) lists involve data with multiple themes
D) one or more users want to access the same data

Question 54

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

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

Question 55

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

Question 56

The accuracy of a database design is independent of the corresponding data model.

Question 57

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 58

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

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

Question 59

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 60

The columns in a database are called ________.

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

Question 61

Relational databases represent relationships using ________.

A) foreign keys
B) file systems
C) metadata
D) unique identifiers

Question 62

Metadata are ________.

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

Question 63

Identify the open source DBMS product among the following.

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

Question 64

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) identifier
C) foreign key
D) functionally dependent record

Question 65

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

Question 66

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

Question 67

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

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

Question 68

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

Question 69

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

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

Question 70

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

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

Question 71

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 72

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.

Question 73

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

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

Question 74

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

A) Application forms, reports, and queries are displayed and processed using a browser.
B) All of the application logic is contained in a program on the database server.
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 75

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 76

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 77

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

Question 78

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 79

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

A) operating system
B) DBMS
C) information system
D) data mart

Question 80

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.