Databases (Synergy Answers)
Sold 2
Refunds 0
Good feedbacks 0
Bad feedbacks 0
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
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
A column or subset of one table that can serve as the primary key for another table is ... a key
composite
alternative
secondary
external
The structure that determines the sequence of implementation and the relationship of processes, actions and tasks performed throughout the life cycle is ...
database model
data model
Information system
life cycle model
For the first time, the requirement that the values of all attributes of a relation be atomic is introduced ...
in the second
in the first
in the third
in the fourth
It is not true that ... are supported in data warehouses
online row inserts
bulk upload operations
online column value changes
data modification operations
With respect to R, attribute Y is ... from attribute X if and only if each value of X corresponds to exactly one value of Y
in functional dependence
in transitive functional dependency
fully functional
in transitive functional independence
“Hard rejection" refers to rejection ...
the system
Db
the network
carrier
A domain is a collection ...
elements of different types in the table
values of elements of the same type that meet the conditions
related data items that meet specified conditions
stored data attributes
Responsible for the targeted data processing and the organization of user interaction ... the server part of the application built on the basis of the client-server architecture
technical
interface
client
Information resources ... are formed on the basis of snapshots of databases of the operational information system and, possibly, various external sources, recorded over a long period of time
data bank
Database
knowledge base
data storage
Information technology integrated storage and data processing - ...
table editors
archives
Database
text editors
The data manipulation operator is the operator ...
Drop
Table
UPDATE
SELECT
GRANT
REVOKE
CREATE
SCHEMA
composite
alternative
secondary
external
The structure that determines the sequence of implementation and the relationship of processes, actions and tasks performed throughout the life cycle is ...
database model
data model
Information system
life cycle model
For the first time, the requirement that the values of all attributes of a relation be atomic is introduced ...
in the second
in the first
in the third
in the fourth
It is not true that ... are supported in data warehouses
online row inserts
bulk upload operations
online column value changes
data modification operations
With respect to R, attribute Y is ... from attribute X if and only if each value of X corresponds to exactly one value of Y
in functional dependence
in transitive functional dependency
fully functional
in transitive functional independence
“Hard rejection" refers to rejection ...
the system
Db
the network
carrier
A domain is a collection ...
elements of different types in the table
values of elements of the same type that meet the conditions
related data items that meet specified conditions
stored data attributes
Responsible for the targeted data processing and the organization of user interaction ... the server part of the application built on the basis of the client-server architecture
technical
interface
client
Information resources ... are formed on the basis of snapshots of databases of the operational information system and, possibly, various external sources, recorded over a long period of time
data bank
Database
knowledge base
data storage
Information technology integrated storage and data processing - ...
table editors
archives
Database
text editors
The data manipulation operator is the operator ...
Drop
Table
UPDATE
SELECT
GRANT
REVOKE
CREATE
SCHEMA