Deck 5: Database Processing

Question 1

The columns in a database are called ________.

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

Answer 1

D

Question 2

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

Answer 2

B

Question 3

In a database, ________ are grouped into columns.

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

Answer 3

C

Question 4

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 5

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 6

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. The "Employee Number" column is referred to as a ________.

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

Question 7

What is the purpose of a database?

Question 8

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

Question 9

The rows in a database are called ________.

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

Question 10

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

Question 11

Relational databases represent relationships using ________.

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

Question 12

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

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

Question 13

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

Question 14

Describe a database and its elements.

Question 15

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

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

Question 16

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

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

Question 17

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

Question 18

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

Question 19

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 20

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

Question 21

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

Question 22

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

Question 23

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 24

What is database administration?

Question 25

Define primary key, foreign key, and metadata.

Question 26

Identify an open source DBMS product.

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

Question 27

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

Question 28

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 29

SQL is an international standard language for processing a database.

Question 30

The modification or deletion of data in a database is an example of ________ operations of a database management system.

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

Question 31

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

Question 32

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

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

Question 33

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

Question 34

Explain how a database management system processes a database.

Question 35

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 36

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

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

Question 37

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 a database.

Question 38

Owen, the database administrator for a shipping company, is responsible for checking the data model, which is to be used in the database management system, for accuracy and completeness. This is an example of Owen's ________ tasks.

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

Question 39

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

Question 40

Samuel is the database administrator for Zimline Constructions. He determines the processing rights of employees based on their designation. Team leaders are given greater access to the database than their team members. This procedure of giving selective access is part of Samuel's ________ task.

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

Question 41

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

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

Question 42

Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company's database. Which of the following elements will help Heidi modify her data?

A)reports
B)forms
C)queries
D)operations

Question 43

State the purposes of the four elements of a database application.

Question 44

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

Question 45

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

Question 46

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 preinstalled on the users' computers.

Question 47

Traditional database application programs are ________.

A)browser-based and display dynamic content
B)written in languages such as html5 and JavaScript
C)entirely dependent on the database server for application logic
D)thick applications that need to be installed on users' computers

Question 48

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 49

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________.

A)lost-update problem
B)crow's-foot paradigm
C)bullwhip effect
D)update query problem

Question 50

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

Question 51

Browser-based applications ________.

A)are thick-client applications
B)can display only static content
C)support graphical queries
D)process queries using C++

Question 52

Explain the functioning of browser applications.

Question 53

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 54

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

Question 55

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

Question 56

What is a database application?

Question 57

Browser applications are thin-client applications that ________.

A)use COBOL as the standard language for user-side processing
B)are processed using VisualBasic and C++
C)need not be preinstalled on the users' computers
D)depend on internal networks and not the Internet to transmit data

Question 58

Which of the following is used to process and display browser database application forms, reports, and queries?

A)C++
B)html
C)COBOL
D)VisualBasic

Question 59

What are traditional database applications?

Question 60

Browser-based applications ________.

A)need to be preinstalled on the users' computers
B)run within a corporate network that is protected from the Internet
C)eliminate the need to check for data consistency
D)are more vulnerable to security threats than are traditional applications

Question 61

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

Question 62

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

A)specific
B)minimum
C)primary
D)critical

Question 63

Acelane Inc., unlike its competitors, procures raw material from multiple suppliers. Each supplier in turn supplies raw material to many buyers, including Acelane. This is an example of a(n)________ relationship.

A)1:N
B)1:1
C)N:M
D)M:1

Question 64

What is the disadvantage of multiuser processing?

Question 65

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 66

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

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

Question 67

Which of the following is true of N:M relationships?

A)They are the same as N:N relationships.
B)They represent minimum cardinalities in a relationship.
C)They are also called one-to-many relationships.
D)They can have more than one entity on each side of the relationship.

Question 68

Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing?

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

Question 69

Each entity in a database has a unique attribute called a(n)________.

A)public key
B)identifier
C)foreign key
D)index field

Question 70

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, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

A)identifiers
B)records
C)primary keys
D)entities

Question 71

Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

A)vertical bar
B)arrow
C)double line
D)small oval

Question 72

________ in an E-R diagram refer to the least number of entities required in a relationship.

A)Minimum candidate keys
B)Primary keys
C)Foreign keys
D)Minimum cardinalities

Question 73

In an E-R diagram, a(n)________ on a line means that at least one entity of that type is required.

A)small oval
B)vertical bar
C)arrow
D)triangular block

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

In an E-R diagram, a line between two entities represents a(n)________.

A)attribute
B)identifier
C)cardinality
D)relationship

Question 76

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

Question 77

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 78

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

Question 79

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

Question 80

The forked lines on the lines representing relationship between two related entities are referred to as ________.

A)identifiers
B)foreign keys
C)crow's feet
D)entities