The Database Environment Questions and Answers

Q: All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

Correct answer: TrueAn ERP system is a set of applications sharing one integrated database, and it is that shared database which lets an order raised in sales appear immediately in manufacturing and in finance. Without it the applications would be separate systems again, which is precisely what ERP was devised to replace.

Q: A database application can perform which of the following activities?

Correct answer: All of the above.A database application is the program through which people work with the data, so it does whatever the users need - adding, reading, updating and deleting records, and presenting the results. The DBMS provides the mechanism; the application supplies the purpose and the interface.

Q: Metadata enables database designers and users to do all of the following except:

Correct answer: sample data.Metadata is data about data: it records what exists, what each item means, and how similar items differ. What it does not contain is the data itself, so it cannot be sampled for values - a designer reading the catalogue learns that a field is a currency amount in sterling, not what any particular amount is.

31.

All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

A.True
B.False

Answer: A

Correct answer: True

An ERP system is a set of applications sharing one integrated database, and it is that shared database which lets an order raised in sales appear immediately in manufacturing and in finance. Without it the applications would be separate systems again, which is precisely what ERP was devised to replace.

Discuss in Forum

32.

A database application can perform which of the following activities?

A.Add records
B.Read records
C.Update records
D.All of the above.

Answer: D

Correct answer: All of the above.

A database application is the program through which people work with the data, so it does whatever the users need - adding, reading, updating and deleting records, and presenting the results. The DBMS provides the mechanism; the application supplies the purpose and the interface.

Discuss in Forum

33.

Metadata enables database designers and users to do all of the following except:

A.sample data.
B.understand what data exist.
C.what the fine distinctions are between similar data items.
D.what the data mean.

Answer: A

Correct answer: sample data.

Metadata is data about data: it records what exists, what each item means, and how similar items differ. What it does not contain is the data itself, so it cannot be sampled for values - a designer reading the catalogue learns that a field is a currency amount in sterling, not what any particular amount is.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: The Database Environment Questions and Answers || The Database Environment MCQ Questions and Answers || The Database Environment GK Questions and Answers || The Database Environment GK MCQ Questions || The Database Environment Multiple Choice Questions and Answers || The Database Environment GK || GK on The Database Environment || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

The Database Environment Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications