Databases (Synergy Answers)

Databases Test Responses Synergy 30 questions - rating Good The information presented by data having a factual nature is called ... poorly structured documentary formal well structured The key that uniquely identifies a record is called ... external alternative composite primary The model, which is a means of formalized representation of the subject area of ​​systems and is focused on the processing of factual information, is ... external model entity-relationship model datalogical model physical model The property of a distributed database management system, namely that the RDBMS must work with data stored in systems with different architectures and performance, is ... distributed transaction support access universality system heterogeneity transparency regarding data layout distributed change support Suitable for identifying well-structured information ... a way to describe it object object oriented indirect attributive The combination of language and software tools for creating, maintaining and sharing a database by many users is ... DBMS information base data bank The operator with which you can revoke the privileges of a user or application is ... REVOKE GRANT UPDATE SELECT COMMIT ROLLBACK The statement ... must be included in the construction of the SELECT statement FROM GROUP BY WHERE ORDER BY HAVING CREATE INSERT A transaction is ... the totality of the operations of editing, adding and deleting records in the database, the process of creating and synchronizing copies of the database stored in different places the set of operations in the database, the execution of which cannot be interrupted the process of updating and synchronizing data and the relationships between them Based on the presentation of the image in a more compact form using the coefficients of a system of iterable functions ... data showcase DBMS fractal archiving distributed database A hierarchical data model is based ... using relationships and tables to represent domain data on the presentation of information in the form of a directed graph in which only one arc can enter each vertex on the presentation of information in the form of a directed graph in which at each vertex an arbitrary number of arcs can enter A named set of data that displays the state of objects and their relationships in the subject area is called ... information base DBMS data bank database According to the functions performed, DBMSs are divided into ... information and operational single-level and multi-level logical and physical open and closed In a relational database, a relationship can be implemented between two relationships ...  Many to many One to many "one to one" Many to one A unique identifier of an entity that uniquely distinguishes any instance of an entity from other instances of an entity of the same type can be ... combination of attributes combination of relationships and attributes combination of entities essence itself combination of bonds attribute The function, the result of which is the arithmetic mean of the set of values ​​stored in a specific field of the records selected by the query, is called ... COUNT SUM MIN Avg MAX To restore the database, the DBMS includes programs ... serialization transaction archiving syslogging record recovery control points rollback A key that identifies a group of records that have a specific common property is called ... composite primary the main secondary Replication is a process ... creation and synchronization of database copies stored in different places performing operations in a database that cannot be interrupted reorganization of data and the relationships between them editing, adding and deleting records in the database