The Database Development Process Questions and Answers

Q: The three-schema components include all, but:

Correct answer: programming schema.The three-schema architecture has an internal schema describing physical storage, a conceptual schema describing the whole logical structure, and external schemas describing each user group’s view. There is no programming schema; the point of the architecture is precisely to insulate programs from the other two levels.

Q: Which is not a type of data management technology?

Correct answer: RationalRelational, object-oriented and dimensional are the three data management technologies a logical design may target, each with its own structures and its own products. Rational is not one of them - the similarity of the word to relational is the whole of the trap.

Q: Which is not a relevant feature of CASE tools?

Correct answer: Access to a DB via the InternetCASE tools support the development of the system: drawing data models, generating code, and holding the metadata in a repository. Providing users with internet access to a running database is an application function, delivered by the system that was built rather than by the tool that built it.

Q: The first step in database development is which of the following?

Correct answer: Enterprise data modelingEnterprise data modelling comes first because it establishes the scope: what data the organisation holds, at a high level, and which database projects are worth undertaking. The later steps - conceptual, logical and physical design, then implementation - all work within the boundaries it sets.

Q: Which of the following database activities determines the entities, attributes, and relationships of data?

Correct answer: Conceptual data modelingConceptual data modelling identifies the entities, attributes and relationships for the area being developed, and does so independently of any product. It is the detailed analysis stage: the enterprise model above it is a summary, and the logical design below it converts the result into a particular technology.

Q: The use of packaged data models can offer which of the following benefits?

Correct answer: Both A and B.A packaged model brings the accumulated experience of many implementations in an industry, so it starts from a structure that has already been thought through, and it saves the time of deriving it again. Both benefits are real, and both are contingent on tailoring it to the organisation rather than adopting it unchanged.

Q: The Enterprise tier of the three-tiered database architecture includes:

Correct answer: managing the data.The three tiers divide the work: the client tier manages the user-system interface, the department tier does the processing, and the enterprise tier manages the data. The enterprise tier is where the shared database lives, which is what makes it enterprise-wide rather than departmental.

Q: Strategic Planning factors do not include which of the following?

Correct answer: Information engineeringThe strategic planning factors are the organisation’s goals, its critical success factors and its problem areas - the things the plan must respond to. Information engineering is a methodology for doing the planning, so it is the means rather than one of the factors considered.

Q: CASE tools do not include which of the following features?

Correct answer: Help to manage peopleCASE tools work on the model and the code: drawing diagrams, generating code, maintaining a repository of metadata, checking consistency. Managing people is a project management function, served by different tools and by different disciplines altogether.

The three-schema components include all, but:

A.internal schema.
B.conceptual schema.
C.programming schema.
D.external schema.

Answer: C

Correct answer: programming schema.

The three-schema architecture has an internal schema describing physical storage, a conceptual schema describing the whole logical structure, and external schemas describing each user group’s view. There is no programming schema; the point of the architecture is precisely to insulate programs from the other two levels.

Discuss in Forum

Which is not a type of data management technology?

A.Relational
B.Rational
C.Object-oriented
D.Dimensional

Answer: B

Correct answer: Rational

Relational, object-oriented and dimensional are the three data management technologies a logical design may target, each with its own structures and its own products. Rational is not one of them - the similarity of the word to relational is the whole of the trap.

Discuss in Forum

Which is not a relevant feature of CASE tools?

A.The ability to help draw data models using entity-relationship notations
B.The ability to generate code
C.An information repository
D.Access to a DB via the Internet

Answer: D

Correct answer: Access to a DB via the Internet

CASE tools support the development of the system: drawing data models, generating code, and holding the metadata in a repository. Providing users with internet access to a running database is an application function, delivered by the system that was built rather than by the tool that built it.

Discuss in Forum

The first step in database development is which of the following?

A.Enterprise data modeling
B.Logical database design
C.Physical database design and definition
D.Database Implementation

Answer: A

Correct answer: Enterprise data modeling

Enterprise data modelling comes first because it establishes the scope: what data the organisation holds, at a high level, and which database projects are worth undertaking. The later steps - conceptual, logical and physical design, then implementation - all work within the boundaries it sets.

Discuss in Forum

Which of the following database activities determines the entities, attributes, and relationships of data?

A.Conceptual data modeling
B.Logical database design
C.Physical database design and definition
D.Database implementation

Answer: A

Correct answer: Conceptual data modeling

Conceptual data modelling identifies the entities, attributes and relationships for the area being developed, and does so independently of any product. It is the detailed analysis stage: the enterprise model above it is a summary, and the logical design below it converts the result into a particular technology.

Discuss in Forum

The use of packaged data models can offer which of the following benefits?

A.Reduce implementation time and costs
B.Higher quality models
C.Both A and B.
D.Neither A nor B.

Answer: C

Correct answer: Both A and B.

A packaged model brings the accumulated experience of many implementations in an industry, so it starts from a structure that has already been thought through, and it saves the time of deriving it again. Both benefits are real, and both are contingent on tailoring it to the organisation rather than adopting it unchanged.

Discuss in Forum

The Enterprise tier of the three-tiered database architecture includes:

A.managing the data.
B.managing the User-system interface.
C.processing HTTP protocol.
D.processing scripting tasks.

Answer: B

Correct answer: managing the data.

The three tiers divide the work: the client tier manages the user-system interface, the department tier does the processing, and the enterprise tier manages the data. The enterprise tier is where the shared database lives, which is what makes it enterprise-wide rather than departmental.

Discuss in Forum

An entity type is which of the following?

A.A major category of data about people, place, and things
B.The various departments of an organization
C.The application software
D.The business processes the support the mission of an organization

Answer: A

Correct answer: A major category of data about people, place, and things

An entity type is a category of things the organisation keeps data about - customer, product, order - and the individual instances are its occurrences. Departments, software and business processes are all things an organisation has, but they are not what the term denotes.

Discuss in Forum

Strategic Planning factors do not include which of the following?

A.Organizational goals
B.Critical success factors
C.Information engineering
D.Problem areas

Answer: C

Correct answer: Information engineering

The strategic planning factors are the organisation’s goals, its critical success factors and its problem areas - the things the plan must respond to. Information engineering is a methodology for doing the planning, so it is the means rather than one of the factors considered.

Discuss in Forum

10.

CASE tools do not include which of the following features?

A.Help to draw data models
B.Help to generate code
C.Help to manage people
D.Create an information repository

Answer: C

Correct answer: Help to manage people

CASE tools work on the model and the code: drawing diagrams, generating code, maintaining a repository of metadata, checking consistency. Managing people is a project management function, served by different tools and by different disciplines altogether.

Discuss in Forum

Loading…

Topics

Other Subjects

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

The Database Development Process Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications