IDEAL SCHOOL
MAYILADUTHURAI
UNIT TEST -2
GRADE: 10 DATE:
SUB: INFORMATION TECHNOLOGY MARK: 50
SECTION-A (OBJECTIVE TYPE QUESTIONS) (24 x 1 =24)
1. A database is an organized collection of ___________.
a. data b. Attributes c. Record d. None of the above
2. Which of the following is not a database programs?
a. MySQL b. Oracle c. Writer d. OObase
3. Duplication of data is called ________________.
a. Inconsistency b. Consistency c. Redundancy d. Foreign Key
4. Which of the following is not the advantage of database?
a. Sharing of Data b. Reduce Data Redundancy
c. Increase Data Inconsistency d. Data Security
5. Data Integrity means that data is accurate and consistent in the database. (T/F)
a. True b. False
6. Which of the following will help to maintain unique record in the table?
a. Foreign Key b. Primary Key c. Composite Key d. Alternate Key
7. Which of the following field of table "Book" can act as primary key?
a. Book_number b. Subject c. price d. Author_name
8. When primary key is made up of two or more columns then it is called primary key.
a. Mixed b. Reference c. Composite d. Compost
9. Duplicate values can be entered in primary key. (T/F)
a. True b. False
10. A key which is referring to the primary key of another table is called
a. Alternate Key b. Primary Key c. First Primary Key d. Foreign Key
11. A field which is for each and every record is called Primary key.
a. Common b. Same c. Unique d. None of the above
12. When data is stored, maintained and retrieved from multiple tables then special
database software are required called
a. DBMS b. RDBMS c. Special DBMS d. All of the above
13. Identify the Foreign Key from table "Sales"
Table Client:
ClientID (primary Key)
clientname
clientphone
Table Sales:
SalesID (Primary Key)
ClientID
Profit
a. SalesID b. Profit c. Clientphone d. ClientID
14. In RDBMS, data is organized in the form of __________
a. Table b. Record c. Field d. None of the above
15. SQL stands for ______
a. Structured Queue Language b. Structured Query Language
c. Structured Query Lang d. None of the above
16. All the values in are of same type.
a. Records b. Table c. Database d. Fields
17. ___________ represent a single data item in a table.
a. Tuples b. Attributes c. Relation d. All of the above
18. ___________ are the basic building blocks of a database.
a. Tables b. Record c. Fields d. All of the above
19. We can create table :
a. in design view b. use Wizard c. Both of the above d. None of the above
20. ___________ are used to identify which type of data we are going to store in the
database.
a. Datatype b. Record c. Table d. Attributes
21. Which data type will be appropriate to store information as Salary, Fees, Price etc
a. Alphanumeric Data types b. Numeric Data type
c. Binary Data types d. Date Time
22. Which of the following data types can not store decimal values?
a. Decimal b. Real c. Numeric d. Boolean
23. Which data type is used to store value of fields like "Date of Birth"?
a. Date Time b. Varchar c. Integer d. Other
24. A record in table is also known as Attribute.(T/F)
a. True b. False
SECTION-B ( SUBJECTIVE TYPE QUESTIONS)
Answer any 7 out of 10 questions in 20-30 words. (7 x 2=14)
25. What is database?
26. What is DBMS?
27. Name two DBMS Software.
28. What is the difference between Flat file and Relational?
29. What do you mean by database servers?
30. Write four advantages of database.
31. What do you mean by Data Redundancy?
32. What do you mean by Data Integrity?
33. What is Data Inconsistency?
34. What is Referential Integrity?
Answer any 3 out of 4 questions in 50-80 words. (4 x 3=12)
35. How many types of relationship can be created between tables? Name them and
explain with example.
36. What do you mean by Data type? Give example of two data type used in OpenOffice
Base.
37. What is the difference between Char and Varchar data type?
