When data are entered into a type and also saved, they are placed in the underlying database as knowledge.a. True

b. False

File constitute the building blocks of indevelopment.a. True

b. False

Metadata explain the data features and also the set of relationships that web links the information found within the database.a. True

b. False

The just method to accessibility the data in a database is through the DBMS.a. True

b. False

Database programming languages get all application requests and also translate them into the complex operationscompelled to meet those researches.a. True

b. False

The DBMS reveals a lot of the database’s inner complexity to the application programs and also individuals.a. True

b. False

One disbenefit of the DBMS is that it rises the risk of data security breaches.a. True

b. False

An operational database is occasionally described as an enterpincrease database.a. True

b. False

A information wareresidence deserve to store information acquired from many kind of sources.a. True

b. False

The very same data can be at the same time structured and also unstructured depending on the intended handling.a. True

b. False

Corporations usage just structured data.a. True

b. False

Field refers to a arsenal of connected documents.a. True

b. False

Structural dependence exists as soon as it is feasible to make alters in the file structure without affecting the applicationprogram’s capacity to accessibility the information.a. True

b. False

File anomaly is defined as the problem in which every one of the data in the database are consistent with the real-worldoccasions and conditions.a. True

b. False

One disadvantage of a database system over previous information management ideologies is raised costs.a. True

b. False

An benefit of database devices is that you needn"t perdevelop regular updays and also apply latest patches.a. True

b. False

One benefit of a database device over previous data administration ideologies is that the database device issignificantly much less complex.a. True

The response of the DBMS to a query is the ___a. ad hoc query b. ad hoc response

c. query outcome set d. integrated see of the data

A(n) _____ database is used by an organization and also supports many individuals across many kind of departments.a. desktop computer b. workgroup

c. enterpclimb d. transactional

A(n) _____ database supports a reasonably little variety of users (normally fewer than 50) or a particular departmentwithin an organization.a. desktop computer b. workgroup

c. enterpincrease d. transactional

A workteam database is a(n) _____ database.a. single-user

b. multiuser

c. desktop computer d. distributed

A desktop computer database is a _____ database.a. single-user

b. multiuser

c. workgrou p

d. distributed

Documents warehouse includes historical data obtained from the _____.a. operational databases b. desktop database

c. enterpclimb databases d. workgroup databases

_____ data exist in the format in which they were gathered.a. Structured b. Semistructured

c. Unstructured

d. Historical

_____ data exist in a format that does not lfinish itself to processing that yields information.a. Structured b. Semistructured

c. Unstructured

d. Historical

_____ are the outcome of formatting disarranged information in order to facilitate storage, use and also generation of information.

You are watching: _____ serve as the intermediary between the user and the database.

a. Structured data b. Raw data

c. Unstructured data

d. Obsolete data

Most information that can be encountered are best classified as _____.a. structured b. semistructured

c. unstructured d. historical

An XML database supports the storage and also management of _____ XML information.a. structured b. multistructured

c. fullystructured d. semistructured

The organization of information within folders in a hand-operated file system is established by ___.a. its date of development b. its supposed use

c. the title of the records in thefolder

d. the data handling specialist

A _____ is a logically associated collection of one or even more fields that defines a perkid, place, or point.a. database b. column

c. record d. file

A _____ is a collection of associated records.a. schema b. field

c. column d. file

A _____ is a character or team of characters that has a certain definition.a. database b. field

c. record d. file

Which of the following is true of spreadsheet applications?a. They provide amplified protection and robust data sharingattributes.

b. They execute not allow manipulation of data when entered.

c. They are a better different to databases. d. They improve the user"s capacity to understand also the information.

Which of the complying with describes the situation wright here various versions of the very same information are stored at various placesbecause they weren’t updated consistently?a. Data query b. Data integrity

c. Documents dictionary d. File redundancy

Documents is sassist to be verifiable if:a. the information constantly returns continual outcomes. b. the information cannot be readjusted or manipulated.

_____ databases emphasis mostly on storing data used to generate indevelopment forced to make tactical or strategicdecisions.

_____ is a distinct language provided to recurrent and also manipulate data elements in a textual format.

_____ exists when it is possible to make changes in the data storage qualities without affecting an applicationprogram’s ability to access data.

The term _____ refers to scattered areas storing the same basic data.

_____ exists when different and also conflicting versions of the very same data show up in various places.

A(n) _____ creates as soon as all required transforms in the redundant information are not made effectively.

The DBMS uses the _____ to look up the required information component frameworks and also relationships, thus relievingprogrammers from having actually to code such complex relationships in each regimen.

_____ relates to tasks that make a database operate more properly in terms of storage and also access rate.

Describe what metainformation are and also what worth they provide to the database mechanism.

ANSWER: The metadata describe the data characteristics and the set of relationships that web links the information found within the database. For instance, the metadata component stores indevelopment such as the name of each information facet, the form of worths (numeric, dates, or text) stored on each data aspect, and also whether the data aspect have the right to be left empty. The metadata carry out information that complements and also expands the worth and use of the data. In brief, metadata current an extra finish photo of the information in the database. Given the qualities of metadata, you could hear a database explained as a “repertoire of self-describing information.”

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: REF: p. 6

LEARNING OBJECTIVES: DATA.CORO.15.LO1-3 - LO1-

NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and also Management Science

TOPICS: Introducing the Database

KEYWORDS: Bloom"s: Comprehension

What are the advantages of having actually the DBMS in between the finish user’s applications and the database?ANSWER: Having a DBMS between the finish user’s applications and also the database uses some importantbenefits. First, the DBMS allows the information in the database to be common among multipleapplications or individuals. Second, the DBMS integrates the many type of different users’ views of theinformation into a single all-encompassing information repository.

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: REF: p. 6

LEARNING OBJECTIVES: DATA.CORO.15.LO1-3 - LO1-

NATIONAL STANDARDS: USA - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science

TOPICS: Introducing the Database

KEYWORDS: Bloom"s: Comprehension

Discuss some considerations as soon as designing a database.

ANSWER: Ideal database design needs the designer to identify precisely the database’s intended usage. Designing a transactional database emphasizes accurate and also continuous information and operational rate. Designing a file warehome database emphasizes the use of historic and also aggregated data. Designing a database to be provided in a centralized, single-user setting requires a various strategy from that used in the style of a spread, multiuser database.

Designing correct data repositories of included information using the two-dimensionaltable frameworks discovered in most databases is a process of decomposition. The incorporated datamust be dewritten properly right into its constituent components, through each component stored in its very own table.More, the relationships in between these tables have to be closely taken into consideration and implementedso the integrated check out of the data deserve to be re-developed later on as information for the finish user. Awell-designed database facilitates data administration and generates specific and also valuableinformation. A poorly designed database is likely to come to be a breeding ground for difficult-to-trace errors that may cause poor decision making—and also poor decision making have the right to lead tothe faientice of an company. Database architecture is simply too important to be left to luck.That’s why college students study database design, why organizations of all types and sizessend personnel to database style seminars, and why database architecture consultants regularly makea wonderful living.

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: REF: p. 14

LEARNING OBJECTIVES: DATA.CORO.15.LO1-4 - LO1-

NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science

TOPICS: Why Database Deauthorize is Important

KEYWORDS: Bloom"s: Comprehension

What are some factors for studying file systems?ANSWER: A brief explacountry of the development of file device information handling have the right to be useful inknowledge the data access constraints that databases attempt to conquer. Understandingthese limitations is pertinent to database developers and also developers because databasetechnologies do not make these problems magically disappear—database technologies simplymake it much easier to develop solutions that prevent these difficulties. Creating database deindicators thatavoid the pitdrops of previously units needs that the designer understand also these difficulties andexactly how to protect against them; otherwise, the database innovations are no much better (and are potentiallyeven worse!) than the technologies and also methods they have actually replaced.

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: REF: p. 14

LEARNING OBJECTIVES: DATA.CORO.15.LO1-5 - LO1-

NATIONAL STANDARDS: United States - BUSPROG: Analytic

TOPICS: Why Database Design is Important

ANSWER: 1. System administrators overcheck out the database system’s basic operations.

Database administrators, additionally recognized as DBAs, manage the DBMS and also encertain that the database is functioning appropriately.

Database developers design the database structure. They are, in impact, the database architects. If the database style is bad, also the ideal application programmers and also the most dedicated DBAs cannot develop a beneficial database environment. Because establishments strive to optimize their data resources, the database designer’s job summary has actually broadened to cover new dimensions and also growing obligations.

System experts and also programmers architecture and implement the application programs. They architecture and also produce the data-enattempt displays, reports, and also steps with which finish individuals access and also manipulate the database’s information.

End individuals are the human being who use the application programs to run the organization’s daily operations. For instance, sales clerks, supervisors, managers, and directors are all classified as end users. High-level finish users employ the information obtained from the database to make tactical and also strategic service decisions.

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: REF: p. 23-

LEARNING OBJECTIVES: DATA.CORO.15.LO1-7 - LO1-

NATIONAL STANDARDS: United States - BUSPROG: Analytic

TOPICS: Database Systems

KEYWORDS: Bloom"s: Comprehension

What are the disadvantages of database systems?ANSWER: Although the database mechanism returns substantial advantages over previous dataadministration ideologies, database systems execute bring considerable disadvantages:

 Increased expenses. Database systems call for sophisticated hardware and also software and

highly experienced personnel. The price of keeping the hardware, software program, andpersonnel compelled to operate and control a database device can be substantial.Training, licensing, and regulation compliance costs are often overlooked whendatabase systems are enforced.

 Management intricacy. Database devices interchallenge through many type of different

technologies and have actually a far-ranging impact on a company’s sources and also culture.The transforms introduced by the fostering of a database mechanism must be properlyregulated to encertain that they help development the company’s goals. Becausedatabase devices host important firm information that are accessed from multiple resources,protection concerns should be assessed constantly.

 Maintaining money. To maximize the effectiveness of the database mechanism, you must

keep your system cur-rent. Therefore, you should perdevelop regular updays and applythe latest patches and also security measures to all components. Because databaseinnovation advances rapidly, personnel training prices tfinish to be substantial.

 Vendor dependence. Given the heavy investment in innovation and personnel

training, suppliers can be reluctant to adjust database merchants. As aconsequence, sellers are less most likely to market pricing suggest advantages to existingcustomers, and those customers can be restricted in their option of database systemcomponents.

 Frequent upgrade/replacement cycles. DBMS vendors commonly upgrade their

assets by adding new func-tionality. Such new attributes regularly come bundled in newupgrade versions of the software program. Some of these ver-sions require hardwareupgrades. Not just carry out the upqualities themselves expense money, it additionally prices money totrain database users and also administrators to correctly usage and also control the brand-new features.

See more: Why Is Edna Turnblad Played By A Man, Edna Turnblad

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: REF: p. 28

LEARNING OBJECTIVES: DATA.CORO.15.LO1-7 - LO1-

NATIONAL STANDARDS: USA - BUSPROG: Analytic

TOPICS: Database Systems

KEYWORDS: Bloom"s: Comprehension

Discuss any kind of 3 features performed by the DBMS that guarantee the integrity and also consistency of the information in thedatabase.ANSWER: (answers may vary)

 File dictionary administration. The DBMS stores definitions of the information aspects and their relationships (metadata) in a documents dictionary. In revolve, all programs that access the information in the database job-related via the DBMS. The DBMS provides the information dictionary to look up the forced information component frameworks and relationships, hence relieving you from having to code such complicated relationships in each routine. In addition, any kind of changes made in a database framework are immediately taped in the information dictionary, thereby releasing you from having to modify all of the programs that access the changed framework. In various other words, the DBMS gives information abstraction, and it removes structural and also data dependence from the system. Documents storage management. The DBMS creates and manages the complicated frameworks required for information stor-age, hence relieving you from the tough task of specifying and also programming the physical information features. A modern-day DBMS provides storage not only for the information but for related data-entry creates or display screen meanings, report interpretations, information validation rules, procedural code, structures to handle video and also image layouts, and also so on. File storage administration is likewise crucial for database performance tuning. Performance tuning relates to the activities that make the database percreate more successfully in terms of storage and accessibility speed. Although the user sees the database as a single information storage unit, the DBMS actually stores the database in multiple physical information files. Such information papers might even be stored on different storage media. Thus, the DBMS doesn’t have to wait for one disk repursuit to complete prior to the following one starts. In other words, the DBMS have the right to fulfill database repursuits concurrently. Data transformation and presentation. The DBMS transforms entered information to condevelop to required data frameworks. The DBMS relieves you of the chore of differentiating in between the logical information format and also the physical data format. That is, the DBMS layouts the physically retrieved information to make it conform to the user’s logical expectations. Security administration. The DBMS creates a defense mechanism that enpressures user security and also data privacy. Security rules recognize which individuals deserve to access the database, which information items each user have the right to access, and which information operations (review, add, delete, or modify) the user have the right to perdevelop. This is especially crucial in multiuser database devices.