Question 1

Discuss the relative benefits and drawbacks of the following file organization methods:
a.sequential
b.indexed-sequential
c.direct

Accepted Answer

The answer of Discuss the relative benefits and drawbacks of...

Question 2

________ is a multidimensional generalization of the 2-dimensional relational table which provides incredibly fast response times.

Accepted Answer

OLAP (Online Analytical Processing) is a multidimensional database that allows for fast query response times by utilizing pre-aggregated data. It is specifically designed for analytical and decision-making purposes, making it an ideal choice for businesses and organizations that require quick and efficient data analysis. UML (Unified Modeling Language) is a modeling language used in software development, RUP (Rational Unified Process) is a software development methodology, and RAD (Rapid Application Development) is a software development approach. However, none of these choices are specifically related to multidimensional databases or fast query response times.

Question 3

ACID

Accepted Answer

ACID (Atomicity, Consistency, Isolation, Durability) ensures the reliability of processing database transactions. It guarantees that each transaction is processed completely or not at all, and maintains consistency and integrity within the database. It also ensures that changes made to the database are durable and can be recovered in case of system failures. ACID does not necessarily make processing data extremely fast or error-free, though it does contribute to data accuracy and reliability.

Question 4

Below are three situations in which the Data Definition Language (DDL),the Data Manipulation Language (DML),or the Data Query Language (DQL)of a database management system will be used.Indicate on the line beside each situation which of the languages would likely be used.
________ A.A programmer uses COBOL to make revisions to the company's payroll application.
________ B.The zip code file in a customer master file is expanded to accommodate the nine digit "zip plus 4" zip codes.
________ C.The personnel director requests a special report regarding the number of employees in the company with a post-secondary education.

Accepted Answer

The answer of Below are three situations in which the...

Question 5

High level query languages include the below except

Accepted Answer

The answer of High level query languages include the below...

Question 6

Object-oriented modeling can be ________ easily into object-oriented program code.

Accepted Answer

Object-oriented modeling can be easily transformed into object-oriented program code. Transformation involves converting one form into another, which is what happens when object-oriented modeling is converted into object-oriented program code.

Question 7

Presented below is a list of terms relating to accounting information systems,followed by definitions of those terms.
Required: Match the letter next to each definition with the appropriate term.Each answer will be used only once.
________ 1.DBA
________ 2.Inheritance
________ 3.Occurrence
________ 4.Branch
________ 5.Database model
________ 6.Record
________ 7.Fully inverted file
________ 8.Trailer record
________ 9.Record key
________ 10.Field
A.The connection between children and parent(s)in a tree structure
B.Individual who has overall responsibility for database administration
C.The smallest block of data that will be stored and retrieved in the information system
D.A synonym for schema
E.A relationship created when an object class is divided into subclasses
F.A file in which all fields are indexed
G.A specific set of data values for a record
H.A logical grouping of fields (data items)that concern a certain entity
I.A data item or combination of data items that uniquely identify a particular record in a file
J.A fixed-length extension of a master record

Accepted Answer

The answer of Presented below is a list of terms...

Question 8

What defines an entire database being loaded into computer-internal high-speed random access memory or other high-speed electronic storage device?

Accepted Answer

When an entire database is loaded into computer-internal high-speed random access memory or other high-speed electronic storage device, it is known as an in-memory database. Therefore, option D, "In-memory database," is the correct answer. Option A, "Internal database," is too broad and could refer to any database that is stored within a computer system. Option B, "In-resident database," is not a commonly used term and could potentially be confused with "in-memory database." Option C, "RAM database," is not specific enough as databases can be stored in other high-speed electronic storage devices besides RAM.

Question 9

In practice,________ databases outperform ________ databases in a wide range of common tasks that are typically performed in a business environment.

Accepted Answer

Relational databases are designed for structured data and common business tasks such as querying, reporting, and transaction processing, making them more efficient in a business environment. Object-oriented databases, on the other hand, are more suitable for complex data and specialized applications, but their performance in common business tasks is generally inferior to relational databases. Conceptual databases are not commonly used in practice as they are more theoretical in nature.

Question 10

Presented below is a list of terms relating to accounting information systems,followed by definitions of those terms.
Required: Match the letter next to each definition with the appropriate term.Each answer will be used only once.
________ 1.Logical data structure
________ 2.Key
________ 3.Node
________ 4.DQL
________ 5.Element
________ 6.Hypertext systems
________ 7.DML
________ 8.SELECT
________ 9.First normal form
________ 10.DDL
A.Defines the logical structure of the database (schema)
B.A synonym for field
C.A synonym for record key
D.Systems that allow users to browse through databases in random fashion by selecting key words or objects
E.The rational manner in which records and fields in the database are structured and organized
F.Almost all statements in SQL begin with this word
G.The commands for updating,editing,manipulating,and extracting data from a database
H.A user-friendly language or interface that allows the user to request information from the database
I.Relational tables that do not contain any repeating groups
J.A synonym for repeated group

Accepted Answer

The answer of Presented below is a list of terms...

Question 11

Describe the duties of the database administrator (DBA)regarding the data dictionary.

Accepted Answer

The answer of Describe the duties of the database administrator...

Question 12

A database contains the following data:
Student Schedule (Student#,Student_name,Major,Course#1,ClassTime1,Location1,Course#2,ClassTime2,Location2,Course#3,ClassTime3,Location3)
Required: Normalize this relation through the third normal form.

Accepted Answer

The answer of A database contains the following data:
Student Schedule...

Question 13

Describe the index,prime area,and overflow area in an ISAM file structure.

Accepted Answer

The answer of Describe the index,prime area,and overflow area in...

Question 14

OLAP uses complicated multidimensional "indexes" called

Accepted Answer

OLAP uses complicated multidimensional "indexes" known as aggregations to summarize and access data quickly for analysis.

Question 15

Presented below is a list of terms relating to accounting information systems,followed by definitions of those terms.
Required: Match the letter next to each definition with the appropriate term.Each answer will be used only once.
________ 1.Ring structure
________ 2.Alias
________ 3.ISAM
________ 4.Relational algebra
________ 5.Tuple
________ 6.Activity ratio
________ 7.Variable-length record
________ 8.Normalization
________ 9.Disk access time
________ 10.Randomizing transformation
A.A row in a relational table
B.Both the number of fields and the length (character size)of each field are variable
C.A list organization in which the last record in the ring points back to the first record
D.Operations used to extract information from relational tables
E.A widely used method of storing and locating records in a direct-access file
F.The process of applying normal form rules in the relational database model
G.A synonym for indexed-sequential file organization
H.The length of time required for the CPU to retrieve a single block of data from the disk
I.Different users call the same field different names
J.The number of active records divided by the number of records in the file

Accepted Answer

The answer of Presented below is a list of terms...

Question 16

Assume that the customer master file and the transaction file consist of the record numbers shown in the following sequence:
$\begin{array} { l l } 
\text { Master file } & 3,7,23,76,79,99 \
\text { Transaction file } & 3,4,23,23,7,76,99
\end{array}$
The record number 99 denotes the logical end of the file.The program processes records in ascending order.
Required: On the lines below,indicate the numbers of records affected as described.
a.Master records which were updated ________
b.Master records which were not updated ________
c.Transaction records which were posted ________
d.Transaction records which were not posted (an error condition)________

Accepted Answer

The answer of Assume that the customer master file and...

Question 17

The "C" in ACID stands for

Accepted Answer

The "C" in ACID stands for "Consistency". This means that a transaction must be consistent and bring the database from one valid state to another.

Question 18

Third party reporting solutions can provide end users the ability to easily extract reports and queries from the application database.Examples of these reporting solutions include

Accepted Answer

Both Crystal Reports and MicroStrategy are examples of third-party reporting solutions that can provide end-users with the ability to easily extract reports and queries from the application database. OLAP is not a reporting solution, but rather a technology used for analyzing data.

Question 19

Below are four situations in which the DML component of SQL can be used to manipulate and/or extract data.Indicate on the line beside each situation the letter(s)of the SQL statement,command,or condition which will allow a user to manipulate and/or extract the requested data and information.An answer may be used more than once,but not all answers will be used.
A.SELECT
B.WHERE
C.ON
D.OR
E.COUNT AS
F.GROUP BY
G.ORDER BY
H.FROM
I.INNER JOIN
J.IN
________ 1.The query calls for selecting certain names and zip codes,sorted by zip code.
________ 2.The query calls for selecting certain companies found in the USA and Canada tables and grouping them by country
________ 3.The query calls for appending the company name for company 12 to the topics located in the notes table.
________ 4.The query calls for summarizing the count of companies by country.

Accepted Answer

The answer of Below are four situations in which the...

Question 20

Listed below are ten examples of file organization.
Required: From the following three choices,match the file organization technique with each of the ten examples listed.All techniques will be used more than once.
S = Sequential
IS = Indexed-sequential
D = Direct access
________ 1.A large manufacturing company pays all employees once a week.
________ 2.The inventory system of a 24-hour grocery store automatically orders merchandise from vendors when the inventory level is low.
________ 3.A bank customer checking account file is online in an ATM network.The bank also uses the file each month to produce customer statements.
________ 4.An Internet retailer sells children's toys online.
________ 5.An airline reservation system answers customer inquiries about available flights and seats and makes customer reservations.
________ 6.Bookstore employees use an inventory file each week to prepare purchase orders for books.
________ 7.A plant assets file for a small manufacturer is used to prepare quarterly depreciation reports.It is used once a year to prepare a report for insurance purposes.
________ 8.Employees use a vendor application at a trucking company daily to answer questions and accrue accounts payable.The company writes checks to vendors once a week.
________ 9.A file of payables due to actors and writers is processed monthly to prepare royalty checks; it is also used once a year to prepare tax reports.
________ 10.A metropolitan branch library scans books to check them out,answers patron inquiries about available books,and mails monthly statements to patrons having overdue books.

Accepted Answer

The answer of Listed below are ten examples of file...

Quiz 13: Data Management Concepts

Discuss the relative benefits and drawbacks of the following file organization methods: a.sequential b.indexed-sequential c.direct

________ is a multidimensional generalization of the 2-dimensional relational table which provides incredibly fast response times.

ACID

High level query languages include the below except

Object-oriented modeling can be ________ easily into object-oriented program code.

What defines an entire database being loaded into computer-internal high-speed random access memory or other high-speed electronic storage device?

In practice, databases outperform databases in a wide range of common tasks that are typically performed in a business environment.

Describe the duties of the database administrator (DBA)regarding the data dictionary.

A database contains the following data: Student Schedule (Student#,Student_name,Major,Course#1,ClassTime1,Location1,Course#2,ClassTime2,Location2,Course#3,ClassTime3,Location3) Required: Normalize this relation through the third normal form.

Describe the index,prime area,and overflow area in an ISAM file structure.

OLAP uses complicated multidimensional "indexes" called

The "C" in ACID stands for

Third party reporting solutions can provide end users the ability to easily extract reports and queries from the application database.Examples of these reporting solutions include