Page 330 - Trackpad 402_Class-X_Final
P. 330
3. Write an SQL command for the instructions written by using the table given below:
Friends
Sno Friend_Name Address City Phoneno Percentage
11 Amita Defence Colony Jalandar 11223344 98
22 Sweta R K Puram Delhi 22334411 91
33 Ajay GK-1 Meerut 33445566 97
a. How many rows and columns are there in the table?
b. Display only those friend who live in Delhi.
c. Display the records in the ascending order of friends' addresses.
d. Display name and phone number of those where percentage is between 95 to 100.
Ans. a. Rows=3 Columns=5
b. SELECT * FROM FRIENDS WHERE CITY=’DELHI’;
c. SELECT * FROM FRIENDS ORDER BY ADDRESS;
d. SELECT FRIEND_NAME,PHONENO FROM FRIENDS WHERE PERCENTAGE BETWEEN 95 AND 100;
Unsolved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. The intersection point between a row and column is called .
a. Row b. Column
c. Table d. Cell
2. In database helps us to retrieve the filtered data based upon some conditions.
a. Forms b. Reports
c. Queries d. Table
3. Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this
purpose.
a. Length b. Default
c. Entry Required d. Format
4. Vikram wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
a. Table b. Form
c. Relationships d. Sorting
5. A table is a set of data elements that is organized using a model of vertical and horizontal .
a. Rows, Tables b. Columns, Rows
c. Rows, Columns d. Forms, Reports
6. Vinay wants to store a huge amount of information about his firm in a database. Which type of table organization would
be most suitable for this purpose?
a. Relational b. Flat File
c. Either Relational or Flat file d. Hierarchical
7. Which of the following is not an example of DDL?
a. CREATE b. ALTER
c. SELECT D. DROP
8. Full form of DML is .
a. DATA MANAGEMENT LANGUAGE b. DATA MANIPULATION LEVEL
c. DATA MANIPULATION LANGUAGE d. DATA MANAGING LANGUAGE
330 Trackpad Information Technology-X

