Name of the candidate: Abdullayev Ulug’bek


Download 88.55 Kb.
bet2/6
Sana13.02.2023
Hajmi88.55 Kb.
#1193979
1   2   3   4   5   6
Bog'liq
Ulugbek bratish

4. Sophisticated Users :
Modern clients can be engineers, researchers, commerce examiner, who are commonplace with the database. They can create their possess information base applications agreeing to their necessity. They don’t type in the program code butthey connected the information base by composing SQL inquiries straightforwardly through the inquiry processor.
5. Data Base Designers :
Information Base Creators are the clients who plan the structure of information base which incorporates tables, lists, sees, imperatives, triggers, put away strategies. He/she controls what information must be put away and how the information things to be related.
6. Application Program :
Application Program are the back conclusion software engineers who composes the code for the application programs.They are the computer experts. These programs might be composed in Programming dialects such as Visual Fundamental, Engineer, C, FORTRAN, COBOL etc.
7. Casual Users / Temporary Users :
Casual Clients are the clients who once in a while use/access the information base but each time when they get to the information base they require the modern data, for illustration, Center or higher level director.
Question 2
(a) What is the SQL Command to display the contents of a table. Display with an example.
(b) How do you delete a table using SQL. Show with an example.
(a) The SELECT statement is used to select data from a database.
The data returned is stored in a result table, called the result-set.
SELECT * FROM Customers
Customer_id Customer_name City
1 Alfreds Futterkiste Berlin
2 Around the Horn Mexico
3 Berglunds snabbköp Sweden
4 Jack Richard USA
(b) The DELETE command is used to delete existing records in a table.
The following SQL statement deletes the customer "Alfreds Futterkiste" from the "Customers" table:

DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste'


Download 88.55 Kb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling