Платонус УПР 1-30

What gives the result of the combination of entities?

• E/R scheme

• supertype

• relation

• attribute

Which of the following means the entity property?

• subtype

• scheme E/ R

• supertype

• attribute

Which functional component controls matches in the database?

• database manager

• file manager

• disk manager

• database administrator

• administrator

Who is responsible for the design, maintenance and database security?

• application developer

• database administrator

• database manager

• user

Which of the actions in the design of a relational database is not included in the stage of deployment?

• DBMS selection and purchase

• The transformation of the conceptual model to the real

• Creating of the Data Dictionary

• Testing and maintenance of the database

What is the last stage in relational database design?

• Determine requirements

• Database testing and maintenance

• Conceptual design

• Deployment

Who is the primary user of the database or who is the database intended for?

• database manager

• database administrator

• user

• application developer

• database developer

To ensure good quality of the database design you should not adhere to one of the rules:

• Each table must have unique name

• Each table should store data of one entity type

• Avoid the NULL column

• Avoid repeating values or columns

• Each table should store data of different entity types

In which system database all information about specific server configuration is stored, particularly about data of registered users, databases, configuration options of the system and remote servers:

• Master

• TempDB

• Model

• MSDB

• Purpose

Which of the following are necessary for the communication compatibility between the two tables?

• Attributes with the same data type

• Attributes with unique data

• Attributes with different data types