Correct statement to insert data
In what science information is- the content of the electrochemical nature of the signals transmitted along nerve fibers of the body
a) Neurophysiology
Property of information that is provided due to its transformation into an understandable form-
a) Adequacy
Low level DBMS functions
a) Simple data base scripts, which can be generated manually(e.g. read value from table, update element,etc.)
For the Relational Database Management Systems Edgar Frank Codd suggested and substantiated rule
a) System administrator
The key field is
a) This field whose value uniquely identifies a record in the table
Restriction on data stored in database tables is determined by
a) Constraints
Foreign key
a) A field (or collection of fields) in one table that uniquely identifies a row of another table
8. Architecture “File-Server” characterized by
a) Increase the level of data security
DCL stands for
a) Data Control Language
TCL stands for
a) Transactional Control Language
SQL instructions, performing cursor control
a) OPEN CURSOR
Low level functions DBMS
a) Data management in external memory
Command to change Database name
a) Alter database
Command to delete Database
a) Drop database
Command, that allows the user to manage the transaction of database
a) ROLLBACK
Operator SELECT FROM defines
a) SELECT a list of fields FROM the list of a table
Data type that is used for symbols
a) String
Operator of SQL lets us to delete current row from the table
a) Delete from A where A5=”Almaty”
Which is correct definition for Cluster
a) The steps of conceptual programming
Primary keys are usually used for
a) The organization of relating the tables
Author of Database relational model theory
a) Edgar F.Codd
Allows different applications and databases work together clear and consistent manner
a) Open Database Connectivity (Open Database Connectivity)
The most precise analogue of a relational database can be
a) Two-dimensional table
The structure of a relational database (DB) is completely determined by
a) A list of field names and an indication of the number of database records
TCL( Transactional Control Language) includes next commands
a) Commit, rollback
DCL(Data Control Language) includes next commands
a) Grant, revoke
27. What is the “the planned query” (a predefined query)
a) A query that must perform optimally
Which of the following is not included in the DBA function
a) assessment of prospects and the formation of the requirements based on the features of the software
29. The object generating the information and presenting it in the form of a message –it
a) Source of information
30. Universal device for automated execution of information processes-
a) Generator
24. The structure of a relational database (DB) is completely determined by
a) A list of field names and indication of the number of database records
Which of the following is not included in the DBA function
a) Assessment of the prospects and the formation of the requirements based on the features of the software
DBA is a person who
a) Directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use database management system
DBMS is divided into
a) Centralized and distributed
Database record is
a) The smallest unit of information in a database
Database field is-
a) Column of the table containing the values of certain properties
Record I-M means
a) one -to-many relation
8. Record 1:1 means
a) One row in the main table corresponds to one row in a secondary table
DDL standsfor
a) DataDefinitionLanguage
DML standsfor
a) DataManipulationLanguage
Conceptual level -
a) Generalizing the idea database. This level describes what data is stored in the database and the connections between them
External level-
a) Presentation of data from a user perspective. This level describes user part of the database , part that applies to each device
Correct statement to insert data
a) INSERT INTO ‘my_table’ (‘id, ‘name’ ) VALUE (1, ‘ FirstName’)