The Database Development Process MCQ

Test your knowledge with important The Database Development Process MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more The Database Development Process MCQs on Bissoy. Bissoy App

• With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.
  ক

  True

  খ

  False
• Packaged data models can reduce implementation times and costs.
  ক

  True

  খ

  False
• Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.
  ক

  True

  খ

  False
• The goal of information systems planning is to align information technology with the business strategies of the organization.
  ক

  True

  খ

  False
• One of the most popular systems development life cycle methods is prototyping.
  ক

  True

  খ

  False
• There are three stages involved when analyzing the initiation of an information systems project.
  ক

  True

  খ

  False
• Incremental commitment does not allow a project to be easily redirected or to be terminated.
  ক

  True

  খ

  False
• The longest step of database development is database maintenance.
  ক

  True

  খ

  False
• The physical database design identifies data integrity and security requirements.
  ক

  True

  খ

  False
• A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.
  ক

  True

  খ

  False
• During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.
  ক

  True

  খ

  False
• Enterprise data modeling typically occurs during information systems planning.
  ক

  True

  খ

  False
• The systems development life cycle cannot be used with database implementation.
  ক

  True

  খ

  False
• The most important reason for data architecture is reliability.
  ক

  True

  খ

  False
• There is one physical schema for each logical schema.
  ক

  True

  খ

  False
• Whose role is it to determine the requirements and design for a database?
  ক

  Database analysts

  খ

  Database administrators

  গ

  Both A and B

  ঘ

  Neither A or B
• User views are included as part of which schema?
  ক

  Internal

  খ

  Conceptual

  গ

  External

  ঘ

  None of the above.
• Which of the following database activities require a specific knowledge of a DBMS?
  ক

  Enterprise modeling

  খ

  Conceptual data modeling

  গ

  Logical database design

  ঘ

  Physical database design and definition
• CASE tools do not include which of the following features?
  ক

  Help to draw data models

  খ

  Help to generate code

  গ

  Help to manage people

  ঘ

  Create an information repository
• Strategic Planning factors do not include which of the following?
  ক

  Organizational goals

  খ

  Critical success factors

  গ

  Information engineering

  ঘ

  Problem areas
• An entity type is which of the following?
  ক

  A major category of data about people, place, and things

  খ

  The various departments of an organization

  গ

  The application software

  ঘ

  The business processes the support the mission of an organization
• The Enterprise tier of the three-tiered database architecture includes:
  ক

  managing the data.

  খ

  managing the User-system interface.

  গ

  processing HTTP protocol.

  ঘ

  processing scripting tasks.
• The use of packaged data models can offer which of the following benefits?
  ক

  Reduce implementation time and costs

  খ

  Higher quality models

  গ

  Both A and B.

  ঘ

  Neither A nor B.
• Which of the following database activities determines the entities, attributes, and relationships of data?
  ক

  Conceptual data modeling

  খ

  Logical database design

  গ

  Physical database design and definition

  ঘ

  Database implementation
• Which is not a relevant feature of CASE tools?
  ক

  The ability to help draw data models using entity-relationship notations

  খ

  The ability to generate code

  গ

  An information repository

  ঘ

  Access to a DB via the Internet
• Which is not a type of data management technology?
  ক

  Relational

  খ

  Rational

  গ

  Object-oriented

  ঘ

  Dimensional
• The three-schema components include all, but:
  ক

  internal schema.

  খ

  conceptual schema.

  গ

  programming schema.

  ঘ

  external schema.
• Which of the following database activities allow for the actual retrieval and use of a database?
  ক

  Enterprise modeling

  খ

  Logical database design

  গ

  Physical database design and definition

  ঘ

  Database implementation