Data Management (Databases) - (Synergy Answers)

Ready answers to the Data Management (Databases) test.
Educational institution: SYNERGY, MY, MIT.
Delivery: fresh.
The result is 90-100 points (40 questions and answers).
Below you can find questions on the Data Management (Databases) test.

QUESTIONS FOR THE TEST:
A set of language and software tools designed for creating, maintaining and sharing a database with many users is...

The operator ... is necessarily included in the construction of the SELECT statement

A transaction is...

The referential integrity constraint is that the database must not contain any...

A set of data fields (elements) ordered in accordance with the nature of the relationships, placed in memory in accordance with their type, is ...

An operator that can be used to grant privileges to a user or application to manipulate objects is...

Tools that allow you to reduce the same entities from different databases and applications to a common type are called...

A hardware and software complex designed for storing and processing information in any subject area is...

An attribute is...

A life cycle model in which the lifetime of each stage is extended over the entire development period and development is carried out in iterations with feedback loops between stages is called...

A function whose result is the number of records in the output set of a query is called...

The ... operator filters groups of rows of an object according to a specified condition

If an attribute Y is not functionally dependent on any exact subset of X, then the functional dependence of an attribute Y on an attribute X is called...

The part of the application built on the client-server architecture is responsible for the actual storage of data, processing of requests and transmission of results.

Elements of the real world, information about which we store and process, are called ...

The set of valid values from which the values of the corresponding attributes of a certain relation are taken is ...

The fundamental principles for organizing data warehouses are...

A subquery that returns a set of values. - This ...

Referential integrity may be violated when performing an operation...

The ... operator filters groups of rows of an object according to a specified condition

A failure that affects all currently running transactions but does not disrupt the physical state of the database is called a failure...

A model that displays information objects, their properties and connections between them without specifying methods for physically storing information is called...

A model that displays all the properties (attributes) of database information objects and the relationships between them, taking into account the method of their storage, is called...

The operator that can be used to revoke user or application privileges is...

A table is...

According to the languages of communication, they distinguish... DBMS

A functional dependence R.X— >R.Y is called transitive if there is an attribute Z such that...

there are functional dependencies R.X-->R.Z and R.Y ~>R.Z

there is no functional dependence R.Z-->R.X

The definition operator for database objects is...

The ... operator is used to compare some value with a list of given values

Relational data model...

When moving to the next normal form, the properties of previous normal forms...

When obtaining a relational diagram from an ER diagram, for each multiple attribute ...

The attribute can be...

The … operator is used to search for a value within a certain range

A relation is in third normal form if and only if it is in second normal form and every non-key attribute...

The process of normalizing relations is...

One of the basic requirements for data banks, that users must be able to use the data in a variety of ways, is called...

Depending on the architecture, DBMSs are divided into...

Properties inherent in "