Scribd
Upload
71 views1 page

Downloadfile

This document contains a practice test for Class 10 students taking the Information Technology subject. It has 3 sections - Section A with 15 multiple choice questions, Section B with 5 short answer questions, and Section C with 5 case study questions based on a sample Item table. The multiple choice questions cover topics like SQL statements, keys, relationships, data types, and more. The short answer questions ask about database queries, relationships, referential integrity, forms, and records vs fields. The case study questions involve writing SQL queries on the sample Item table to retrieve, insert, update and calculate values.

Uploaded by

master2008v12
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
71 views1 page

Downloadfile

This document contains a practice test for Class 10 students taking the Information Technology subject. It has 3 sections - Section A with 15 multiple choice questions, Section B with 5 short answer questions, and Section C with 5 case study questions based on a sample Item table. The multiple choice questions cover topics like SQL statements, keys, relationships, data types, and more. The short answer questions ask about database queries, relationships, referential integrity, forms, and records vs fields. The case study questions involve writing SQL queries on the sample Item table to retrieve, insert, update and calculate values.

Uploaded by

master2008v12
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

CHANDRASEKHAR ENGLISH MEDIUM SCHOOL, RAMLA, CHAMPUA

PRACTICE TEST DATE:01/12/2023


CLASS-X SUBJECT- INFORMATION TECHNOLOGY F.M: 30
SECTION-A
A. Multiple choice questions: (1x15=15)
1. CREATE TABLE employee (name VARCHAR, id INTEGER) What type of statement is this?
a. DML b. DDL c. View d. Integrity Constraint
2. The ________ should be chosen such that its attributes are never, or rarely changed.
a. Primary Key b. Super Key c. Candidate Key d. Foreign Key
3. Which one of the following allows us to uniquely identify the entity in the following set?
a. Domain b. Tuple c. Row d. Key
4. A ______________provides a systematic way of storing information into the database.
a. Report b. Query c. Form d. None of these
5. Command to increase the salary of all employee by 15000. (table name emp and column name sal)
a. update emp set sal = sal + 15000 b. update emp set sal = 15000
b. update emp sal = sal + 15000 d. None of the above
6. Select * from Students order by “RollNo” ASC;
a. Display all the records of the table c. display records in increasing order of roll number
b. Both (a) and (b) d. None of the above
7. Which of the following is to be created first?
a. Report b. Form c. Table d. Query
8. A _____________ helps to display data in a summarized data.
a. Report b. Form c. Query d. None of these
9. A ____________ helps to collect specific information from the pool of data.
a. Query b. Report c. Form d. None of these
10. All the values in ___________ are of same type.
a. Records b. Table c. Database d. Fields
11. Which one of the following is an example of RDBMS?
a. MongoDB b. Windows Registry c. Publisher d. Oracle
12. Which of the following is not a numeric data type?
a. Tinyint b. Smallint c. Boolean d. Date
13. CHAR is a __________ length data types and VARCHAR is a _________ length data type.
a. Fixed, variable b. variable, fixed c. variable, variable d. fixed, fixed
14. _____________ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from
the table
a. WHERE b. GROUP c. SAME d. SIMILAR
15. Which property ensures that field cannot be left blank
a. Entry required b. Format c. Required Entry d. Required
SECTION – B
Short Answer Type Question: (2x5=10)
16. Define Query in the context of database.
17. Differentiate between one-to-many relationship and many-to-many relationship.
18. What is Referential Integrity? Also write its types.
19. Define forms and what is the need of using them.
20. Differentiate between Record and a Field.
SECTION – C
Case Study: (1x5=5)
Write the queries for the following table: Item
Itemno Iname Price Qty
12 Pen 10 17
13 Eraser 5 15
14 Notebook 15 20
1. Write the number of records and fields in the Item table.
2. Write a query to insert a new record of the following details 15,” Pencil”, 20, 10.
3. Write a query to display detail of items whose quantity is more than 10.
4. Write a query to change the quantity of Item number 13 to 25.
5. Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for
each item.

You might also like