Deck 5: Database Processing

Question 1

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
E) nonlocal keys

Answer 1

B

Question 2

Each table in a database must have at least one foreign key.

Answer 2

False

Question 3

The rows in a database are also called ________.

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

Answer 3

A

Question 4

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

Question 5

What is the purpose of a database?

Question 6

Lists that involve data with multiple themes can be stored in a spreadsheet.

Question 7

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

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

Question 8

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.

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

Question 9

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

A) a prototype
B) a table
C) a field
D) an attribute
E) a cluster

Question 10

Metadata is/are ________.

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

Question 11

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

Question 12

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
E) group of records that identifies similar attribute

Question 13

A foreign key is a key of a different (foreign) table than the one in which it resides.

Question 14

Relational databases represent relationships using ________.

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

Question 15

The columns in a database are also called ________.

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

Question 16

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
E) users have a small amount of data to store

Question 17

The purpose of a database is to keep track of lists of data that involve multiple themes.

Question 18

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

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

Question 19

Describe a database and its elements.

Question 20

In a database, ________ are grouped into columns.

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

Question 21

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

A) Cassandra
B) DB2
C) SQL
D) MS Access
E) Relational LM

Question 22

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
E) testing backup procedures

Question 23

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

Question 24

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

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

Question 25

A user must have user account credentials to access and process a database.

Question 26

Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks.

A) development
B) recovery
C) adaptation
D) operation
E) data audit

Question 27

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

Question 28

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
E) operating system driver

Question 29

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
E) conducting data audit requirements

Question 30

Define primary key, foreign key, and metadata.

Question 31

SQL is an international standard language for processing a database.

Question 32

Explain how a database management system processes a database.

Question 33

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
E) data bridge

Question 34

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

Question 35

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

Question 36

Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tracking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks.

A) development
B) adaptation
C) backup and recovery
D) operation
E) data audit

Question 37

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
E) technical

Question 38

Identify an open source DBMS product.

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

Question 39

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.
E) It limits databases to 2 TB in size.

Question 40

What is database administration?

Question 41

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
E) pull function

Question 42

Browser-based applications ________.

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

Question 43

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.
E) They are cloud-based applications that need not be preinstalled on the users' computers.

Question 44

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

Question 45

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

A) form
B) report
C) query
D) application
E) db pull

Question 46

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
E) do not need to be encrypted

Question 47

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
E) bait-and-switch problem

Question 48

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

Question 49

Explain the functioning of browser applications.

Question 50

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.
E) They run on clustered Linux or Unix systems

Question 51

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

Question 52

What is a database application?

Question 53

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
E) do not need to be encrypted

Question 54

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
E) DB2

Question 55

What are traditional database applications?

Question 56

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

Question 57

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

Question 58

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data?

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

Question 59

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
E) cloud-based applications

Question 60

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

Question 61

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

A) public key
B) identifier
C) foreign key
D) index field
E) prime value

Question 62

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

Question 63

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

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

Question 64

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
E) triangle

Question 65

What is the disadvantage of multiuser processing?

Question 66

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.
E) They connect different data types.

Question 67

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
E) quarks

Question 68

________ 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
E) Chernozem cardinalities

Question 69

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

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

Question 70

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
E) data tunnel outlay

Question 71

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

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

Question 72

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
E) switch

Question 73

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

Question 74

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

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

Question 75

A line in an entity-relationship (E-R) diagram is used to represent the relationships between two entities.

Question 76

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
E) N:1

Question 77

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
E) wave

Question 78

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
E) data-tree model

Question 79

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
E) array of data variables

Question 80

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