Page 64 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 3: Structured Query Language

2. ANSI stands for: Notes
(a) American National Standards Institute
(b) American National Systematic Institute
(c) American Nation Standards Institute

(d) Ahmedabad National Standards Institute
3. DML stands for:
(a) Document Manipulation Language
(b) Data Manipulation Language

(c) Data Maintain Language
(d) Database Manipulation Language
Fill in the blanks:
4. ......................... can be used to create a table, index, or view.

5. The .......................... supported by SQL depend on the particular implementation.
6. Database system has several schemas according to the level of ..........................
7. ............................... keyword is used to specify a condition.
8. The ............................. statement is used to insert or add a row of data into the table.

9. The drop table command is used to delete a table and ......................... in the table.
10. Null means .............................

3.15 Review Questions

1. Define query.
2. What is SQL? Explain its features.

3. Explain with examples different SQL commands used for creating and deleting relations.
4. Explain the basic structure of SQL query.
5. List some of the set operations supported by SQL. Give examples.

6. Explain different comparison and logical operators supported by SQL. Give examples.
7. Explain how to order the tuples in a table using SQL?
8. Explain group-by clause, aggregate functions and having clause available in SQL.
9. Explain with examples different SQL commands used for modifying the database.
10. Write a query to find the distinct customers and branch names of the branches situated in
the city “Hyderabad” where the customers have taken the loans.

Answers: Self Assessment

1. (c) 2. (a)
3. (b) 4. data definition

LOVELY PROFESSIONAL UNIVERSITY 57