Deck 4: Database Processing

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

An example of a byte is a character of data.

Answer 3

True

Question 4

A group of related rows is called a table.

Question 5

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

Question 6

A database management system (DBMS)is a program used to create,process,and administer a database.

Question 7

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

Question 8

Self-describing means that a database contains,within itself,a description of its contents.

Question 9

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

Question 10

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

Question 11

Relational databases are databases that are not an organized format.

Question 12

Columns are also called records.

Question 13

Foreign keys are commonly used to help link one table to another.

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

Another important use of database application programs is to enable database processing over the Internet.

Question 25

A query shows the results of a search by a keyword.

Question 26

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

Question 27

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

Question 28

Attributes are used to describe characteristics of entities.

Question 29

Most database applications meet all requirements for business needs.

Question 30

Enterprise DBMS products process large organizational and workgroup databases.

Question 31

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

Question 32

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

Question 33

Multi-user processing is common and generally problem free.

Question 34

Today,there are many personal DBMS products available including Paradox,dBase,rBase,and Fox-Pro.

Question 35

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

Question 36

SQL is an international standard language for processing a database.

Question 37

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

Question 38

Reports show data in a structured context.

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

Minimum cardinalities represent the minimum number of entity instances required in a relationship.

Question 46

Data duplication is an example of a data integrity problem.

Question 47

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 48

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

Question 49

A NoSQL databases is a high-performance,special-requirements DBMS.

Question 50

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 51

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

Question 52

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 53

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 54

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

Question 55

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

Question 56

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 57

Relational DBMS are the workhorse of the information systems industry today and likely will be for many years to come.

Question 58

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

Question 59

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

Question 60

NoSQL products guarantee that updates will be consistent or durable.

Question 61

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

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

Question 62

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

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

Question 63

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 64

Which of the following is true of MySQL?

A) It is offered by Microsoft.
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 tables that appear in a database are known as ________.

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

Question 66

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

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

Question 67

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 68

Relational databases represent relationships using ____________.

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

Question 69

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 70

The rows in a database are called ________.

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

Question 71

In a database,________ are grouped into columns that represent table attributes.

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

Question 72

Columns that are keys to different tables other than the ones in which they reside are called ___________.

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

Question 73

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

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

Question 74

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 75

Metadata are ________.

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

Question 76

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

A) MS Excel
B) Big Data
C) SQL Server
D) Access

Question 77

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

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

Question 78

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

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

Question 79

The columns in a database are called ________.

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

Question 80

Identify the open source DBMS product among the following:

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