A shared database should:
Answer: D
Correct answer: All of the above.
A database serving many people must be right, must be there when needed, must be recoverable after a failure, and must let each person see only what they should. None of the four can be dropped: an available database that is inaccurate is worse than useless, and an accurate one that cannot be recovered is a liability.
Please log in or register to report this question.
Data administrators are responsible for:
Answer: C
Correct answer: overall management of data resources in an organization.
Data administration is a policy and stewardship role - standards, definitions, ownership, quality and the enterprise model. Physical design and technical management belong to database administration, and writing applications to development. The distinction is between governing the data and running the machinery.
Please log in or register to report this question.
Which of the following types of databases are the most common?
Answer: C
Correct answer: Department
Departmental databases outnumber the others because most information needs are departmental: a size that justifies a proper shared database but not an enterprise-wide one. Personal databases are numerous but trivial, and enterprise databases are few because there are few enterprises relative to departments.
Please log in or register to report this question.
Which of the following is true for a relational database?
Answer: C
Correct answer: Data is represented by tables.
The relation is the model’s single structure, presented as a table of rows and columns, and everything else follows from it. The other two options are the opposite of the case for the relational model: data is reached by declarative query rather than navigation, and a simple query needs no program at all.
Please log in or register to report this question.
Some advantages of the database approach include all, but:
Answer: D
Correct answer: program-data dependency.
Program-data independence is the advantage - the descriptions live in the catalogue rather than in each program, so a change to the data does not require every program to be rewritten. Dependence is the file-processing defect that the database approach exists to remove, so it is the odd one out here.
Please log in or register to report this question.
An enterprise database is which of the following?
Answer: B
Correct answer: A database designed to support an entire organization
An enterprise database serves the organisation as a whole rather than one group within it, which is what makes it valuable and what makes it difficult: the definitions must be agreed across departments that have used different ones, and the availability requirements are those of the whole business.
Please log in or register to report this question.
Structured data may include which of the following?
Answer: C
Correct answer: Dates
Structured data has a defined type and format that a database can operate on - numbers, dates, codes, fixed-length text. Images and video are unstructured: they can be stored, but the DBMS cannot search or compare their content in the way it can compare two dates.
Please log in or register to report this question.
An extranet is which of the following?
Answer: A
Correct answer: The use of Internet protocols with limited access to company data by the company's customers and suppliers.
An extranet extends the internal network outward to named trading partners, using the same protocols as the public internet but with access controlled and limited. An intranet is the same technology restricted to people within the organisation; the difference is who is admitted, not what is used.
Please log in or register to report this question.
All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.
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.
Please log in or register to report this question.
Database management systems were first introduced in the 1950s.
Answer: B
Correct answer: False
Database management systems appeared in the 1960s, with the network and hierarchical products; the relational model was proposed in 1970 and reached commercial products in the late 1970s and 1980s. The 1950s predate them - that decade’s systems were file processing on tape.
Please log in or register to report this question.
