Вопрос №57
V1
|
In the Microsoft Access database, such field types are allowed to be used:
|
1
|
Logical, date, numeric, monetary, OLE
|
0
|
Numeric, character, graphic, array
|
0
|
Table, form, query
|
0
|
Numeric, text, protected
|
0
|
Images, audio, text
|
Вопрос №58
V1
|
The parameters of database entities are determined at the stage of database ____ .
|
1
|
Design
|
0
|
Opening
|
0
|
Testing
|
0
|
Operation
|
0
|
Modification
|
Вопрос №59
V1
|
In a database table, each separate collection of data (characterized by some common parameters) , such as last name, first name, or address, is called a ___________ of a table.
|
0
|
File
|
1
|
Field
|
0
|
Record
|
0
|
Table
|
0
|
Name
|
Вопрос №60
V1
|
A database, the basis of the data structure of which is a table, each row of which contains a set of properties of one of the objects of the domain, and each column is a set of values of a certain property of the objects of the domain.
|
0
|
Addressable
|
0
|
Hierarchical
|
0
|
Network
|
1
|
Relational
|
0
|
Tabular
|
Вопрос №61
V1
|
In general terms, primary key in a database is _____.
|
0
|
Field that has not a unique value for each record
|
1
|
Field that has a unique value for each record
|
0
|
Code that allows the user to open the database
|
0
|
Code that allows one database to connect to another
|
0
|
None of the above
|
Вопрос №62
V1
|
SQL term stands for ___.
|
0
|
Structured question language
|
1
|
Structured query language
|
0
|
System query language
|
0
|
Structured query location
|
0
|
System for query location
|
0
|
System with query listings
|
0
|
Structured question listing
|
0
|
Structured query limitation
|
Вопрос №63
V1
|
Which of the following is NOT a part of a common database?
|
0
|
Tables
|
0
|
Records
|
0
|
Fields
|
1
|
Worksheets
|
0
|
Queries
|
Вопрос №64
V1
|
The relational database table record contains ___ .
|
0
|
Links to file storage addresses
|
1
|
Data (concrete) about one of the characteristics of the object
|
0
|
Description (name) characteristics of the object
|
0
|
Description of Stored Data
|
0
|
Data (common) about several of the characteristics of the two or more objects
|
Вопрос №65
V1
|
In Microsoft Access, there is NO query for _________ data.
|
1
|
Download
|
0
|
Update
|
0
|
Delete
|
0
|
Adding
|
0
|
Search
|
Вопрос №66
V1
|
In order to get data from several tables at once (within a database), you first need to create ____ .
|
1
|
Relationship between tables
|
0
|
One common table in which there will be data from the required tables
|
0
|
Separate database
|
0
|
Database button-form
|
0
|
New database file
|
Вопрос №67
V1
|
The feature of the “Counter” field in Microsoft Access is that
|
1
|
it has the property of auto fill in
|
0
|
the data is not stored in the field itself, but in another place, but only the pointer is stored in the field
|
0
|
the maximum size of the number stored in it cannot exceed 255
|
0
|
it is intended to fill in with integers data
|
0
|
it is intended to fill in with hyper-links data
|
0
|
it is intended to fill in with monetary data
|
Вопрос №68
V1
|
Each column of the relational table must have a unique name within ____ .
|
0
|
Next query set
|
0
|
Following worksheet list
|
0
|
Query
|
1
|
Current table
|
0
|
File system
|
0
|
Current database
|
0
|
Database management systems
|
0
|
Current file
|
Вопрос №69
V1
|
The basic SQL tool for searching and modifying information in databases.
|
0
|
Table fields
|
0
|
Reports
|
1
|
Queries
|
0
|
Data structure
|
0
|
Table primary keys
|
Вопрос №70
V1
|
To uniquely identify a particular record in relational databases ____ is used.
|
0
|
Unique tuple number
|
0
|
Table column name
|
1
|
Table primary key
|
0
|
Database key
|
0
|
Record counter number
|
0
|
Record field type
|
Вопрос №71
V1
|
In Microsoft Excel formulas, to raise a number to a power (for example, the number 2 to 5 power) uses the syntax:
|
0
|
=2>>5
|
0
|
=2@5
|
1
|
=2^5
|
0
|
=2(5)
|
0
|
=2“5”
|
0
|
=2**5
|
0
|
=2#5#
|
0
|
=2!5
|
Вопрос №72
V1
|
The user needs to create an arithmetic progression in the Microsoft Excel line within the [0: 150 000] with steps of 200. To do this, it is recommended to use (shortest method):
|
0
|
Function "Build" and specify the boundaries of the range
|
0
|
Function "Create progression", specify the boundaries and line
|
0
|
With the function "New progression" select "Arithmetic" and indicate the step
|
1
|
Function "Fill" select "progression" indicate the boundaries and step
|
0
|
Function "Progression" and select the desired cells of the range
|
Вопрос №73
V1
|
Consecutive cells of the Excel table column: “Monday”, “Tuesday”, “Thursday”. The last two cell is active. The mouse points to the lower right corner of the list cell, while the plus sign is visible below the right corner of the cell. What happens if you “stretch” the mouse a couple of cells down?
|
1
|
The next two cells of the column will be filled with the continuation of the list: “Saturday”, “Monday”, etc.
|
0
|
The next two cells will be formatted in the same way as the last cell in the list, and their contents will remain empty.
|
0
|
The next two cells of the column will be filled with the continuation of the list: “Friday”, “Saturday”, etc.
|
0
|
The following two cells will be filled with the text: “Tuesday”, “Thursday”
|
0
|
Cells will remain empty and error message will appear
|
Вопрос №74
V1
|
All calculations in Microsoft Excel using formulas and functions always begin with the __ sign.
|
0
|
≡
|
0
|
!
|
1
|
=
|
0
|
#
|
0
|
@
|
Вопрос №75
V1
|
In order to automatically (without accessing any menu) change the width of the column in accordance with the maximum length of the data stored in the cells of this column:
|
0
|
Enable the "automatic width adjustment" parameter in the worksheet settings
|
0
|
When you finish entering data into the cells, press the key combination “Alt” + ”Enter”
|
1
|
Double-click the left mouse button on the border between the columns (with the corresponding mouse indicator)
|
0
|
Double-click the right mouse button and select "Auto Width" (with the corresponding mouse indicator)
|
0
|
Select two rows, double-click the right mouse button and select "Auto Width" (with the corresponding mouse indicator)
|
|
Скачать 111.26 Kb.