Page 323 - IT 402 v2.0 class 10
P. 323
Solved Exercise
Section
ecti e T e uestions
Multi le c oice uestions:
1. The Select command is which of the following categories command?
i. DDL ii DML
iii TCL iv. XML
2. SQL stands for ............................. .
i. Structured Queue Language ii. Structured Query Language
iii. Structured Query Lang iv. None of these
3. ............................. statement is used to retrieve data from table.
i. Delete ii. Update
iii. Print iv. Select
4. Which of the following commands is used to edit records through SQL View?
i. Update ii. Edit
iii. Modify iv. Alter
5. Which of the following commands is used to delete records using SQL view?
i. Remove ii. Drop
iii. Delete iv. Erase
6. Which of the following is not a data type of SQL?
i. Between ii. Integer
iii. Character iv. Date
Ans. 1. ii 2. ii 3. iv 4. i 5. iii 6. i
Fill in t e lan s
1. A ............................. enables users to view, enter, and change data directly in database objects such as tables.
2. The ............................. command is used to insert record using SQL view.
3. A ............................. is a part of DML involving information retrieval only.
4. A popular data manipulation language is ............................. .
5. ............................. are used to manage transactions by tracking other comman and there effects on the database.
Ans. 1. DML comamnds 2. Insert 3. Select
4. SQL 5. TCL commands
More on Database 321

