Claudia Piscociu
Quiz by , created more than 1 year ago

Database Quiz on Chapter 5, created by Claudia Piscociu on 07/02/2017.

4
0
0
Miruna Teodora
Created by Miruna Teodora almost 8 years ago
Claudia Piscociu
Copied by Claudia Piscociu almost 8 years ago
Close

Chapter 5

Question 1 of 9

1

In the methodology of developing databases, the entity-relationship diagram results from the:

Select one or more of the following:

  • functional analysis

  • dynamic design

  • structural analysis

  • dynamic analysis

  • logical design

Explanation

Question 2 of 9

1

When organizing a database, the following aspects are considered:

Select one or more of the following:

  • organizing input data

  • organizing output data

  • organizing storing data

  • organizing the final processing

  • organizing programs

Explanation

Question 3 of 9

1

The effectiveness of a database can be assessed by:

Select one or more of the following:

  • the study of the flowchart of an organization

  • the study of initial costs

  • the calculation of return

  • relational calculus

  • relational algebra

Explanation

Question 4 of 9

1

In the methodology for developing a database, building a view is made in the:

Select one or more of the following:

  • external schema design

  • conceptual schema design

  • internal schema design

  • logical analysis

  • overall analysis

Explanation

Question 5 of 9

1

The objectives in achieving a database are:

Select one or more of the following:

  • the same data cannot be used in different ways

  • increasing the cost for data storage

  • retrieval requests should only be predetermined

  • database applications must be able to reuse already existing data

  • minimum redundancy, but uncontrolled

Explanation

Question 6 of 9

1

Types of user for the databases are:

Select one or more of the following:

  • small and medium enterprises

  • aggregates

  • intensives

  • end-users

  • specialists

Explanation

Question 7 of 9

1

In the methodology for database developing, the design phase contains:

Select one or more of the following:

  • choosing the DBMS

  • choosing the involved personnel

  • choosing real world entities

  • dynamic design

  • schemas design

Explanation

Question 8 of 9

1

In the methodology for database developing, the analytical activity is conducted under the following aspects:

Select one or more of the following:

  • static informational

  • structural

  • modular

  • object

  • functional

Explanation

Question 9 of 9

1

In order to achieve a database, choosing a DBMS takes into account the following aspects:

Select one or more of the following:

  • legislative requirements

  • application requirements

  • technical facilities of DBMS

  • universal programming languages

  • limits of users

Explanation