 |
Главная Случайная страница Контакты | Мы поможем в написании вашей работы! | |
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.
Дата публикования: 2015-09-17; Прочитано: 678 | Нарушение авторского права страницы | Мы поможем в написании вашей работы!
