Exam 13: Data Management Concepts

Four records have the record structure: PART (PART_NO,WARHSE). PART (101,1) PART (101,2) PART (103,1) PART (106,1) Which of the following would be appropriate to use as a record key?

ACID

A data item or combination of data items that uniquely identify a particular record in a file is called a(n)

In the CUSTOMER record,the field NAME contains the word "Jones" along with 20 spaces after the last character.This is an example of a

Database management systems have the ability to integrate separate data files for various accounting applications.In the absence of integration,each type of accounting application will maintain its own independent data files.Which of the following is an advantage of maintaining separate files for accounting applications?

A database has a hierarchical data structure.This is an example of defining database architecture at the

In the object-oriented modeling technique,related groups of fields are known as

A software database ________,also called a database connector,can be used to connect the business application to the DBMS.

Tables without repeating groups in a relational database are said to be

Assume that the customer master file and the transaction file consist of the record numbers shown in the following sequence: Master file 3,7,23,76,79,99 Transaction file 3,4,23,23,7,76,99 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)________

The database computer language that consists of commands for updating and extracting data is

The essential characteristics of the database approach to data processing of accounting data requires that

The term ________ ________ order applies to a field on which the file is not sorted.

In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2) Which field is the key?

A petabyte is 10¹⁵ bytes (characters).

In SQL,the query to extract a customer name from a table identified as company is

In-memory database differs from conventional databases in that the entire database is loaded into computer-internal high-speed random access memory or other high-speed electronic storage device.

In the first normal form,repeated groups are allowed.

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.

What is ACID? Provide a description of each part.