Databases - synergy test (answers)
Replenishment date:
Sales:
2
Refunds:
0
Reviews:
0
Views:
311
This item has run out. Check back later or try searching other sellers
Description
Synergy Discipline Answers - Databases
This collection contains 79 answers
Minimum rating from "Good"
1. A "hard refusal" is a refusal ...
2. The attribute can be ...
3. Databases are divided into factual, documentary, lexicographic by ...
4. If the user attempts to delete a row from the parent table that is referenced by one or more rows of the child table, SQL provides a number of possibilities, in particular, using NO ACTION ...
5. In relation to R, the Y attribute is ... from the X attribute if and only if each X value corresponds to exactly one Y value
6. In a relational database, a relationship can be implemented between two relationships ...
7. For the first time, the requirement that the values of all attributes of a relation be atomic is introduced ...
8. To restore the database, the DBMS includes programs ...
9. For the identification of well-structured information, ... the way of describing it is suitable
10. A domain is a collection ...
11. A unit of actions performed with a database, which may include several operators for changing the database, but either all of these operators are executed, or none of them is executed, is ...
12. Responsible for the targeted data processing and the organization of interaction with the user ... the server part of the application built on the basis of the "client-server" architecture
13. Data recording is ...
14. The hierarchical data model is based ...
15. A named collection of data that reflects the state of objects and their relationships in the considered subject area is called ...
16. Information technology for integrated storage and processing of data - ...
17. Information resources ... are formed on the basis of snapshots of the databases of the operational information system and, possibly, various external sources, recorded over a long period of time
18. The information represented by data of a factual nature is called ...
19. Data management commands include: ...
20. The key that identifies a certain group of records that have a certain common property is called ...
21. The key that uniquely identifies the record is called ...
22. The key field is ...
23. A logically integrated data source for Decision Support Systems (DSS) and Executive Information Systems (EIS) is ...
24. The life cycle model, in which the life time of each of the stages is stretched over the entire development period and the development is carried out in iterations with feedback loops between the stages, is called
25. The life cycle model, in which the transition to the next stage means the complete completion of the work at the previous stage, is called ...
26. 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 ...
27. 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 ...
28. A model that displays information objects, their properties and connections between them without specifying methods of physical storage of information is called ...
29. On the representation of the image in a more compact form using the coefficients of the system of iterated functions is based ...
30. It is not true that ... the key can be completely or partially empty, ie. be null
31. It is not true that ... are supported in data warehouses
32. The NOT NULL constraint, which prohibits entering a null value in this column, can be set ...
33. One of the main requirements for databanks that users should be able to use data in different ways is called ...
34. One of the main requirements for data banks, which is that. that users should be able to easily find out and understand what data is at their disposal is called ...
35. One of the main requirements for data banks, which is that access to data or their search should be carried out
This collection contains 79 answers
Minimum rating from "Good"
1. A "hard refusal" is a refusal ...
2. The attribute can be ...
3. Databases are divided into factual, documentary, lexicographic by ...
4. If the user attempts to delete a row from the parent table that is referenced by one or more rows of the child table, SQL provides a number of possibilities, in particular, using NO ACTION ...
5. In relation to R, the Y attribute is ... from the X attribute if and only if each X value corresponds to exactly one Y value
6. In a relational database, a relationship can be implemented between two relationships ...
7. For the first time, the requirement that the values of all attributes of a relation be atomic is introduced ...
8. To restore the database, the DBMS includes programs ...
9. For the identification of well-structured information, ... the way of describing it is suitable
10. A domain is a collection ...
11. A unit of actions performed with a database, which may include several operators for changing the database, but either all of these operators are executed, or none of them is executed, is ...
12. Responsible for the targeted data processing and the organization of interaction with the user ... the server part of the application built on the basis of the "client-server" architecture
13. Data recording is ...
14. The hierarchical data model is based ...
15. A named collection of data that reflects the state of objects and their relationships in the considered subject area is called ...
16. Information technology for integrated storage and processing of data - ...
17. Information resources ... are formed on the basis of snapshots of the databases of the operational information system and, possibly, various external sources, recorded over a long period of time
18. The information represented by data of a factual nature is called ...
19. Data management commands include: ...
20. The key that identifies a certain group of records that have a certain common property is called ...
21. The key that uniquely identifies the record is called ...
22. The key field is ...
23. A logically integrated data source for Decision Support Systems (DSS) and Executive Information Systems (EIS) is ...
24. The life cycle model, in which the life time of each of the stages is stretched over the entire development period and the development is carried out in iterations with feedback loops between the stages, is called
25. The life cycle model, in which the transition to the next stage means the complete completion of the work at the previous stage, is called ...
26. 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 ...
27. 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 ...
28. A model that displays information objects, their properties and connections between them without specifying methods of physical storage of information is called ...
29. On the representation of the image in a more compact form using the coefficients of the system of iterated functions is based ...
30. It is not true that ... the key can be completely or partially empty, ie. be null
31. It is not true that ... are supported in data warehouses
32. The NOT NULL constraint, which prohibits entering a null value in this column, can be set ...
33. One of the main requirements for databanks that users should be able to use data in different ways is called ...
34. One of the main requirements for data banks, which is that. that users should be able to easily find out and understand what data is at their disposal is called ...
35. One of the main requirements for data banks, which is that access to data or their search should be carried out
Additional Information
36. Operator ... is used to compare some value with a list of given values37. Operator ... filters the object row groups according to the specified condition
38. Operator ... is used to search for a value within a certain range
39. Operator ... is used to search for a value within a certain interval determined by its minimum and maximum values
40. The operator ... is necessarily included in the construction of the SELECT operator
41. The operator of data manipulation is the operator ...
42. The operator of data manipulation is the operator ...
43. The operator of the definition of database objects is ...
44. The operator used to add a row to the table is ...
45. The operator through which you can revoke the privileges of a user or application is ...
46. The principles underlying the organization of warehouses are ...
47. A failure that affects all currently running transactions, but does not violate the physical state of the database is called a failure ...
48. A relation is in third normal form if and only if it is in second normal form and each non-key attribute ...
49. A relation is in the second normal form (we assume that the only key of the relation is the primary key) if and only if it is in the first normal form and each ...
50. A relationship containing a potential key referenced by some foreign key is called ...
51. According to the functions performed, the DBMS are divided into
52. According to the topology of data storage, there are ... databases
53. According to the languages of communication, they distinguish ... DBMS
54. Under ... is understood a sequence of data manipulation operators that is indivisible from the point of view of impact on the database, leading to one of two possible results: either the sequence is executed, or the entire transaction is rolled back
55. A subquery that returns a set of values. - this is ...
56. The search for self-similar regions in the image and the determination of the parameters of affine transformations for them is
57. A subject-oriented, integrated, time-bound and immutable dataset for decision support is ...
58. When passing to the next normal form, the properties of the previous normal forms ...
59. When obtaining a relational schema from an ER diagram, for each multiple attribute, a ...
60. The process of normalizing attitudes is ...
61. The relational data model ...
62. Replication is a process ...
63. The properties inherent in the "ideal" distributed database management system are the ability ...
64. The property of a distributed database management system that the RDBMS must work with data that is stored in systems with different architectures and performance is ...
65. The network data model is based on presentation of information ...
66. The set of admissible values from which the values of the corresponding attributes of a certain relation are taken is ...
67. The set of functional characteristics of objects and features of information presentation is ...
68. The set of language and software tools designed for the creation, maintenance and sharing of databases by many users is ...
69. Means that allow the same entities from different databases and applications to be reduced to a certain general type are called ...
70. Referential integrity can be violated when performing an operation ...
71. A column or subset of one table that can serve as a primary key for another table is ... a key
72. The structure that determines the sequence of execution and the relationship of processes, actions and tasks performed throughout the life cycle is ...
73. DBMS, depending on architecture, are divided into ...
74. The table is ...
75. A transaction is ...
76. Triggers are a special SQL server tool used to ...
77. The unique identifier of the entity that uniquely distinguishes any instance