Task 12. Match the meaning of the following English words with their Russian definitions.
1. SQL query a) запис
2. Database client software b) повне оновлення
3. Relation database c) мова запитів
4. Record d) регуляційна база даних
5. Global update e) ключове слово
6. Parameter f) програмне забезпечення клієнта бази даних
7. Keyword g) SQL-запит
8. Query language h) слово-команда
9. Command word i) об’єднання таблиць
10. Joining tables j) параметр
Task 13. Match the beginning of the sentences in the first column with the endings in the second.
| 1. Adding records, finding information, and making updates 2. Query languages like SQL typically work behind the scenes 3. Database client software provides 4. An SQL query is 5. The process of purchasing an album 6. The SQL JOIN command allows you | a) as an intermediary between database client software provided to users and the database itself. b) are all important aspects of database use. c) a sequence of words, much like a sentence. d) only if you have authorization to do so. e) an easy-to-use interface for entering search specifications, new records, data updates and so on. f) does cause an update in the whole database. Your purchase just reduce the numbers of albums in the shop’s inventory. |
Task 14. Put the letters in the words in brackets into the correct order.
· A little … in query languages can help you understand the power and capabilities of databases (roducknabg).
· An SQL query typically begins with an action …, or command, which specifies the operation you want to carry out (weykdor).
· The clause consists of a keywords followed by the name of the … (ablet).
|
|
|
· Your … just reduces the numbers of albums in the shop’s inventory (sacherup).
· The term … refers to detailed specifications for a command (earpmaret).
· Although the global update function is powerful, it works only for … that have similar characteristics (coerdrs).
Task 15. Fill in the blanks choosing from the variants given.
1. Most people who access a database on a “casual” basis … with very simple user interface.
a) manipulate b) work c) operate d) interact
2. A little … in query languages can help you understand the capabilities of databases.
a) certainty b) background c) career skills d) experience
3. The SQL query language provides a collection of special command … called SQL keywords, such as SELECT, FROM, INSERT, and WHERE, which issue instructions of the database.
a) words b) passwords c) names d) numbers
4. Most SQL queries can be divided into three simple elements that … an action, the name of database table, and a set of parameters.
a) execute b) indicate c) construct d) specify
5. Customers do not have … to change album prices or alter the name of the songs on an album.
a) authorization b) rights c) permission d) possibilities
6. SQL is a very extensive and powerful language that can be used not only to … data, but also to create databases, tables and reports.
a) enter b) manipulate c) to make updates d) input
Task 16. Match the beginnings and the endings of the steps given and put them into correct order.
| 1 SET DiscountPrice=9.95 tells 2. WHERE ArtistName=”Rolling Stones” tells 3. Albums is 4. The UPDATE command means 5. It means that 6. SQL can perform a global update | a) the name of the record type containing the data you want to change. b) to change the data in the DiscountePrice field to $9.95. c) to change only those records where the artist name is Rolling Stones. d) you want to change the data in some or all of records. e) that changes the date in more than one record at time. f) is possible to update a group of records. |
Task 17. Fill in the gaps in the text.
|
|
|
SQL is a database query language that typically works behind the scenes as an intermediary between the database ___ software provided to users and the database itself. Although the specifications for searchers and other database tasks are collected by easy-to use graphical user interfaces, those specifications are converted into SQL ___ which can communicate directly with the database. An SQL query contains SQL ___ such as SELECT, FROM, INSERT, JOIN and WHERE, plus ___ that specify the details of the command. Records can be removed from a database using the SQL ___ command. Record can be added to a table using the SQL ___ command. To search for data, you can use the SQL ___ command. To change or replace the data in a field requires the SQL ___ command.
Дата добавления: 2018-10-26; просмотров: 361; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!