Deck 4: Database Processing

Question 1

SQL is an international standard language for processing a database.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

A database management system (DBMS)is a program used to create,process,and administer a 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

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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 34

Attributes are used to describe characteristics of entities.

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

The data integrity problem occurs only if data are duplicated.

Question 41

Metadata are ________.

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

Question 42

The columns in a database are called ________.

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

Question 43

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

Question 44

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

Question 45

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

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

Question 46

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 47

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

Question 48

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

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

Question 49

The rows in a database are called ________.

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

Question 50

Relational databases represent relationships using ________.

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

Question 51

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 52

A database is required instead of a spreadsheet when ________.

A) professionals need to keep 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 53

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

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

Question 54

In a database,________ are grouped into columns.

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

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

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 57

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

Question 58

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 59

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

Question 60

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 61

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 62

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

Question 63

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

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

Question 64

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

A) record
B) byte
C) entity
D) primary key

Question 65

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 66

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

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

Question 67

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 68

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

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

Question 69

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

Question 70

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

Question 71

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 72

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 73

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

A) data aggregator
B) query model
C) data model
D) data application

Question 74

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

A) characters
B) primary keys
C) codes
D) attributes

Question 75

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 76

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 77

Identify the open source DBMS product among the following.

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

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.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 79

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

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

Question 80

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