Database test
Replenishment date: 30.01.2019
Content: Final test by discipline.doc (91 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
1
Refunds:
0
Reviews:
0
Description
Final test in the discipline "Databases"
1.The database is:
a) a defined set of information;
b) a set of data organized according to certain rules;
c) an interface that supports filling and manipulating data;
d) a set of programs for storing and processing large amounts of information.
2. The most accurate analogue of a relational database can be:
a) family tree;
b) two-dimensional table;
c) unordered data set;
d) vector.
3. Which of the following is not an MS Access Object?
a) inquiries;
b) reports;
c) macros;
d) forms;
e) tables;
f) modules;
g) keys.
4.What are forms for?
a) to perform complex program activities;
b) for selection and processing of database data;
c) to automatically execute a group of commands;
d) for storing database data;
e) to enter database data and view them.
5.What are macros for?
a) to enter database data and view them;
b) to automatically execute a group of commands;
c) for storing database data;
d) for selection and processing of database data;
e) to perform complex program actions.
6.In which dialog box the links between the fields of the database tables are created:
a) connection diagram;
b) link table;
c) data schema;
d) data table.
7.Without what objects the database cannot exist:
a) without macros;
b) without tables;
c) without requests;
d) without forms;
e) no reports;
f) without modules.
8. Does the table contain any information, in which there are no records?
a) an empty table contains information about future entries;
b) the table cannot exist without records;
c) an empty table contains information about the structure of the database;
d) an empty table does not contain any information.
9. What is the peculiarity of the "counter" field?
a) the data is not stored in the field, but in another place, and the field only stores a pointer to where the text is located;
b) has the property of automatic build-up;
c) serves to enter real numbers;
d) serves to enter numerical data;
e) is of limited size.
10. What field can be considered unique?
a) a field in which values cannot be repeated;
b) the field, the value of which has the property of extension;
c) a field that has a unique name.
11. Database management systems (DBMS) are used to process:
a) knowledge;
b) data;
c) text;
d) possible solution alternatives.
12. Is it a factual database?
a) a database that contains brief information about the described objects, presented in a strictly defined format;
b) a database that contains extensive information of various types: text, graphics, sound, multimedia;
c) a database that contains information of a specific focus.
13. What query exists in the constructor?
a) sample request
b) sort request
c) request for a report
d) - options a, b
14. What groups is the database management system divided into?
a) local and global
b) global and network
c) local and network
d) all options are correct
15. What is an Information Object?
a) a set of pointers to an object
b) informational description of the real object
c) a unique key to a specific object
d) no answer option
16. What is the smallest unit of data storage in the database?
a) stored file;
b) stored byte;
c) stored field;
d) the stored record;
e) none of the above.
17. What data model prevails in the real world?
a) relational;
b) hierarchical;
c) network;
d) structural.
18. Objects that allow you to get the necessary information from one or more related tables:
a) forms;
b) inquiries;
c) macro;
d) reports.
19.What is SQL:
a) database markup language;
b) structured query language;
c) low-level programming language;
d) high-level programming language.
20. Which of the following is not an MS Access object:
a) table;
b) book;
c) request;
d) macr
1.The database is:
a) a defined set of information;
b) a set of data organized according to certain rules;
c) an interface that supports filling and manipulating data;
d) a set of programs for storing and processing large amounts of information.
2. The most accurate analogue of a relational database can be:
a) family tree;
b) two-dimensional table;
c) unordered data set;
d) vector.
3. Which of the following is not an MS Access Object?
a) inquiries;
b) reports;
c) macros;
d) forms;
e) tables;
f) modules;
g) keys.
4.What are forms for?
a) to perform complex program activities;
b) for selection and processing of database data;
c) to automatically execute a group of commands;
d) for storing database data;
e) to enter database data and view them.
5.What are macros for?
a) to enter database data and view them;
b) to automatically execute a group of commands;
c) for storing database data;
d) for selection and processing of database data;
e) to perform complex program actions.
6.In which dialog box the links between the fields of the database tables are created:
a) connection diagram;
b) link table;
c) data schema;
d) data table.
7.Without what objects the database cannot exist:
a) without macros;
b) without tables;
c) without requests;
d) without forms;
e) no reports;
f) without modules.
8. Does the table contain any information, in which there are no records?
a) an empty table contains information about future entries;
b) the table cannot exist without records;
c) an empty table contains information about the structure of the database;
d) an empty table does not contain any information.
9. What is the peculiarity of the "counter" field?
a) the data is not stored in the field, but in another place, and the field only stores a pointer to where the text is located;
b) has the property of automatic build-up;
c) serves to enter real numbers;
d) serves to enter numerical data;
e) is of limited size.
10. What field can be considered unique?
a) a field in which values cannot be repeated;
b) the field, the value of which has the property of extension;
c) a field that has a unique name.
11. Database management systems (DBMS) are used to process:
a) knowledge;
b) data;
c) text;
d) possible solution alternatives.
12. Is it a factual database?
a) a database that contains brief information about the described objects, presented in a strictly defined format;
b) a database that contains extensive information of various types: text, graphics, sound, multimedia;
c) a database that contains information of a specific focus.
13. What query exists in the constructor?
a) sample request
b) sort request
c) request for a report
d) - options a, b
14. What groups is the database management system divided into?
a) local and global
b) global and network
c) local and network
d) all options are correct
15. What is an Information Object?
a) a set of pointers to an object
b) informational description of the real object
c) a unique key to a specific object
d) no answer option
16. What is the smallest unit of data storage in the database?
a) stored file;
b) stored byte;
c) stored field;
d) the stored record;
e) none of the above.
17. What data model prevails in the real world?
a) relational;
b) hierarchical;
c) network;
d) structural.
18. Objects that allow you to get the necessary information from one or more related tables:
a) forms;
b) inquiries;
c) macro;
d) reports.
19.What is SQL:
a) database markup language;
b) structured query language;
c) low-level programming language;
d) high-level programming language.
20. Which of the following is not an MS Access object:
a) table;
b) book;
c) request;
d) macr