Вопрос №55

The tables of the relational database (DB) may contain:

Extremely homogeneous information (only one type of data)

Text only

Heterogeneous information (different types of data)

Only logical quantities

Neither of above

Вопрос №56

Creating, configuring and working with databases is carried out by ____ .

Database utilities

Database managers

Database operating systems

Database management systems

Database file containers

External management systems

Database initial setup managers

Вопрос №57

In the Microsoft Access database, such field types are allowed to be used:

Logical, date, numeric, monetary, OLE

Numeric, character, graphic, array

Table, form, query

Numeric, text, protected

Images, audio, text

Вопрос №58

The parameters of database entities are determined at the stage of database ____ .

Design

Opening

Testing

Operation

Modification

Вопрос №59

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.

File

Field

Record

Table

Name

Вопрос №60

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.

Addressable

Hierarchical

Network

Relational

Tabular

Вопрос №61

In general terms, primary key in a database is _____.

Field that has not a unique value for each record

Field that has a unique value for each record

Code that allows the user to open the database

Code that allows one database to connect to another

None of the above

---

Вопрос №62

SQL term stands for ___.

Structured question language

Structured query language

System query language

Structured query location

System for query location

System with query listings

Structured question listing

Structured query limitation

Вопрос №63

Which of the following is NOT a part of a common database?

Tables

Records

Fields

Worksheets

Queries

Вопрос №64

The relational database table record contains ___ .

Links to file storage addresses

Data (concrete) about one of the characteristics of the object

Description (name) characteristics of the object

Description of Stored Data

Data (common) about several of the characteristics of the two or more objects

Вопрос №65

In Microsoft Access, there is NO query for _________ data.

Download

Update

Delete

Adding

Search

Вопрос №66

In order to get data from several tables at once (within a database), you first need to create ____ .

Relationship between tables

One common table in which there will be data from the required tables

Separate database

Database button-form

New database file

Вопрос №67

The feature of the “Counter” field in Microsoft Access is that

it has the property of auto fill in

the data is not stored in the field itself, but in another place, but only the pointer is stored in the field

the maximum size of the number stored in it cannot exceed 255

it is intended to fill in with integers data

it is intended to fill in with hyper-links data

it is intended to fill in with monetary data

Вопрос №

---

68

Each column of the relational table must have a unique name within ____ .

Next query set

Following worksheet list

Query

Current table

File system

Current database

Database management systems

Current file

Вопрос №69

The basic SQL tool for searching and modifying information in databases.

Table fields

Reports

Queries

Data structure

Table primary keys

Вопрос №70

To uniquely identify a particular record in relational databases ____ is used.

Unique tuple number

Table column name

Table primary key

Database key

Record counter number

Record field type

Вопрос №71

In Microsoft Excel formulas, to raise a number to a power (for example, the number 2 to 5 power) uses the syntax:

=2>>5

=2@5

=2^5

=2(5)

=2“5”

=2**5

=2#5#

=2!5

Вопрос №72

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):

Function "Build" and specify the boundaries of the range

Function "Create progression", specify the boundaries and line

With the function "New progression" select "Arithmetic" and indicate the step

Function "Fill" select "progression" indicate the boundaries and step

Function "Progression" and select the desired cells of the range

Вопрос №73

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?

The next two cells of the column will be filled with the continuation of the list: “Saturday”, “Monday”, etc.

The next two cells will be formatted in the same way as the last cell in the list, and their contents will remain empty.

The next two cells of the column will be filled with the continuation of the list: “Friday”, “Saturday”, etc.

The following two cells will be filled with the text: “Tuesday”, “Thursday”

Cells will remain empty and error message will appear

---

---

Вопрос №74

All calculations in Microsoft Excel using formulas and functions always begin with the __ sign.

≡

!

=

#

@

Вопрос №75

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:

Enable the "automatic width adjustment" parameter in the worksheet settings

When you finish entering data into the cells, press the key combination “Alt” + ”Enter”

Double-click the left mouse button on the border between the columns (with the corresponding mouse indicator)

Double-click the right mouse button and select "Auto Width" (with the corresponding mouse indicator)

Select two rows, double-click the right mouse button and select "Auto Width" (with the corresponding mouse indicator)

Вопрос №76

The user needs to, when entering numeric values into the cells, they are perceived and used in the formulas as percentage data. To do this, it is necessary to modify____.

Column format

Row format

Spreedsheat format

Cell format

Table format

Workbook settings

File settings

Вопрос №77

To select several cells or ranges that are not touching each other, you would _____ while selecting

Hold down the c key

Hold down the CTRL key

Hold down the SHIFT key

Hold down the ALT key

Hold down the ENTER key

Hold down the CTRL+TAB key

Hold down the ALT+CTRL key

Hold down the SHIFT +CTRL key

Вопрос №78

In order to change the type of a line on a chart added to the spreadsheet:

Select the chart and select “Rebuild” in the context menu

Delete the chart and rebuild it with the necessary changes

Select a line and change its parameters by going to the “View panel”

Select a line and select "Change chart type" in the context menu

Delete the spreadsheet and rebuild it with the necessary changes

Вопрос №79

The development of ICT technologies have a huge impact on:

Medicine

Programming

Business

All of the above

Industrial engineering

---

Смотрите также файлы

• Нижегородский Государственный Технический Университет Кафедра Информационных Радиосистем пояснительная записка.doc

• Задание 1 Рационализм это направление в философии, согласно которому основой как бытия, так и познания является разум. Эмпиризм.docx

• Анализ схемотехники пересчетного устройства.docx

• Виды, формы и организация контроля качества обучения. Понятие контроля. Функции контроля. Требования к контролю.docx

• Мшелер жне мшелер жйесі.docx