Database answers Synergy MFPU (ALL TESTS)
Content: ответы на тест.pdf (311.45 KB)
Uploaded: 10.08.2022
Positive responses: 0
Negative responses: 0
Sold: 1
Refunds: 0
$2.79
Synergy answers to the "Database" test.
Tests with all answers for 90/100 points. The questions are listed below:
1. The set of functional characteristics of objects and features of information presentation (for example, in numerical or textual form) can be called ...
2. A domain-specific, integrated, time-bound and immutable dataset designed for decision support is...
3. Databases are divided into factographic, documentary, lexicographic ...
4. COUNT, MIN and MAX functions apply to ... fields
5. The operator that is used to add a row to a table is...
6. A set of language and software tools designed to create, maintain and share a database (DB) with many users is ...
7. The ... operator can be used in the construction of a SELECT statement
8. Data type is...
9. Ordered in accordance with the nature of the relationship, the set of data fields (elements) placed in memory in accordance with their type is ...
10. Under ... is understood as indivisible in terms of impact on the database
11. The NOT NULL constraint, which prohibits entering a null value into this column, can be set ... table column
12. The life cycle model, in which the transition to the next stage means the complete completion of work at the previous stage, is called ...
13. Data management commands include: ...
14. If a user attempts to delete a row from a parent table that is referenced by one or more rows in a child table, SQL provides a number of options, in particular with NO ACTION ...
15. A logically integrated data source for Decision Support Systems (DSS) and Executive Information Systems (EIS) is...
16. Tools that allow you to bring the same entities from different databases and applications to some common type are called ...
17. Searching for self-similar areas in an image and determining the parameters of affine transformations for them is
18. The operator that is used to add a row to a table is...
19. Triggers are a special SQL server tool used to ...
20. An attribute can be
21. A domain is a collection of ...
22. Recording data is...
23. The key field is ...
24. Hard refusal is called refusal ...
25. A transaction is...
26. According to the languages of communication, they distinguish ... DBMS
27. Functional dependency R.X->R.Y is called transitive if there is an attribute Z such that ...
28. The operator for defining database objects is ...
29. Operator ... is used to compare some value with a list of given values
The set of allowed values, from which the values of the corresponding attributes of a certain relation are taken, is ...
30. The fundamental principles for organizing data warehouses are ...
31. A subquery that returns a set of values. - this is ...
32. Referential integrity can be violated when performing the operation ...
33. When obtaining a relational schema from an ER diagram, for each multiple attribute,
34. The ... operator is used to search for a value within a certain range
35. A relation is in third normal form if and only if it is in second normal form and every non-key attribute...
36. The process of normalizing the relationship is ...
37. One of the main requirements for data banks, that users should be able to use the data in different ways, is called ...
38. DBMS, depending on the architecture, are divided into ...
39. The network data model is based on the representation of information ...
40. A model that displays information objects, their properties and relationships between them without specifying the methods of physical storage of information is called ...
41. A model that displays all the properties (attributes) of information objects of the base and the relationship between them, taking into account the way they are stored, is called ...
Tests with all answers for 90/100 points. The questions are listed below:
1. The set of functional characteristics of objects and features of information presentation (for example, in numerical or textual form) can be called ...
2. A domain-specific, integrated, time-bound and immutable dataset designed for decision support is...
3. Databases are divided into factographic, documentary, lexicographic ...
4. COUNT, MIN and MAX functions apply to ... fields
5. The operator that is used to add a row to a table is...
6. A set of language and software tools designed to create, maintain and share a database (DB) with many users is ...
7. The ... operator can be used in the construction of a SELECT statement
8. Data type is...
9. Ordered in accordance with the nature of the relationship, the set of data fields (elements) placed in memory in accordance with their type is ...
10. Under ... is understood as indivisible in terms of impact on the database
11. The NOT NULL constraint, which prohibits entering a null value into this column, can be set ... table column
12. The life cycle model, in which the transition to the next stage means the complete completion of work at the previous stage, is called ...
13. Data management commands include: ...
14. If a user attempts to delete a row from a parent table that is referenced by one or more rows in a child table, SQL provides a number of options, in particular with NO ACTION ...
15. A logically integrated data source for Decision Support Systems (DSS) and Executive Information Systems (EIS) is...
16. Tools that allow you to bring the same entities from different databases and applications to some common type are called ...
17. Searching for self-similar areas in an image and determining the parameters of affine transformations for them is
18. The operator that is used to add a row to a table is...
19. Triggers are a special SQL server tool used to ...
20. An attribute can be
21. A domain is a collection of ...
22. Recording data is...
23. The key field is ...
24. Hard refusal is called refusal ...
25. A transaction is...
26. According to the languages of communication, they distinguish ... DBMS
27. Functional dependency R.X->R.Y is called transitive if there is an attribute Z such that ...
28. The operator for defining database objects is ...
29. Operator ... is used to compare some value with a list of given values
The set of allowed values, from which the values of the corresponding attributes of a certain relation are taken, is ...
30. The fundamental principles for organizing data warehouses are ...
31. A subquery that returns a set of values. - this is ...
32. Referential integrity can be violated when performing the operation ...
33. When obtaining a relational schema from an ER diagram, for each multiple attribute,
34. The ... operator is used to search for a value within a certain range
35. A relation is in third normal form if and only if it is in second normal form and every non-key attribute...
36. The process of normalizing the relationship is ...
37. One of the main requirements for data banks, that users should be able to use the data in different ways, is called ...
38. DBMS, depending on the architecture, are divided into ...
39. The network data model is based on the representation of information ...
40. A model that displays information objects, their properties and relationships between them without specifying the methods of physical storage of information is called ...
41. A model that displays all the properties (attributes) of information objects of the base and the relationship between them, taking into account the way they are stored, is called ...
Answers to the test of the Synergy Database of the MOI/MIT (90/100 points).
Continuation:
42. The properties inherent in the "ideal" distributed database management system are the ability ...
43. A relation is in second normal form (we assume that the only key of the relation is the primary key) if and only if it is in first normal form and each ...
44. According to the topology of data storage, there are ... databases
45. The set of functional characteristics of objects and features of information presentation is ...
46. A relation containing a candidate key referenced by some foreign key is called ...
47. The information provided by data that has a factual nature is called ...
48. The key that uniquely identifies a record is called ...
49. The operator with which you can revoke the privileges of a user or application is ...
50. The operator ... must be included in the construction of the SELECT operator
51. On the representation of the image in a more compact form using the coefficients of the system of iterated functions, ...
52. The hierarchical data model is based on...
53. A named set of data that displays the state of objects and their relationships in the subject area under consideration is called ...
54. According to the functions performed, DBMS are divided into ...
55. In a relational database, a relationship can be implemented between two relations
56. A unique entity identifier that uniquely distinguishes any instance of an entity from other instances of an entity of the same type may be
57. The function, the result of which is the arithmetic mean of the set of values stored in a certain field of the records selected by the query, is called ...
58. To restore the database, the DBMS includes programs ...
59. A key that identifies a certain group of records that have a certain common property is called ...
60. The structure that determines the sequence of execution and the relationship of processes, actions and tasks performed throughout the life cycle is ...
61. For the first time, the requirement that the values of all attributes of a relation be atomic is introduced ...
62. It is not true that … are supported in data warehouses
63. In relation R, attribute Y is ... from attribute X if and only if each value of X corresponds to exactly one value of Y
64. Responsible for targeted data processing and organization of user interaction ... part of the application, built on the basis of the client-server architecture
65. Information resources ... are formed on the basis of snapshots of databases of the operational information system recorded over a long period of time and, possibly, various external sources
66. Information technology of integrated data storage and processing - ...
67. A database is...
68. The data manipulation operator is the operator ...
69. A unit of actions performed with a database, which may include several database change statements, but either all of these statements are executed, or none is executed, is ...
70. It is not true that ... the key can be completely or partially empty, i.e. be null
71. A model that is a means of a formalized representation of the subject area of systems and is focused on the processing of factual information,
72. The property of a distributed database management system, which consists in the fact that the RDBMS must work with data that is stored in systems with different architecture and performance, is ...
73. To identify well-structured information, ... the way to describe it is suitable
74. A set of language and software tools designed to create, maintain and share a database with many users is ...
75. Replication is a process...
76. A column or subset of one table that can serve as a primary key for another table is ... a key
77. A table is ...
Continuation:
42. The properties inherent in the "ideal" distributed database management system are the ability ...
43. A relation is in second normal form (we assume that the only key of the relation is the primary key) if and only if it is in first normal form and each ...
44. According to the topology of data storage, there are ... databases
45. The set of functional characteristics of objects and features of information presentation is ...
46. A relation containing a candidate key referenced by some foreign key is called ...
47. The information provided by data that has a factual nature is called ...
48. The key that uniquely identifies a record is called ...
49. The operator with which you can revoke the privileges of a user or application is ...
50. The operator ... must be included in the construction of the SELECT operator
51. On the representation of the image in a more compact form using the coefficients of the system of iterated functions, ...
52. The hierarchical data model is based on...
53. A named set of data that displays the state of objects and their relationships in the subject area under consideration is called ...
54. According to the functions performed, DBMS are divided into ...
55. In a relational database, a relationship can be implemented between two relations
56. A unique entity identifier that uniquely distinguishes any instance of an entity from other instances of an entity of the same type may be
57. The function, the result of which is the arithmetic mean of the set of values stored in a certain field of the records selected by the query, is called ...
58. To restore the database, the DBMS includes programs ...
59. A key that identifies a certain group of records that have a certain common property is called ...
60. The structure that determines the sequence of execution and the relationship of processes, actions and tasks performed throughout the life cycle is ...
61. For the first time, the requirement that the values of all attributes of a relation be atomic is introduced ...
62. It is not true that … are supported in data warehouses
63. In relation R, attribute Y is ... from attribute X if and only if each value of X corresponds to exactly one value of Y
64. Responsible for targeted data processing and organization of user interaction ... part of the application, built on the basis of the client-server architecture
65. Information resources ... are formed on the basis of snapshots of databases of the operational information system recorded over a long period of time and, possibly, various external sources
66. Information technology of integrated data storage and processing - ...
67. A database is...
68. The data manipulation operator is the operator ...
69. A unit of actions performed with a database, which may include several database change statements, but either all of these statements are executed, or none is executed, is ...
70. It is not true that ... the key can be completely or partially empty, i.e. be null
71. A model that is a means of a formalized representation of the subject area of systems and is focused on the processing of factual information,
72. The property of a distributed database management system, which consists in the fact that the RDBMS must work with data that is stored in systems with different architecture and performance, is ...
73. To identify well-structured information, ... the way to describe it is suitable
74. A set of language and software tools designed to create, maintain and share a database with many users is ...
75. Replication is a process...
76. A column or subset of one table that can serve as a primary key for another table is ... a key
77. A table is ...
No feedback yet