Deck 5: Database Processing

Question 1

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

Answer 1

False

Question 2

A spreadsheet should be used to store data with multiple themes.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

Question 7

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

Question 8

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

Question 9

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

Question 10

The rows in a database need to have two or more primary keys.

Question 11

A database application is a collection of forms, reports, queries, and application programs that process a database.

Question 12

A database is best described as a collection of tables which are not related to each other.

Question 13

To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.

Question 14

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

Question 15

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

Question 16

SQL is an international standard language for processing a database.

Question 17

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

Question 18

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

Question 19

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

Question 20

A DBMS is a software that helps to manage the operating system.

Question 21

Some type of locking must be used to coordinate the activities of users who know nothing about one another in order to prevent the lost-update problem.

Question 22

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

Question 23

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

Question 24

Attributes are used to describe characteristics of entities.

Question 25

A data model describes data, whereas a database explains the relationships among the data that will be stored in the database.

Question 26

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

Question 27

A crow's foot notation would indicate the minimum cardinality of a relationship.

Question 28

Microsoft Access is both a DBMS and an application development product.

Question 29

Developers need to construct a data model before building a database.

Question 30

In order to find the data one is looking for in a DBMS, one has to type in the keyword into a query form.

Question 31

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

Question 32

A drawback of DBMS programs is that they do not provide comprehensive and robust features for querying database data.

Question 33

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

Question 34

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

Question 35

Microsoft's SQL Server is an example of a personal DBMS product.

Question 36

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

Question 37

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

Question 38

A database must have only one application, though the application can have one or more users.

Question 39

Application programs process logic that is specific to a given business need.

Question 40

Data entry forms are used to read, insert, modify, and delete data.

Question 41

Google developed a nonrelational data store called Dynamo.

Question 42

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

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

Question 43

Columns that belong to a different table than the one in which they reside are called ________.

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

Question 44

The data integrity problem occurs if data are duplicated.

Question 45

A(n)________ is a self-describing collection of integrated records.

A) cloud
B) database
C) storage folder
D) application software

Question 46

The rows in a database are called ________.

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

Question 47

Normalized tables are faster to process than denormalized tables.

Question 48

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

Question 49

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

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

Question 50

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

Question 51

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

Question 52

Facebook developed a nonrelational data store called Bigtable.

Question 53

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

Question 54

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

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

Question 55

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 56

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) primary record

Question 57

The small oval on a line in an E-R diagram means that the relationship is optional.

Question 58

The columns in a database are called ________.

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

Question 59

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

Question 60

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 61

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

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

Question 62

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 63

A(n)________ DBMS is designed to process large organizational and workgroup databases.

A) operational
B) process
C) personal
D) enterprise

Question 64

Metadata are ________.

A) data stored on the main server
B) error logs of databases
C) data that describe data
D) encrypted data transmissions

Question 65

From among the following, identify the open source DBMS product.

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

Question 66

A ________ is a request for data from a database.

A) data entry
B) reporting
C) query
D) command

Question 67

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 68

A ________ is a collection of forms, reports, queries, and programs that process a database.

A) database application
B) database design
C) data field
D) data model

Question 69

Which of the following refers to the problem that exists in database applications when two users update 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

Question 70

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

A) MS Excel
B) Unix
C) Ubuntu
D) Access

Question 71

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

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

Question 72

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 73

Relational databases represent relationships using ________.

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

Question 74

________ forms are used to read, insert, modify, and delete data.

A) Reporting
B) Data entry
C) Query
D) Request

Question 75

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 76

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) recovery
D) operation

Question 77

An organization buys a proprietary database application to be used by a small workgroup of five people.This is an example of a(n)________ DBMS.

A) enterprise
B) interenterprise
C) personal
D) open source

Question 78

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.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

A) report
B) reference
C) data entry
D) query

Question 79

Which of the following is a valid observation 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 80

Which of the following is an example of an enterprise DBMS?

A) Access
B) SQL Server
C) Paradox
D) FoxPro