Deck 5: Database Processing

Question 1

A DBMS is a a collection of tables,relationships,and metadata.

Answer 1

False

Question 2

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called foreign relationship databases.

Answer 2

False

Question 3

A byte is a character of data.

Answer 3

True

Question 4

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

Question 5

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

Question 6

A database application consists of forms,reports,queries,and database programs.

Question 7

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

Question 8

A key is a field that identifies a unique column in a table.

Question 9

Metadata describes the structure of the database.

Question 10

Registries are data that describe data.

Question 11

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

Question 12

Every table in a relational database must have a key.

Question 13

Most organizations develop their own DBMS software.

Question 14

A group of similar records is called a field.

Question 15

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

Question 16

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

Question 17

Elements of the database application system call on the database management system to process the database tables.

Question 18

A column is also referred to as a record.

Question 19

A spreadsheet is used to store data with multiple themes.

Question 20

Relational databases represent relationships through the use of formal keys.

Question 21

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

Question 22

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

Question 23

Data-redundancy exemplifies one of the special characteristics of multi-user database processing.

Question 24

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

Question 25

In order to read,insert,modify,or delete data,applications have to call upon the DBMS in a standardized way.

Question 26

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

Question 27

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

Question 28

SQL stands for "Standard Query Language."

Question 29

SQL is an international standard language for processing a database.

Question 30

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

Question 31

Permissions and limits of a DBMS are restricted in options.

Question 32

Instead of using SQL to code queries to the DBMS,an application program can be used to query the DBMS directly.

Question 33

Pure database data are more useful if they are in raw form.

Question 34

Data entry forms show data in a structured context.

Question 35

Application programs enable database processing over the Internet.

Question 36

A database cannot have more than one application processing it.

Question 37

In order to find the data one is looking for in the DBMS,one has to type in the keyword into a query form.

Question 38

Locking to coordinate the activities of users who know nothing of one another is used to prevent the lost-update problem.

Question 39

SQL is used to create databases and database structures.

Question 40

One of the operational tasks of the database administrator is to determine processing rights/restrictions on each table and column.

Question 41

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

Question 42

"Name" would be a good identifier for a customer entity in a database application.

Question 43

Database designers use entity-relationship (E-R)diagrams to design databases.

Question 44

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

Question 45

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

Question 46

In a data model,entities always represent physical objects.

Question 47

In a data model,an identifier refers to a unique characteristic of an entity.

Question 48

Employee number is an example of an identifier in the database of an organization.

Question 49

In an E-R diagram,multiple relationships are represented by "crow's feet."

Question 50

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

Question 51

Optimization is the process of converting a poorly structured table into two or more well-structured tables.

Question 52

The object-relationship (OR)technique is the most popular tool for creating a data model.

Question 53

Elimination of duplicated data resolves the data integrity problem.

Question 54

"Address" is an example of a customer entity in a database application.

Question 55

Relationships represented using "crow's feet" have an N:M relationship.

Question 56

Inconsistent attribute changes lead to data integrity problems.

Question 57

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

Question 58

Database requirements are assessed through data gaps identified by the database developers.

Question 59

An N:M relationship can be interpreted to mean that a variable number,greater than one,is allowed on each side of the relationship.

Question 60

If there is a small oval in the crow's foot notation,it means that there might not be any entity.

Question 61

Data aggregators obtain data from public and private sources and store and process it in sophisticated ways.

Question 62

A more formal name for a table is a(n)________.

A)record
B)key
C)relation
D)attribute

Question 63

Columns that belong to a different table than the one in which they reside are called ________.

A)foreign keys
B)parallel records
C)relational files
D)relational databases

Question 64

Storing the attribute of an entity just once eliminates data inconsistencies.

Question 65

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

A)grid network
B)database
C)file system
D)storage folder

Question 66

Bytes are grouped into columns,which in turn are grouped into ________.

A)rows
B)fields
C)files
D)bits

Question 67

Normalization is the only criterion for evaluating database designs.

Question 68

"The tables are not normalized" means that the tables have irregular,not-normal data.

Question 69

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 70

Adjustments to a database should be done before the modeling stage,as they cannot be done at or after this stage.

Question 71

A(n)________ is a column or group of columns that identifies a unique row in a table.

A)record
B)key
C)metadata
D)attribute

Question 72

In a database system,a ________ is the smallest piece of data.

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

Question 73

A group of columns that identify a unique table row is a ________.

A)column
B)record
C)field
D)key

Question 74

The general goal of normalization is to construct tables such that every table has at least two topics or themes.

Question 75

________ softwares assist in creating,maintaining,and manipulating databases.

A)DBMS
B)KMS
C)Operating system
D)Database application

Question 76

A byte is a ________.

A)character of data
B)file system
C)primary memory system
D)record of data

Question 77

Metadata are ________.

A)data on the main server
B)binaries that encode data on to the memory
C)data that describe data
D)a collection of data over a period of time

Question 78

In a relational database,a collection of related records is a(n)________.

A)file
B)table
C)application
D)field

Question 79

Users access databases through a(n)________.

A)operating system
B)database application program
C)relational database system
D)relational report system

Question 80

A collection of similar records is called a ________.

A)field
B)matrix
C)file
D)database