O‘zbеkiston rеspublikasi axborot tеxnologiyalari va kommunikatsiyalarini rivojlantirish vazirligi muhammad al-xorazmiy nomidagi toshkеnt axborot tеxnologiyalari univеrsitеti samarqand filiali

WISQL da jadval yaratish. Buning uchun SQL Statement darchasida jadval yaratish operatorlarin kiritamiz. Masalan:
CREATE TABLE MAIN (
SITE CHAR(30) CHARACTER SET WIN1251 NOT NULL,
ZIP CHAR(5) CHARACTER SET WIN1251,
ADDR CHAR(50) CHARACTER SET WIN1251,
PHONE TPHONE NOT NULL,
STORENUM INTEGER NOT NULL,
PHARMACY TBOOLEAN, PHOTO TBOOLEAN, TIRES TBOOLEAN,
CONSTRAINT CPHONE UNIQUE (PHONE),
CONSTRAINT ISTORENUMM PRIMARY KEY (STORENUM));
Saqlanuvchi protseduralar yaratish.
Saklanuvchi protseduralar serverda saqlanadi, kompilyasiya qilinadi va bajariladi, va mijozgabajarilish natijalarin yuboradi. Masalan, saklanuvchi protseduralar berilishiga misol
SET TERM ^ ;
CREATE PROCEDURE GET_INFO
RETURNS (NUM_SITES INTEGER, NUM_STATES INTEGER, SUM_INCOME INTEGER,
NUM_EMPLOYEES INTEGER, AVG_RATING FLOAT, OLDEST_EMPLOYEE DATE) AS BEGIN
SELECT COUNT(DISTINCT M.SITE), COUNT(MD.STATE), SUM(S.ANNUALINCOME), COUNT(E.EMPNAME), AVG(E.RATING), MIN(E.BIRTHDATE) FROM MAIN M, MONEYDETAIL MD, STOREDETAIL S, EMPLOYEEDETAIL E INTO :NUM_SITES, :NUM_STATES, :SUM_INCOME, :NUM_EMPLOYEES, :AVG_RATING,:OLDEST_EMPLOYEE;
SUSPEND;
END ^
1. SQL tilini uchta asosiy tashkil etuvchisini aytib bering
2. SQL tilini asosiy funksiyalarini aytib bering.
3. SQL tilini standarti deganda Siz nimani tushunasiz?
4. InterBase MBBT SQL ning imkoniyatlarini tavsiflab bering.
5. SQL ORACLE MBBT SQLning imkoniyatlarini tavsiflab bering.
Topshiriq variantlari.
1. Universitet talabalari.
2. Taksipark.
3. Korxona ishchi xodimlari.
4. Savdo rastasi ishi.
5. Telefon kompaniyasi abonentlari.
6. Kasalxonadagi kasalliklar tarixini yuritish.
7. Aviakassa.
8. Mexmonxona.
9. Qishloq fuqarolar yig‘inlari.
10. Soliqlar nazoratini yuritish.
11. Davlat Avtomobil nazorati ishi.
12. Ichki ishlar vazirligi MB va dasturi
13. Bank.
14. Bank kredit bo‘limi.
15. Futbol chempionati.