Russian exam in Russian test 4. Preparation for the exam in mathematics (profile level): tasks, solutions and explanations

In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

locked

Explanation (see also Rule below).

Let's place the stress correctly:

locked

We see an error in the word "locked", it is correct to say locked. In response, write out the word without correcting it.

Answer: locked.

How not to lose point for this task?

The editorial board receives dozens of questions about this task, which was met in the 2015 Unified State Exam. It was proposed in the specified wording. Anyone who does not read the task carefully will lose points. In response, you need to enter the word in which the mistake was made. There is no need to fix this error. Therefore, in response, you must write down the word locked. In the USE forms there is the letter E, it must be used. If you write locked, the task will not be credited to you.

Answer: locked

Source: Unified State Exam - 2015. Early wave

Rule: Staging stress. Task 4.

ORPHOEPIC STANDARDS (stress setting) are checked in task 4.

Students are required to write out one of four words in which the stress is incorrectly highlighted - the stressed vowel is indicated by a capital letter. In the answer, the word is entered without changes, without emphasis in capital letters. Pay attention to the letter Ё: if the misspelled word contained this letter, it must be written in the answer as well. For example, from four words:

locked

the first has misplaced stress. We write out this word in response without changing, with the letter E. We draw your attention to the fact that the question of the possible spelling of E instead of E is solved simply: in front of each examinee on the exam there will be a form in which ALL allowed letters and signs are indicated. At the moment, the letter E is in the sample forms.

For training in the skill of staging the stress, RESHUEGE offers both words from the Orthoepic minimum of FIPI (2016), and words that have not entered or left it.

In tasks with an increased level of difficulty, along with words with clearly erroneous stress, words with two variants of stress are included.

FIPI Spelling Dictionary 2016

An important aspect of orthoepy is stress, that is, the sound selection of one of the syllables of a word. The stress on the letter is usually not indicated, although in some cases (when teaching Russian to non-Russians) it is customary to put it.

Distinctive features of the Russian stress are its diversity and mobility. The diversity lies in the fact that the stress in Russian can be on any syllable of the word (book, signature - on the first syllable; lantern, underground - on the second; hurricane, orthoepy - on the third, etc.) etc.). In some words, the stress is fixed on a certain syllable and does not move when grammatical forms are formed, in others it changes its place (compare: TONNA - TONNES and WALL - WALL - WALLS and WALLS). The last example demonstrates the fluidity of the Russian stress. This is the objective difficulty of assimilating accent norms. “However, - as KS rightly notes. Gorbachevich, - if the diversity and mobility of the Russian stress creates some difficulties in its assimilation, then these inconveniences are completely atoned for by the opportunity to distinguish the meaning of words with the help of the place of stress (flour is flour, tricky is cowardly, immersed on a platform - immersed in water) and even functional and stylistic fixation of accent variants (bay leaf, but in botany: the laurel family).

Particularly important in this regard is the role of stress as a way of expressing grammatical meanings and overcoming the homonymy of word forms ”. As established by scientists, most of the words of the Russian language (about 96%) have a fixed stress. However, the remaining 4% are the most commonly used words that make up the basic, frequent vocabulary of the language.

Here are some spelling rules in the area of ​​stress, which will help prevent corresponding errors.

Nouns

AIRPORTS, motionless stress on the 4th syllable

BANTS, motionless. stress on the 1st syllable.

borod, vin.p., only in this form singular. stress on the 1st syllable

bukhgAlterov, genus ov.mn.ch., fixed stress on the 2nd syllable

creed, from faith to confess

citizenship

cheapness

dispensary, the word comes from the English. lang. through the French language, where the blow. always on the last syllable

agreement

document

jalousie, from French. lang. where the blow. always on the last syllable

eminence, from adj. significant

Iksy, them. plural, fixed stress

catalog, along with the words dialOg, monolOg, necrolOg, etc.

quarter, from it. lang., where the stress is on the 2nd syllable

kilometer, in line with the words

centimeters, decimeters, millimeters ...

cones, cones, immobile. stress on the 1st syllable in all cases in singular. and many others. h

CRANES, motionless. stress on the 1st syllable

flint, flint, blow. in all forms on the last syllable, as in the word fire

lecturers, lecturers, see word bow (s)

localities, genus p.mn.ch., on a par with the word form of honors, jaws ..., but news

garbage pipe, in the same row with the words gas pipeline, oil pipeline, water pipeline

intention

necrolOg, see catalog

hatred

NEWS, NEWS, BUT: SEE LOCATIONS

But it is, but it is motionless. stress in all singular forms adolescence, from adolescent to adolescent

PARTNER FROM FR. lang. where the blow. always on the last syllable

briefcase

dowry

calling, in a row with the words calling, recalling (ambassador), calling, but: Feedback (for publication)

orphans, n.p.mn.ch., accent in all plural forms. only on the 2nd syllable

sredstva, named after p.mn.ch.

Convocation, see Convocation

stolYar, along with the words malYar, doYar, shkolYar ...

cakes, cakes

scarves, see bows

chauffeur, along with the words kioskier, controller ...

expert, from French. lang., where the stress is always on the last syllable

Adjectives

For full forms of adjectives, only fixed stress on the base or on the ending is possible. The variability of these two types in the same word forms is explained, as a rule, by a pragmatic factor associated with the distinction between little used or bookish adjectives and frequency adjectives, stylistically neutral or even reduced. Indeed, uncommon and bookish words often have an emphasis on the base, and frequent, stylistically neutral or diminished ones - on the ending.

The degree of mastery of the word is manifested in the variants of the place of stress: circle and circle, spare and spare, near-earth and near-earth, minus and minus, clean and clean. Such words are not included in the USE tasks, since both options are considered correct.

And yet, the choice of the place of stress causes difficulties most often in short forms of adjectives. Meanwhile, there is a fairly consistent norm, according to which the stressed syllable of the full form of a number of common adjectives remains stressed and in a short form: beautiful - beautiful - beautiful - beautiful - beautiful; inconceivable - inconceivable - inconceivable - inconceivable - inconceivable, etc.

The number of adjectives with movable stress in the Russian language is small, but they are often used in speech, and therefore the stress norms in them need comments.

The stress often falls on the base in the plural, as well as in the singular in the masculine and neuter gender, and on the feminine ending: right - right - right - right - right - right; gray - gray - gray - gray - sulfur; STRONG - STRONG - STRONG - STRONG - STRONG.

Such adjectives, as a rule, have monosyllabic stems without suffixes or with the simplest suffixes (-к-, -н-). However, one way or another, it becomes necessary to refer to the orthoepic dictionary, since a number of words "knock out" of the specified norm. You can, for example, say: long and long, fresh and fresh, full and full, etc.

It should also be said about the pronunciation of adjectives in the comparative degree. There is such a rule: if the stress in the short form of the feminine gender falls on the ending, then in a comparative degree it will be on the suffix of it: strong - stronger, sick - more sick, alive - alive, slim - slim, right - right; if the stress in the feminine gender is on the basis, then in a comparative degree it is preserved on the basis: beautiful - more beautiful, sad - more sad, opposite - more opposite. The same goes for the superlative form.

Verbs

One of the most tense points of stress in common verbs is the past tense. The stress in the past tense usually falls on the same syllable as in the infinitive: sit - sit, moan - moan, hide - hide, start - start. At the same time, the group of common verbs (about 300) obeys another rule: the stress in the feminine form goes to the ending, and in other forms it remains on the stem. These are the verbs take, be, take, twist, lie, drive, give, wait, live, call, lie, pour, drink, tear, etc. It is recommended to say: live - lived - lived - lived - lived; wait - waited - waited - waited - waited; pour - lil - lilo - lili - lilA. Derivative verbs are pronounced in the same way (live, take, drink, shed, etc.).

The exception is words with the prefix you-, which accepts the emphasis on itself: vyzhit - vyzhila, vylit - vylila, vyzvat - invoked.

For the verbs to put, steal, send, send the stress in the feminine form of the past tense remains on the basis of: SEND, SEND, STLAla.

And one more pattern. Quite often, in reflexive verbs (in comparison with non-reflexive ones), the stress in the past tense goes to the ending: begin - began, began, began, began, began; Accepted - Accepted, Accepted, Accepted, Accepted.

About the pronunciation of the verb, call in the conjugated form. Spelling dictionaries of recent times quite reasonably continue to recommend the stress on the ending: you call, call, call, call, call. This

the tradition is based on classical literature (primarily poetry), the speech practice of authoritative native speakers.

pamper, along with the words

pamper, spoil, spoil ... but: the balloon of fate

take-take

SHOOT-SHOOT

take-take

take it

turn on-turn on

turn on, turn on

IN-IN-IN

break in-break in

perceive-perceived

recreate-recreate

hand over

chase-chase

chase-chased

kind-kind

GET-GET

wait-wait

dial-call

will call

dose

wait-waited

LIVING-LIVING

seal up

borrowed, borrowed

occupied, occupied

LOCK-LOCKED

Locked-locked (with a key, lock, etc.)

call-call

call-call

exhaust

CLASS CLALA

hiding - hiding

lie-lie

pour-lilA

pouring-pouring

lie-lied

endow-endow

overstrain-overstrain

name-named

roll-roll

pour-pour

NARVAT-NARWAL

shit-shit

start, start, start, start

call-call

make it easier

doused-doused

hug-hug

overtook-overtook

cheer up-skinned

encourage

cheer up-cheer up

sharpen

lend-lend

to anger

surround-surround

SEAL, in line with the words

to form, normalize, sort,

REWARD ...

send

refresh-refresh

depart-depart

give-give

bet-open

revoke-recalled

REVOKE-REVOKE

call back - call back

overflow-overflow

fruit

Repeat-Repeat

call-call

call-call-call-call

WATER-WATER

put-put

understand-understand

SEND-SEND

arrive-arrived-arrived

take-take-take-take

compel

tear-tore

DRILL-DRILL-DRILL-DRILL

take off

CREATE-CREATE

pluck-plucked

sort-sort

REMOVE-REMOVE

speed up

deepen

strengthen-strengthen

pinch-pinch, pinch

Stress in participles and participles

The most frequent stress fluctuations are recorded when pronouncing short passive participles. If the stress in full form is on the suffix -YONN-, then it remains on it only in the masculine form, in other forms it goes to the ending: conducted - carried out, carried out, carried out, carried out; imported - imported, imported, imported, imported. However, it is sometimes difficult for native speakers to choose the place of stress correctly and in full. They say: "introduced" instead of imported, "translated" instead of translated, etc. In such cases, it is worthwhile to refer to the dictionary more often, gradually practicing the correct pronunciation.

A few notes on the pronunciation of full participles with the -T- suffix. If the suffixes of an indefinite form o-, -nu- are stressed, then in the participles it will go one syllable forward: weave - full, prick - chipped, bend - bent, wrap - wrapped.

Passive participles from the verbs pour and drink (with the suffix -t-) are characterized by an unstable stress. You can say: spilled and spilled, spilled and spilled, spilled (only!), Spilled and spilled, spilled and spilled; DOPITED AND DOPITED, DOPITED AND DOPITED, DOPITED AND DOPITED, DOPITED AND DOPITED, DOPITED AND DOPITED.

Communion

ballroom

included-included, see reduced

delivered

folded

busy-busy

locked-locked

inhabited-inhabited

spoiled, see spoiled

feeding

bleeding

who clicked

haunted-acquired

poured-poured

hired

THE BEGINNER

STARTED

brought down-brought down, see included ...

encouraged-encouraged-encouraged

sharpened

disabled

definite-definite

disconnected

repeated

divided

understood

cured

tamed

resident

filmed-filmed

Gerunds

The gerunds often have an emphasis on the same syllable as in the indefinite form of the corresponding verb: nesting, asking, filling, borrowing, writing down, exhausting (NOT: exhausting), starting, raising, living, watering, putting, understanding, anticipating, Arriving, accepting, selling, cursing, spilling, getting through, drinking, creating.

pampering

having sealed

Beginning

raising

Accent in adverbs

Stress in adverbs should mainly be learned by memorizing and referring to the spelling dictionary.

in time

donElzya

enviously, in the meaning of the predicate

zAgoda, colloquial

dawn

more beautiful, adj. and adverb in compare Art.

In the Demo version of the USE 2016 in Russian, task 4 is formulated as follows: "In one of the words below, there was a mistake in the stress setting: the letter denoting a stressed vowel is WRONGLY highlighted. Write this word down." The proposed material is a thematic test for the section "Orthoepy" and is compiled on the basis of the orthoepic minimum, compiled on the basis of an official letter from FIPI. This test can be used as a didactic material in preparing students for the Russian language Olympiad.

Download:


Preview:

Task number 4 of the exam

1.In one of the words below, a mistake was made in the formulation of stress: WRONG

NavErh

Pam

More beautiful

CAKES

to open

2. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

plum

whooping cough

quarter

envied

agent

3. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Catalog;

Prayer;

BralA;

DEEPEN

tableYar

4. In one of the words below, there was a mistake in the stress setting.: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Localities;

blinds;

not a friend;

leisure.

ukre pIT.

5. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Security

Dispatcher;

you call;

convocation;

ARRIVAL

6. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

DedAv;

to seal;

Bent;

Sight.

Hatred

7. In one of the words below, there was a mistake in the stress setting.: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

The statue;

Zentner;

Kilometer;

dawn.

LIVED.

8. In one of the words below, there was a mistake in the stress setting: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Beginning;

Scarves;

Include;

Expert.

Poured

9. In one of the words below, there was a mistake in the staging of the stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Document

Kitchen;

Mosaic;

THERE.

Cheer up;

10. In one of the words below, a mistake was made in the formulation of stress:The letter for the stressed vowel is WRONGLY highlighted. Write this word down

Surround;

Called A;

Security;

In time.

orphans;

11. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Fruit;

Disabled;

percent;

overtook A.

will surround;

12. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

CAKES;

Significant;

Resident;

Swerlit.

not too long.

13. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Having closed;

KralAs;

SEAL;

Agent.

understood;

14. One of the words below contains a mistake in the stress setting.: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Dowry;

Plum;

Debate;

Nadolgo.

imperial.

15. In one of the words below, there was a mistake in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

BOTTOM;

Busy;

Funds;

I took it.

Arrived

16. In one of the words below, there was a mistake in the stress setting.: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Bows;

Rolls;

Heretic;

obituary.

GnalA;

17. In one of the words below, there was a mistake in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Understood;

To pissed off;

I waited;

PARTNER.

call us.

18. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Makes it;

Konuses;

Raising;

sent.

Before dry

19. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Beginning;

lighten;

Greed;

Sorrel.

dry

20. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Exclude;

BukhgAlters;

bleeding;

you will call.

Dexterity

21. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

NAIL;

grasped;

Agent;

I got it.

briefcase

22. In one of the words below, a mistake was made in the stress setting: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down

X;

religion;

Started;

Scoop.

The most beautiful.

23. In one of the words below, a mistake was made in the stress setting: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down

Alphabet;

DOSE;

Busy;

Apparently.

Customs

24. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Long-standing;

Chain;

entertained;

garbage chute.

Turn on

25. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Hired;

Quarter;

It is dark;

has come.

winterer

26. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Have taken;

NedUg;

Burst in;

Citizenship.

Localities

27. In one of the words below, there was a mistake in the staging of the stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Scoop;

Hyphen;

DonElzya;

Flint

UkrAla

28. In one of the words below, a mistake was made in the formulation of the stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Cement

Accepted;

NEWS;

Covers.

Call back

29. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Intention;

Beard;

Feeding;

DovErhu.

bent

30. In one of the words below, a mistake was made in the formulation of stress: WRONG the letter denoting the stressed vowel sound is highlighted. Write this word down

Agreement;

Started;

navErh;

Red-hot.

Sort

Answers

feast

plum

appealing;

leisure.

Dispatcher;

bent

The statue;

scarves;

Mosaic

security;

DISABLED;

This activity tests your ability to correctly stress words. It will take you some time to practice this skill. Highlight those words in which you are mistaken, repeat exactly them. The number of these words will gradually decrease.

Assignment 4 Unified State Exam in Russian

Statement of the assignment:

One of the words below contains a mistake in setting

stress: WRONG the letter denoting the stressed vowel sound is highlighted.

Write this word down.

disconnected

Adolescence

NEWS

Let's say right away: the task is complicated by the fact that every day we hear incorrectly pronounced words around us, the ear gets used to the error to such an extent that, looking into the orthoepic dictionary, we say with bewilderment: "Is it really SO right?" Yes, stress in Russian is varied, flexible, does not obey strict rules, it is traditional. And to honor traditions is a sign of good upbringing!

Do not worry in advance, there are not so many really difficult words, mistakes, as a rule, are in the same words, so you do not need to memorize the entire spelling dictionary in alphabetical order. We propose to memorize words in groups, within which there are patterns of stressing.

Remember that you need to complete this task only out loud, listening to yourself and remembering. Find five minutes a day for this.

1... BEGINNING - BEGINNING, BEGINNING, BEGINNING - BEGINNING, / BEGINNED, BEGINNED, BEGINNED - BEGINNED / BEGINNED - BEGINNED / BEGINNED

You see, the stress of the past tense verb and the passive participle goes to the ending only in the feminine gender. The actual participle is Avshy, the gerunds are Avs. Suffers the stress of the suffix СЯ.

Try to build the chain yourself using this model: understand, accept, borrow, pour, live, give (given), betray, sell.

Attention! Exception-tongue twister: klala, ukrAla, postlA, sent

The prefix YOU pulls the stress over itself: I called, I poured

2. A group of verbs on-ITE, in which the emphasis falls on the ending in all personal forms. We learn one more chain:

Call - call, call, call, call, call

Now yourself: favor, turn on loosen, hand over, contain, drown out, exclude, heel, bleed, endow, dirty, cheer up, relieve, borrow, surround, repeat, cheer up, call, bear fruit, separate, drill, litter, deepen, strengthen, pinch.

If the verb changes the prefix, the chain still works.

Attention! In these verbs the stress does not fall at the end: send we will deceive ... - will be deceived. Even in participles and participles, the stress remains in place: vulgarized, vulgarized.

Remember: to send, to anger, coercE, to dose, to copy, to open, to grow moldy, to exhaust, to grow frosty, to make up. The stress always falls on the root!

3... Many verbs no ITT (see point 2) can form participles with-YONN We remember that the stress goes to the ending in the feminine and neuter gender. Here is the chain:

On - on, onA, onO

We compose ourselves: entrusted, endowed, encouraged, strengthened and etc.

4. In some nouns, the stress remains fixed during declension, we check it by the initial form:

AIRPORT - AIRPORTS, BANT - BANTS, WITH BANTS, BUCHGALTER - BUCHGALTERS, - BUCHGALTERS, TORT - Cakes, Cakes.

Do the following words without changing the place of stress: contract, crane, flint, lecturer, locality, stem, scarf, fibers, rake, windows, honors, guns, glass, shoes , jaw, nursery ... (You will come across some of these words in task 6, where their correct declension will be indicated.)

In other nouns, the stress will move:

bandage - bandages, coat of arms - coats of arms, bridge - bridges, branches - to branches, waves - to waves.

Decline nouns, remembering that the stress will move: sickle, tableYar, wardrobe, money, swans, news, queues, areas, sheets, tablecloths, speed.

5. Adjectives often retain stress on the same syllable as the nouns from which they are derived:

KUHONNY (KITCHEN), EXPERTS (EXPERTS), Augustow (August).

Add stress by checking it for a noun: heather, heraldic adolescent, plum, Ukrainian.

Attention! mosaic, scanty, wholesale.

And in these adjectives, the stress changes the meaning of the word: family laurel - bay leaf, language barrier - tongue sausage.

6. Gas pipeline, garbage pipeline, oil pipeline (from the word wire), and electric pipeline (from the word wire - wire).

7. Concentration (from concentrating), providing (from providing).

Now yourself: consolidation, confession

8. The stress in these verbs falls on the last syllable: spoil, seal, reward.

Forming participles with НН, we make the shock suffix Ova: pampered, (pampering), sealed, prematured.

Attention! copy

8. Here are some adverbs:

To the top, to the bottom, to the dry, to the clean. But: doElzya, white, daughter, red-hot.

For a long time, for a long time, for sure, a little, masterfully

9. A few more groups of words to remember.

1. Speaker, spy, move, move.

2. A nap, a yawn, a scrap

3. Gastronomy, veterinary medicine, kinematogrAfia, fluorogrAfia

4. Nursing, bleeding, praying

5. Citizenship, long-standing, dispensary, leisure, heretic, blinds, Spark, catalog, necrolOg, beetroot greed, orphans, convocation, dancer, trapeza, tunika, sorrel, fiery, penetrating, expert

Finally, the "hit" of errors: beautiful - more beautiful - the most beautiful!

The lesson is devoted to how to solve the 4th task of the exam in computer science


The 4th topic is characterized as tasks of the basic level of complexity, the execution time is about 3 minutes, the maximum score is 1

* Some images of the page are taken from the materials of the presentation by K. Polyakov

Sometimes you also come across tasks that require knowledge of the basics.

Database

Database Is a repository of large amounts of data of a certain subject area, organized into a specific structure, i.e. stored in an orderly way.

The USE tasks are mainly related to tabular databases, so we will briefly consider them.

Data in tabular databases are presented, respectively, in the form of a table.

Table rows are named records and the columns are fields:

  • All fields must have unique names. In the example: Surname, Name, Address, Phone.
  • Fields have different types of data, depending on their content (for example, character, integer, currency, etc.).
  • Fields can be required or not.
  • A table can have an unlimited number of records.

Key field Is a field that uniquely identifies a record.
There cannot be two or more records in the table with the same value of the key field (key).

  • To select a key field, take any unique data about the object: for example, the number of a person's passport (no one has a second such number).
  • If the table does not provide such unique fields, then a so-called surrogate key is created - a field (usually ID or Code) with unique numbers - counter - for each record in the table.

Relational database Is a set of tables that are linked to each other (between which relationships are established). The link is created using numeric codes (key fields).

Relational database "Store"

Positive in relational databases:

  • duplication of information is excluded;
  • if any data changes, for example, the address of the company, then it is enough to change it in only one table - Sellers;
  • protection against incorrect input (or input with errors): you can select (as if to enter) only the company that is in the table Sellers;
  • For the convenience of searching the database, a special table is often created. Indexes.
  • Index- this is a special table designed to perform a quick search in the main table by the selected column.

The sequence of performing logical operations in complex queries:

  • relations are fulfilled first, then - "And", then - "OR"... Parentheses are used to change the order of execution.

File system


Comparing string data

In tasks of the 4th type, it is often necessary to compare string values. Let's see how to do it correctly:

Any character is always greater than empty:

Solving tasks 4 Unified State Exam in Informatics

Unified State Exam in Informatics 2017 task 4 FIPI option 1:

Tables 2 contains information about the child and one of his parents. The information is represented by the field value ID on the corresponding line Tables 1.

Based on the data provided, determine the total number of direct descendants (i.e. children, grandchildren, great-grandchildren) Ioli A.B.



✍ Solution:

Result: 7

You can also see video solutions 4 tasks of the exam in computer science:

Unified State Exam in Informatics 2017 task 4 FIPI option 9:

Below are two tables from the database, which collect information about the employees of a certain organization. Each line Tables 2 contains information about an employee of a structural unit and his immediate supervisor, who, in turn, is a direct subordinate of a higher-level supervisor. The information is represented by the value of the field ID on the corresponding line Tables 1.

Based on the data provided, determine the total number of subordinates (direct and through lower-level managers) Sidorova T.I..



✍ Solution:

Result: 9

You can read with the solution of this 4 task of the exam in computer science from the video lesson:

Let's consider one more, at first glance, simple, but with a "trap" task of the exam:

Task 4. Р-01 (kpolyakov.spb.ru):

The table contains several records from the "Schedule" database:

Specify the numbers of records that meet the condition
Lesson_number> 2 AND Class> ‘8A’

1) 1, 6
2) 2, 6
3) 2, 5, 6
4) 1, 2, 5, 6

Check out the video tutorial for an example of solving this 4 task:

4 task. Demo version of the Unified State Exam 2018 Informatics (FIPI):

Below are two fragments of tables from the database of residents of the microdistrict. Each line table 2 ID on the corresponding line table 1.

Determine on the basis of the given data, how many children had mothers over 22 full years of age at the time of their birth. When calculating the answer, take into account only the information from the given fragments of the tables.



✍ Solution:
  • From the second table we write ID of all children and their respective Parent ID... Find the selected parent and child IDs in the first table and leave only those parent IDs that match the female sex. We also write out the year of birth:
ID 23: 1968 - 1941 = 27 ! 24: 1993 - 1967 = 26 ! 32: 1960 - 1941 = 19 33: 1987 - 1960 = 27 ! 35: 1965 - 1944 = 21 44: 1990 - 1960 = 30 ! 52: 1995 - 1967 = 28 !
  • The condition is met 5 items (> 22).
  • Result: 5

    For a detailed solution to this 4 task from the 2018 USE demo, see the video:

    4 task of the exam or 3 task of the GVE grade 11 in informatics 2018 (FIPI):

    File name masks are used for group operations with files.

    Symbol "?" (question mark) means exactly one arbitrary character.
    The "*" (asterisk) symbol means any sequence of characters of arbitrary length, including "*" can specify an empty sequence.


    There are 8 files in the directory:

    Declaration.mpeg delaware.mov delete.mix demo.mp4 distrib.mp2 otdel.mx prodel.mpeg sdelka.mp3

    Determine which of the listed masks of these 8 file the specified group of files will be selected:

    Otdel.mx prodel.mpeg

    Answer options:
    1) * de? .M *
    2)? De * .m?
    3) * de * .mp *
    4) de * .mp?


    ✍ Solution:

    Result: 1

    The solution to the task of the 3rd GVE in informatics can be seen in the video:

    4 task of the exam or 5 task of the GVE grade 11 in informatics 2018 (FIPI):

    Below are two tables from the database. Each line table 2 contains information about the child and one of his parents. The information is represented by the field value ID on the corresponding line table 1.

    Determine on the basis of the given data the surname and initials nephew Geladze P.P.

    Answer options:
    1) Williams S.P.
    2) Geladze P.I.
    3) Leonenko M.S.
    4) Leonenko S.S.


    ✍ Solution:

    Result: 3

    For a detailed solution to the GVE task, see the video tutorial:

    Assignment 4 Unified State Exam in Russian

    Stressing words. Let's go over a little theory first.

    Accents of common words that you should always remember:
    Paragraph, agent, alibi, analogue, watermelon, arest, athlete, banty, bluda, petrol line, blagovest, fear, hyphen, contract, document, docent, leisure, nap, clergyman, evangelie, zeal, blind Icon painting, invention, exploration, tool, Spark, confession, rubber, quarter, self-interest, vine, scrap, medics, youth, taxing, intent, ill health, silence, provision, adolescence, plateau, briefcase, sheet, sheet revolver, belt, beet, silos, convocation, means, customs, dancer, perfection, chain, gypsy, porcelain, expert.

    Nouns:
    1) If words with the -log- root are offered, then know that it is percussive: dialOg, katalOg, epilOg, necrolOg.
    The exceptions are “analogue” and words that name professions and occupation: philOlog, biOlog, archeOlog.
    2) If the word ends in -miya, then [o] under stress: astronomia, economy, except for terms-words (anemia, metonymy).
    3) If the word has the second part -mania or -arya, then [a] under stress: drug addiction, anglomania; SeminAria, kulinAria, veterinAria.

    Adjectives:
    1) If the adjective is in the feminine form, then the ending is stressed: badА, fastА, youngА, dear.
    2) Neuter and plural forms require emphasis on the stem: bad, fast, young, expensive; ploshi, fast, young, expensive.
    3) The ending is always stressed in exception adjectives: funny, heavy, hot, light, equal, dark, warm, smart, black, good (funny, funny, funny; heavy, heavy, heavy, etc.)

    Verbs:
    1) Remember that the prefix is ​​always shock (pop out, insert), and the root ring is always unstressed (call, call, call).
    2) In the infinitive verb, the stress most often falls on the suffix: to give, to splash, to seal.
    3) As with nouns, in the feminine form the stressed ending (waitedA, removedA, acceptedA), and in the neuter and plural, the stressed base (waited, waited, understood, understood).
    Exceptions: klAla, send, ukrAla, sent away.
    4) The prefixes for, for-, pro, over-tighten the stress (zanyal, zanyalo, zanyali).
    Exceptions are verbs in which the stress falls on the root: called, called, called; ripped off, ripped off, ripped off.

    Communions:
    1) Full participles have suffixes -ann- and -yann- unstressed (broken, scattered).
    2) The suffix -enn- unstressed in the participle, if in the form of the future tense the stress is based on (wake up - awakened),
    3) and the suffix -enn- happens only if in the form of a future tense verb there is an emphasis on the ending (if you put it in - it is entered).
    4) If in the full form of the short participle the suffix is ​​-ёnn-, then in the short form -ёn- (brought - brought),
    another option is also possible (Given - Given, Given, Given, BUT given).
    5) The prefixes drag the stress: NAMED - NAME, NAME, NAME, NAME. Collected - Collected, Collected, Collected, Collected.
    6) In the feminine and neuter gender, as well as in the plural, the stress is on the ending (brought, brought, brought).

    There are no uniform rules for pronouncing adverbs ...
    Now you can try to apply the knowledge gained to solve several options for task 4 from the exam in the Russian language.

    Test options for task 4 from Ege in Russian:

    Try to solve them yourself and compare with the answers at the end of the page

    Example 1:

    briefcase
    put
    plum
    called
    chain

    Example 2:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    delivered
    hand over
    tore off
    catalog
    donElzya

    Example 3:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    accepted
    BEGINNING
    called
    cakes
    arrived

    Example 4:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    tore off
    will call
    (squirrel) dexterity
    will endow
    includes

    Example 5:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    mosaic
    call
    removed
    beard
    funds

    Example 6:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    call them
    tore
    citizenship
    long-standing
    selected

    Example 7:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    disconnected
    Adolescence
    chauffeur
    Wholesale
    NEWS

    Example 8:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    arriving
    to the bottom
    adopted
    click
    STARTED

    Example 9:

    In one of the words below, a mistake was made in the formulation of stress: the letter denoting a stressed vowel sound is WRONGLY highlighted. Write this word down.

    dryness
    pinching
    BANTS
    beard
    Adolescence

    Answers:

    1. will call

      call

      citizenship

    Share with your friends or save for yourself:

    Loading...