Deck 5: Database Processing

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

SQL is an international standard language for processing a database.

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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 25

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

Question 26

Attributes are used to describe characteristics of entities.

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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 41

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

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

Question 42

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 43

Normalized tables are faster to process than denormalized tables.

Question 44

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

Question 45

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

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

Question 46

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

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

Question 47

Google developed a nonrelational data store called Dynamo.

Question 48

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

Question 49

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 50

The data integrity problem occurs if data are duplicated.

Question 51

The columns in a database are called ________.

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

Question 52

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

Question 53

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

Question 54

The purpose of a(n)________ is to keep track of things.

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

Question 55

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 56

Facebook developed a nonrelational data store called Bigtable.

Question 57

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

Question 58

The rows in a database are called ________.

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

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 small oval on a line in an E-R diagram means that the entity is optional.

Question 61

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 62

Relational databases represent relationships using ________.

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

Question 63

A ________ is a request for data from a database.

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

Question 64

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 65

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 66

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

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

Question 67

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 68

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

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

Question 69

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 70

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 71

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 72

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

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

Question 73

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

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

Question 74

Metadata are ________.

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

Question 75

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

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

Question 76

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

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

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

Question 78

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 79

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 80

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

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