Data Management (Databases) - (Answers Synergy)
Replenishment date: 27.05.2024
Contents: data management synergy answers.pdf (206.07 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
0
Refunds:
0
Reviews:
0
Description
Answers to the test Data Management (Databases) - SYNERGY, MY, MIT.
The result is 93-100 points.
The test was taken in 2024.
To search for test answers in a WORD file, press the combination "CTRL+F". Then enter a question to quickly find the answer.
Before purchasing, be sure to review the questions already provided in advance, as tests and instructors change!
Questions:
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 of physical storage of 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 relationship RX—>RY is said to be transitive if there is an attribute Z such that...
there are functional dependencies RX-->RZ and RY ~>RZ
there is no functional dependence RZ-->RX
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 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 main requirements for data banks is that users must be able to
The result is 93-100 points.
The test was taken in 2024.
To search for test answers in a WORD file, press the combination "CTRL+F". Then enter a question to quickly find the answer.
Before purchasing, be sure to review the questions already provided in advance, as tests and instructors change!
Questions:
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 of physical storage of 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 relationship RX—>RY is said to be transitive if there is an attribute Z such that...
there are functional dependencies RX-->RZ and RY ~>RZ
there is no functional dependence RZ-->RX
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 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 main requirements for data banks is that users must be able to
Additional Information
Depending on the architecture, DBMSs are divided into...The properties inherent in an “ideal” distributed database management system are the ability...
A relation is in second normal form (assuming that the only key of the relation is the primary key) if and only if it is in first normal form and each...
Based on the topology of data storage, there are... databases
Data recording is...
The set of functional characteristics of objects and features of information presentation is ...
A relation containing a candidate key that is referenced by some foreign key is called...
Information represented by data of a factual nature is called...
A key that uniquely identifies a record is called...
A model, which is a means of formalizing the subject area of systems and is focused on processing factual information, is ...
The property of a distributed database management system, which is that the RDBMS must work with data stored in systems with different architectures and performance, is ...
To identify well-structured information, ... a way to describe it is suitable
The network data model is based on the representation of information...
The key field is...