database management system CBSE class 10 IT notes (2MCQ SET & 1 DESCRIPTIVES SET)

database management system CBSE class 10 IT notes  (2MCQ SET & 1 DESCRIPTIVES SET)

OBJECTIVE QUESTIONS (SET 01) 

 

1. What is the purpose of a form in a database? 

a. Form is systematic way of storing information into the table. 

b. Form is used to display information. 

c. Both a) and b) 

d. None of the above. 

Ans: a. Form is systematic way of storing information into the table. 

 

2. Which SQL command will increase the salary of all employees by 5000? (Table name is emp and 

column name is salary). 

a. UPDATE emp SET sal = salary + 5000; 

b. UPDATE SET sal = salary + 5000; 

c. UPDATE emp SET salary = 5000; 

d. None of the above. 

Ans: a. UPDATE emp SET sal = salary + 5000; 

 

3. What is the purpose of the SQL query: “SELECT * FROM Stud ORDER BY Rollno ASC;”? 

a. Display all record in ascending order followed by Rollno 

b. To display all the records of the table. 

c. Both of the above. 

d. None of the above. 

Ans: a. Display all record in ascending order followed by Rollno 

 

4. What does DML stand for? 

a. Database Manipulation Language 

                Page - 2 - b. Data Modification Language 

c. Data Manipulation Language 

d. None of the above 

Ans: a. Data Manipulation Language 

 

5. What does SQL stand for? 

a. Structured Query Language 

b. Structured Quality Language 

c. Structural Query Language 

d. None of the above 

Ans: b. Structured Query Language 

 

6. Which language is used to extract/fetch data from a table? 

a. HTML 

b. MySQL 

c. OOBase 

d. Python 

Ans: b. MySQL 

 

7. In Base, how can data be linked between two or more tables? 

a. Foreign key 

b. Primary key 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

8. In which view can the structure of a table be changed? 

a. Design view 

b. Structure view 

c. Data view 

d. All of the above 

Ans: a. Design view 

 

9. What data type is the Auto Value property used for? 

a. Date 

b. Character 

c. Numeric 

d. Binary 

Ans: c. Numeric 

 

10. Which data type is appropriate for storing information such as salary, fees, and price? 

a. Binary data type 

b. Alphanumeric data type 

c. Date Time 

d. Numerical data type 

Ans: d. Numerical data type 

 

11. In what ways can a table be created? 

a. Using a Wizard 

b. Using design view 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

                Page - 3 -  

12. What kind of field is a primary key? 

a. Duplicate Data 

b. Unique Data 

c. Any Data 

d. None of the above 

Ans: b. Unique Data 

 

13. Does data integrity mean that data is accurate and consistent in the database? 

a. Yes 

b. No 

Ans: a. Yes 

 

14. Which of the following is not a database program? 

a. MySQL 

b. Writer 

c. Oracle 

d. OpenOffice base 

Ans: b. Writer 

 

15. What is a database? 

a. A collection of attributes 

b. A collection of field 

c. An organized collection of data 

d. None of the above 

Ans: c. An organized collection of data 

 

16. Which field in the “Student” table can act as the primary key? 

a. Roll_No 

b. Fee 

c. Student_name 

d. Marks 

Ans: a. Roll_No 

 

17. Is Open Office base an open source software? 

a. True 

b. False 

Ans: b. False 

 

18. What is the default name of a table? 

a. 1 Table 

b. Table 1 

c. Untitled 1 

d. Tab 1 

Ans: b. Table 1 

 

19. Which of the following data types will occupy more space in computer memory? 

a. Bigint 

b. Smallint 

c. Tinyint 

d. Integer 

Ans: a. Bigint 

 

                Page - 4 - 20. In which view can data be entered in a table? 

a. Data view 

b. Datasheet view 

c. Both a) and b) 

d. None of the above 

Ans: b. Datasheet view 

 

21. Can relationships be created between _________ tables in Base? 

a. One table only 

b. Two or more tables 

c. Both a) and b) 

d. None of the above 

Ans: b. Two or more tables 

 

22. Are queries commands that are used to define the structure and modify the data in a table? 

a. True 

b. False 

Ans: a. True 

 

23. Which SQL query will retrieve the details of all students whose favorite color is blue? 

a. SELECT all FROM Stud WHERE fav_Color = ‘Blue’; 

b. SELECT all FROM Stud WHERE fav_Color is ‘Blue’; 

c. SELECT name FROM Stud WHERE fav_Color = ‘Blue’; 

d. SELECT * FROM Stud WHERE fav_Color = ‘Blue’; 

Ans: d. SELECT * FROM Stud WHERE fav_Color = ‘Blue’; 

 

24. By default, data is arranged in _____ order using the ORDER BY clause. 

a. Descending 

b. Ascending 

c. Both a) and b) 

d. None of the above. 

Ans: b. Ascending. 

 

26. Which of the following is NOT a SQL command? 

a. DELETE 

b. UPDATE 

c. SELECT 

d. CREATE 

Ans: d. CREATE 

 

27. What is a foreign key? 

a. A key that can contain null values 

b. A key that can contain Zero 

c. A key that references another table’s primary key 

d. A key that uniquely identifies in table 

Ans: c. A key that references another table’s primary key 

 

28. Which of the following field properties is for the Numeric data type in Base? 

a. Default Value 

b. AutoValue 

c. Length 

d. All of the above 

Ans: d. All of the above 

                Page - 5 -  

29. What is the default length of the Integer data type in Base? 

a. 20 

b. 40 

c. 10 

d. 50 

Ans: c. 10 

 

30. We can create a relationship between any two tables by selecting which option from the which 

menu? 

a. Relationships 

b. Filter 

c. Sort 

d. All of the above 

Ans: a. Relationships 

 

31. In which relationship, both the tables must have primary key columns? 

a. One to Many 

b. One to One 

c. Many to Many 

d. Many to All 

Ans: b. One to One 

 

32. What are the commands that define the data structure and manipulate the data in a database? 

a. Reports 

b. Queries 

c. Forms 

d. Tables 

Ans: b. Queries 

 

33. Which operators are used to perform simple calculations in Base? 

a. Arithmetic Operators 

b. Membership Operators 

c. Logical Operators 

d. Relational Operators 

Ans: a. Arithmetic Operators 

 

34. Can ‘Where’ and ‘Order by’ clauses be used together in a single query? 

a. True 

b. False 

Ans: a. True 

 

35. What is the purpose of the Update command in a database? 

a. It is used to modify the data of the table. 

b. It is used to delete the table. 

c. It is used to modify the structure of the table. 

d. It is used to insert data in the table. 

Ans: a. It is used to modify the data of the table. 

 

36. Which statement is used to remove one or more records from a database? 

a. Erase 

b. Delete 

c. Remove 

                Page - 6 - d. Del 

Ans: b. Delete 

 

37. Can we insert records into a table using a form in a database? 

a. True 

b. False 

Ans: a. True 

 

38. Which method is used to create a table step by step? 

a. Use Wizard to Create Table 

b. Create View 

c. Create table in Design View 

d. None of the above 

Ans: a. Use Wizard to Create Table 

 

40. Which of the following is not a Date Time data type? 

a. Date 

b. Stamptime 

c. Time 

d. Timestamp 

Ans: b. Stamptime 

 

41. Binary data types are used for storing data in _________________ formats. 

a. image 

b. sound 

c. boolean 

d. binary 

Ans: d. binary 

 

42. Which of the following is not a category of Open Office data types? 

a. Alphanumeric Types 

b. Date time 

c. Numeric Types 

d. Bool Type 

Ans: d. Bool Type 

 

43. Which feature helps us get summarized data in a database? 

a. Form 

b. Query 

c. Report 

d. Table 

Ans: c. Report 

 

44. Which database feature helps users to systematically store information in a table? 

a. Table 

b. Report 

c. Form 

d. Query 

Ans: c. Form 

 

45. Rajesh wants to display the salary of all the employees after incrementing it by twice the amount 

of the present salary. Which query will help her achieve this task? 

a. Select salary + 2 from employee; 

                Page - 7 - b. Select salary / 2 from employee; 

c. Select salary – 2 from employee; 

d. Select salary * 2 from employee; 

Ans: d. Select salary * 2 from employee; 

 

46. Which feature is used to collect specific information from the pool of data? 

a. Form 

b. Query 

c. Table 

d. Report 

Ans: b. Query 

 

47. Which of the following relationships cannot be created in Open Office Base? 

a. One to Many 

b. Many to Many 

c. One to One 

d. Many to All 

Ans: d. Many to All 

 

48. Which property helps to set the value that is automatically inserted in a field when a new record is 

created? 

a. Length 

b. Entry Required 

c. Format 

d. Default Value 

Ans: d. Default Value 

 

49. Which field property in Base can be used to automatically increment the value of a field? 

a. Format 

b. Length 

c. Auto Value 

d. Default Value 

Ans: c. Auto Value 

 

50. In which view can data be entered in a table in Base? 

a. Datasheet View 

b. Design View 

c. Both of the above 

d. None of the above 

Ans: a. Datasheet View 

 

51. Which of the following is NOT a component of a database management system? 

a. Data warehouse 

b. Query language 

c. Data dictionary 

d. Database engine 

Ans: a. Data warehouse 

 

52. Which of the following is NOT a join type in SQL? 

a. Outer join 

b. Full join 

c. Inner join 

d. Circular join 

                Page - 8 - Ans: d. Circular join 

 

53. Which element in a table contains data of the same data type? 

a. Column 

b. Tuple 

c. Record 

d. All of the above 

Ans: a. Column 

 

54. A table has a fixed number of ________ but can have any number of ________ 

a. tuple, columns 

b. columns, rows 

c. rows, columns 

d. tuple, degree 

Ans: b. columns, rows 

 

55. Which of the following acts as an interface to view, enter and change data in a database? 

a. Report 

b. Form 

c. Table 

d. Query 

Ans: b. Form. 

 

56. Which SQL command is used to delete data from a table? 

a. INSERT 

b. REMOVE 

c. SELECT 

d. DELETE 

Ans: d. DELETE 

 

57. Which is the most common DML command? 

a. Delete 

b. Select 

c. Update 

d. All of the above 

Ans: b. Select 

 

58. Which software is appropriate for storing data about school students? 

a. Calc 

b. MS-Access 

c. Writer 

d. Impress 

Ans: b. MS-Access 

 

59. What kind of data storage system stores data in a single table? 

a. Only File 

b. Relational 

c. One File 

d. Flat File 

Ans: d. Flat File 

 

60. What kind of computer holds the actual databases and runs only DBMS and related software? 

a. Database Server 

                Page - 9 - b. Web Server 

c. SMPT Server 

d. POP Server 

Ans: a. Database Server 

 

61. What is the role of the database server in relation to the GUI? 

a. Back End 

b. Front End 

c. Both a) and b) 

d. None of the above 

Ans: a. Back End 

 

62. What is duplication of data called? 

a. Redundancy 

b. Consistency 

c. Foreign Key 

d. Inconsistency 

Ans: b. Redundancy 

 

63. Which of the following is not an advantage of a database? 

a. Increasing Data Inconsistency 

b. Increasing Data Redundancy 

c. Data Security 

d. Sharing of Data 

Ans: a. Increasing Data Inconsistency 

 

64. Can a database have only one table? 

a. Yes 

b. No 

Ans: b. No 

 

65. Which of the following is used to maintain unique records in a table? 

a. Composite Key 

b. Primary Key 

c. Alternate Key 

d. Foreign Key 

Ans: b. Primary Key 

 

66. What is a primary key made up of two or more columns called? 

a. Composite Primary Key 

b. Alternate Primary Key 

c. Foreign Primary Key 

d. Reference Primary Key 

Ans: a. Composite Primary Key 

 

67. Can duplicate values be entered in a primary key? 

a. Yes 

b. No 

Ans: b. No 

 

68. What is a key that refers to the primary key of another table called? 

a. Alternate Primary Key 

b. Foreign Key 

                Page - 10 - c. Primary Key 

d. Alternate Key 

Ans: b. Foreign Key 

 

69. What kind of database software is required when data is stored, maintained, and retrieved from 

multiple tables? 

a. SpreadSheet 

b. RDBMS 

c. DBMS 

d. All of the above 

Ans: b. RDBMS 

 

70. Does every row in a table have the same structure? 

a. True 

b. False 

Ans: a. True 

 

71. What are the basic building blocks of a database? 

a. Records 

b. Tables 

c. Fields 

d. All of the above 

Ans: b. Tables 

 

72. What is the default data type of fields? 

a. Int 

b. Text[Memo] 

c. Memo 

d. Text[Varchar]  

Ans: d. Text[Varchar] 

 

73. Does Base automatically add a column as Primary Key if none is added? 

a. True 

b. False 

Ans: a. True 

 

74. What is the default length of the Varchar data type? 

a. 10 

b. 30 

c. 50 

d. 20 

Ans: c. 50 

 

75. What is used to identify the type of data that will be stored in a database? 

a. Field 

b. Data type 

c. Table 

d. Record 

Ans: b. Data type 

 

76. Which of the following is not a numerical data type? 

a. Varchar 

b. Tinyint 

                Page - 11 - c. Boolean 

d. Smallint 

Ans: a. Varchar 

 

77. Which of the following data types cannot store decimal values? 

a. Boolean 

b. Decimal 

c. Numeric 

d. Real 

Ans: a. Boolean 

 

78. Which data type is used for storing photos, music files, and other binary data? 

a. Numeric 

b. Varchar 

c. Binary 

d. Alphanumeric 

Ans: c. Binary 

 

79. Is Char a fixed-length data type and Varchar a variable-length data type? 

a. Yes 

b. No 

Ans: a. Yes 

 

80. What operations can be performed on data in a table? 

a. Insert 

b. Delete 

c. Modify 

d. All of the above 

Ans: d. All of the above 

 

81. After inserting records in a table, can the structure of the table be modified? 

a. True 

b. False 

Ans: b. False 

 

82. What does sorting mean? 

a. Arranging data in decreasing order 

b. Arranging data in increasing order 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

83. Is Referential Integrity used to maintain accuracy and consistency of data in a relationship? 

a. True 

b. False 

Ans: a. True 

 

84. From which menu a relationship can be created in Base? 

a. View 

b. Tools 

c. Insert 

d. Windows 

Ans: b. Tools 

                Page - 12 -  

85. How many types of relationships can be created between tables in Base? 

a. Four 

b. Five 

c. Three 

d. Two 

Ans: c. Three 

 

86. In Open Office Base, in which view can a query be created? 

a. Using wizard 

b. Design view 

c. Both a) and b) 

d. None of the above 

Ans: c. Both of the above 

 

87. Can data be deleted using queries in Base? 

a. True 

b. False 

Ans: b. False 

 

88. Which statement is used to retrieve data from a table? 

a. Print 

b. Select 

c. Delete 

d. Update 

Ans: b. Select 

 

89. What is the purpose of the SQL query: “SELECT empname, salary * 3 FROM emp;”? 

a. Display only name and salary 

b. It will give an error. 

c. Display empname and three times of the salary of all employees. 

d. None of the above. 

Ans: c. Display empname and three times of the salary of all employees. 

 

90. Which SQL command is used to modify data in a table? 

a. SELECT 

b. MODIFY 

c. DELETE 

d. UPDATE 

Ans: d. UPDATE 

 

91. Which of the following SQL commands are considered as DML commands? 

a. UPDATE 

b. DELETE 

c. INSERT 

d. All of the above. 

Ans: d. All of the above. 

 

92. What is another name for a tuple in a table? 

a. Record 

b. Column 

c. Both of the above 

d. Attribute 

                Page - 13 - Ans: a. Record 

 

93. Which element in a table represents a single data item? 

a. Rows 

b. Attribute 

c. Columns 

d. Field 

Ans: c. Columns 

 

94. Which of the following is NOT a standard SQL data type? 

a. Float 

b. Boolean 

c. Integer 

d. String 

Ans: b. Boolean 

 

95. Which of the following is NOT a function of a database management system? 

a. Data retrieval 

b. Data manipulation 

c. Data storage 

d. Data transmission 

Ans: d. Data transmission 

 

96. Which of the following is NOT a type of data manipulation language (DML)? 

a. SELECT 

b. UPDATE 

c. INSERT 

d. DELETE 

Ans: a. SELECT 

 

97. What can you do with data in a table created in Base? 

a. Modify it 

b. Insert it 

c. Delete it 

d. All of the above 

Ans: d. All of the above 

 

98. In which view can the structure of a table be changed in Base? 

a. Design View 

b. Datasheet View 

c. Both of the above 

d. None of the above 

Ans: a. Design View 

 

99. Which field property in Base can be used to store data in a specific format, such as a phone 

number? 

a. Auto Value 

b. Length 

c. Default Value 

d. Format 

Ans: d. Format 

 

100. What is the default value of the field property ‘Entry Required’ in Base? 

                Page - 14 - a. Yes 

b. No 

Ans: b. No 

 

101. To arrange the data in ascending or descending order, first select the column(s) and then click on 

which button? 

a. View 

b. Save 

c. Arrange 

d. Sort 

Ans: d. Sort 

 

102. When a primary key from one table appears in another table, it is called a ________. 

a. Composite Primary Key 

b. Secondary Key 

c. Foreign Key 

d. Main Key 

Ans: c. Foreign Key 

 

103. In which relationship, one of the table must have primary key column? 

a. One to Many 

b. One to One 

c. Many to Many 

d. Many to All 

Ans: a. One to Many 

 

104. Once the relationships applied on the tables cannot be removed. 

a. True 

b. False 

Ans: b. False 

 

105. To remove the relationship between tables, right-click on the relationship thread and select 

which option? 

a. Delete 

b. Remove 

c. Edit 

d. Clear 

Ans: a. Delete 

 

106. Which language is used to write a query in Open Office Base? 

a. VB 

b. SQL 

c. C 

d. Python 

Ans: b. SQL 

 

107. Which command is used to retrieve data from a table? 

a. Delete 

b. Create 

c. Select 

d. Insert 

Ans: c. Select 

 

                Page - 15 - 108. Can SELECT statement retrieve data from multiple tables? 

a. True 

b. False 

Ans: a. True 

 

109. Rajesh wants to display all the records from the table ‘student’. 

a. Select * student; 

b. Select # from student; 

c. Select from student; 

d. Select * from student; 

Ans: d. Select * from student; 

 

110. Which clause can be used with the SELECT SQL command to display records containing the 

same type of values? 

a. Order By 

b. Where 

c. Both a and b 

d. None of the above 

Ans: b. Where 

 

111. Which commands are used to add, modify, and delete records in a database table? 

a. Insert, Update, and Remove 

b. Insert, Update, and Delete 

c. Insert, Modify, and Delete 

d. Add, Update, and Delete 

Ans: b. Insert, Update, and Delete 

 

112. By default, in which order is data arranged using the ORDER BY clause in a database? 

a. Decreasing 

b. Alphabetical 

c. Increasing 

d. Descending 

Ans: c. Increasing 

 

113. Which clause of the SELECT statement helps to display specific data in a database? 

a. Where 

b. Between 

c. Order By 

d. None of the above 

Ans: a. Where 

 

114. What is the name of the interface in a user-specified layout that lets users view, enter, and 

change data directly in database objects such as tables? 

a. Query 

b. Form 

c. Report 

d. Table 

Ans: b. Form 

 

115. Aman created an object ‘X’ in Base to store the value in the form of rows and columns. What is 

‘X’? 

a. Table 

b. Row 

                Page - 16 - c. Column 

d. Database 

Ans: a. Table 

 

116. Which of the following contains data of the same data type? 

a. Record 

b. Tuple 

c. Column 

d. All of the above 

Ans: c. Column 

 

117. Give an example of an open-source RDBMS. 

a. Microsoft SQL Server 

b. Microsoft Access 

c. Oracle 

d. OpenOffice Base 

Ans: d. OpenOffice Base 

 

118. What is the default length of the TINYINT data type? 

a. 1 

b. 2 

c. 3 

d. 4 

Ans: c. 3 

 

119. Which data type can store character/data up to the length specified by the user? 

a. Varchar 

b. Char 

c. Varchar_IgnoreCase 

d. All of the above 

Ans: d. All of the above 

 

120. Dhriti wants to store the details of students as well as their pictures in a table named “school”. 

Which data type is suitable for storing pictures? 

a. Boolean 

b. Binary 

c. Memo 

d. Varchar 

Ans: b. Binary 

 

121. Which data type stores hours, minutes, and second information? 

a. Date 

b. Time 

c. Stamptime 

d. Timer 

Ans: b. Time 

 

OBJECTIVE QUESTIONS (SET 02) 

 

1. A _________ is an organized collection of data. 

a. Database 

b. Digital Document 

c. Spreadsheet 

                Page - 17 - d. None of the above 

Ans: a. Database 

 

2. A ________ is a software package that can be used for creating and managing databases. 

a. Database Management System 

b. Basedata Management System 

c. Database Manage System 

d. None of the above 

Ans: a. Database Management System 

 

3. A_________________ database management system is referred to as a relational model. 

a. DBMS 

b. RDBMS 

c. DB 

d. None of the above 

Ans: b. RDBMS 

 

4. Example of the database ________. 

a. Microsoft Access 

b. OpenOffice Base 

c. MySQL 

d. All of the above 

Ans: d. All of the above 

 

5. The database concept has evolved since the _______. 

a. 1980 

b. 1960 

c. 1955 

d. 1950 

Ans: b. 1960 

 

6. DBMS Stands for __________. 

a. Database Management System 

b. Database Manage System 

c. Data Manage System 

d. None of the above 

Ans: a. Database Management System 

 

7. A database management system is a software package with computer programs that controls the 

___________. 

a. Creation 

b. Maintenance 

c. Use of Database 

d. All of the above 

Ans: d. All of the above 

 

8. A database is an integrated collection of ___________. 

a. Data records 

b. Files 

c. Objects 

d. All of the above 

Ans: d. All of the above 

 

                Page - 18 - 9. A DBMS enables several user application programs to access the ________ database. 

a. Other Database 

b. Same Database 

c. Both a) and b) 

d. None of the above 

Ans: b. Same Database 

 

10. Data can be organized into __________. 

a. Flat File 

b. Relational 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

11. Data stored in a single table is known as __________. 

a. Flat File 

b. Relational 

c. Both a) and b) 

d. None of the above 

Ans: a. Flat File 

 

12. Data is stored in multiple tables, which are connected together via a common field. 

a. Flat File 

b. Relational 

c. Both a) and b) 

d. None of the above 

Ans: b. Relational 

 

13. __________ are dedicated computers that hold the actual databases and run only the DBMS and 

related software. 

a. Database Server 

b. Decided Server 

c. Web Server 

d. None of the above 

Ans: a. Database Server 

 

14. What are the advantages of database __________. 

a. Reduces Data Redundancy 

b. Sharing of Data 

c. Data Integrity 

d. All of the above 

Ans: d. All of the above 

 

15. When the same piece of data is stored in two or more locations, it is called ______________. 

a. Data Redundancy 

b. Data Integrity 

c. Data Consistency 

d. None of the above 

Ans: a. Data Redundancy 

 

16. _________ prevents creating multiple copies in the database. 

a. Data Redundancy 

b. Data Integrity 

                Page - 19 - c. Data Consistency 

d. None of the above 

Ans: a. Data Redundancy 

 

17. __________ means that the data is accurate and consistent in the database. 

a. Data Redundancy 

b. Data Integrity 

c. Data Consistency 

d. None of the above 

Ans: b. Data Integrity 

 

18. Only authorized users should be allowed to access the database and their identity should be 

authenticated using a username and password known as ________. 

a. Data Redundancy 

b. Data Consistency 

c. Data Security 

d. None of the above 

Ans: c. Data Security 

 

19. Database Management System automatically takes care of ____________. 

a. Data Redundancy 

b. Backup and Recovery 

c. Data Security 

d. None of the above 

Ans: b. Backup and Recovery 

 

20. ___________ prevent multiple mismatching copies of the same data in the database and only 

valid data will be added in the database. 

a. Data Redundancy 

b. Backup and Recovery 

c. Data Consistency 

d. None of the above 

Ans: c. Data Consistency 

 

21. __________ in a table represents a set of information with the same structure in every row. 

a. Tuples 

b. Record 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

22. A __________ is the actual text, number, or date that you enter when adding data to your 

database. 

a. Values 

b. Table 

c. Boolean 

d. None of the above 

Ans: a. Values 

 

23. The unique field present in the table is called __________. 

a. Primary Key 

b. Candidate Key 

c. Foreign Key 

                Page - 20 - d. None of the above 

Ans: a. Primary Key 

 

24. When the primary key is applied on multiple columns is known as __________. 

a. Primary Key 

b. Composite Primary Key 

c. Foreign Key 

d. None of the above 

Ans: b. Composite Primary Key 

 

25. By default if the primary key is not defined that column is known as __________. 

a. Primary Key 

b. Candidate Key 

c. Foreign Key 

d. None of the above 

Ans: c. Foreign Key 

 

26. __________ key can store multiple same records in the table. 

a. Primary Key 

b. Candidate Key 

c. Foreign Key 

d. None of the above 

Ans: c. Foreign Key 

 

27. The relationship between two tables where one table has one record and another table has many 

records is known as ___________. 

a. One-to-Many 

b. Many-to-Many 

c. Many-to-One 

d. None of the above 

Ans: a. One-to-Many 

 

28. SQL stands for _____________. 

a. Single Query Language 

b. Structured Query Language 

c. Semantic Query Language 

d. None of the above 

Ans: b. Structured Query Language 

 

29. A ____________ is a collection of data components organized in the form of vertical columns 

and horizontal rows. 

a. Table 

b. Fields 

c. Attributes 

d. None of the above 

Ans: a. Table 

 

30. A row also called a Record or _________ represents a single, data item in a table. 

a. Column 

b. Tuples 

c. Fields 

d. None of the above 

Ans: b. Tuples 

                Page - 21 -  

31. You can create tables in the database using _________. 

a. Wizard 

b. SQL 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

32. ____________ are the basic building blocks of a database. 

a. Table 

b. Query 

c. Database 

d. None of the above 

Ans: a. Table 

 

33. _____________ are used to define the type of data that will be stored in the database. 

a. Data Types 

b. Data field 

c. Key Data 

d. None of the above 

Ans: a. Data Types 

 

34. What are the different types of data type available in OpenOffice base? 

a. Numeric Types 

b. Alphanumeric Types 

c. Binary Types & Date time 

d. All of the above 

Ans: d. All of the above 

 

35. __________ types are used for describing numeric values for the field used in the table of a 

database. 

a. Numeric Type 

b. Alphanumeric Type 

c. Boolean Type 

d. Date & Time 

Ans: a. Numeric Type 

 

36. ___________ data type can store 0 or 1 in the database. 

a. Boolean 

b. TinyInt 

c. Smalint 

d. BigInt 

Ans: a. Boolean 

 

37. What are the different numerical data types? 

a. Boolean 

b. Tinyint & Smallint 

c. Integer & Bigint 

d. All of the above 

Ans: d. All of the above 

 

38. ____________ data type can store UTF 8 Characters in the database. 

a. Longvarchar 

                Page - 22 - b. Char 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

39. __________ is case sensitive data type in the database. 

a. Longvarchar 

b. Varchar_Ignorecase 

c. Varchar 

d. All of the above 

Ans: b. Varchar_Ignorecase 

 

40. ___________ data types in a database can be used for storing photos, music, video or any file 

format. 

a. Numerical Type 

b. Alphanumeric Type 

c. Binary Type 

d. Date & Time 

Ans: c. Binary Type 

 

41. Which datatype is used for storing date and time both in the database. 

a. Date 

b. Time 

c. Timestamp 

d. None of the above 

Ans: c. Timestamp 

 

42. A table is a collection of data elements that are organized using a vertical __________ and 

horizontal ___________ model. 

a. Column & Row 

b. Row & Column 

c. Column & Column 

d. Row & Row 

Ans: a. Column & Row 

 

43. A ________ is a collection of data values of a specific type, one for each row of a table. 

a. Column 

b. Row 

c. Cell 

d. None of the above 

Ans: a. Column 

 

44. In a table, a __________ represents a single data item. 

a. Row 

b. Truple 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

45. _____________ are used to identify which type of data we are going to store in the database. 

a. Datatype 

b. DataItem 

c. DataValue 

                Page - 23 - d. DataCat 

Ans: a. Datatype 

 

46. There are ________ ways to create a table. 

a. 1 

b. 2 

c. 3 

d. 4 

Ans: b. 2 

 

47. Field properties can be set in both the ________ and _________ . 

a. Length & Default Value 

b. Length & Entry 

c. Both a) and b) 

d. All of the above 

Ans: c. Both a) and b) 

 

48. By default the length of the numerical data type is _______. 

a. 05 

b. 10 

c. 20 

d. 30 

Ans: b. 10 

 

49. If the user does not specify a value for a field while putting values into the table, a 

_____________ value can be assigned to it. 

a. Default Value 

b. Length 

c. Format 

d. None of the above 

Ans: a. Default Value 

 

50. ________ means to arrange the data in either ascending order or descending order. 

a. Filter 

b. Sorting 

c. Arrangement 

d. None of the above 

Ans: b. Sorting 

 

51. ____________ is used to maintain accuracy and consistency of data in a relationship. 

a. Referential data 

b. Referential Integrity 

c. Referential Value 

d. None of the above 

Ans: b. Referential Integrity 

 

52. In base, data can be linked between two or more tables with the help of ____________. 

a. Primary Key 

b. Foreign Key 

c. Both a) and b) 

d. None of the above 

Ans: c. Both a) and b) 

 

                Page - 24 - 53. Referential Integrity helps to avoid ____________. 

a. If you want to add a record in the related table and if there is no associated record available in the 

primary key table. 

b. Changing values in a primary if there are any dependent records in the related table. 

c. Deleting records from a primary key table if there are any matching related records available in the 

associated table. 

d. All of the above 

Ans: d. All of the above 

 

54. The connection or association between two or more table is known as ____________ 

a. Connection 

b. Relationship 

c. Connector 

d. None of the above 

Ans: b. Relationship 

 

55. Relationships between tables help to __________. 

a. Save time 

b. Reduce data-entry errors 

c. Summarize data from related tables 

d. All of the above 

Ans: d. All of the above 

 

56. What are the different types of relationships which can be created in table___________. 

a. One to One 

b. One to Many or Many to One 

c. Many to Many 

d. All of the above 

Ans: d. All of the above 

 

57. ___________ is the relationship, where both the tables must have primary key columns. 

a. One to One 

b. One to Many or Many to One 

c. Many to Many 

d. All of the above 

Ans: a. One to One 

 

58. ____________ in this relationship, one of them must have a primary key column. 

a. One to One 

b. One to Many or Many to One 

c. Many to Many 

d. All of the above 

Ans: b. One to Many or Many to One 

 

59. A ____________________ is a standard for commands that define the different structures in a 

database. 

a. Data Manipulation Language (DML) 

b. Data Definition Language (DDL) 

c. Both a) and b) 

d. None of the above 

Ans: b. Data Definition Language (DDL) 

 

60. A ______________ is a language that enables users to access and manipulate data in a database. 

                Page - 25 - a. Data Manipulation Language (DML) 

b. Data Definition Language (DDL) 

c. Both a) and b) 

d. None of the above 

Ans: a. Data Manipulation Language (DML) 

 

61. A ____________ is a subset of DML that just deals with information retrieval. 

a. Query Language 

b. Structure Language 

c. Both a) and b) 

d. None of the above 

Ans: a. Query Language 

 

62. A popular data manipulation language is _________________. 

a. Structured Query Language 

b. Machine Level language 

c. Low level language 

d. None of the above 

Ans: a. Structured Query Language 

 

63. There are __________ types of Relationships in a table. 

a. 2 

b. 3 

c. 4 

d. 5 

Ans: b. 3 

 

64. _________ means that the query hides certain data and displays only what you want to see based 

on the criteria you provided. 

a. Filtering 

b. Sort 

c. Query 

d. All of the above 

Ans: a. Filtering 

 

65. A __________ statement used to display the zero record or multiple record from the database. 

a. Select 

b. Order By 

c. Where 

d. None of the above 

Ans: a. Select 

 

66. To retrieve all the columns in a table the syntax is ___________. 

a. Select $ from <tablename>; 

b. Select * <tablename>; 

c. Select * from <tablename>; 

d. Select % <tablename>; 

Ans: c. Select * from <tablename>; 

 

67. To display the records containing the same type of values _________ clause can be used with the 

Select SQL Command. 

a. Where 

b. More 

                Page - 26 - c. Order 

d. None of the above 

Ans: a. Where 

 

68. Shortcut key for executing query in OpenOffice base. 

a. F2 

b. F3 

c. F4 

d. F5 

Ans: d. F5 

 

69. To view records in ascending order from a database. 

a. Unorder by 

b. Order by 

c. Acc by 

d. Decc by 

Ans: b. Order by 

 

70. ___________ statement is used for modifying records in a database. 

a. Modify 

b. Update 

c. Delete 

d. Select 

Ans: b. Update 

 

 

71. The syntax of the update statement is _____________. 

a. Update <tablename> set <columnname = value> where <condition>; 

b. Update <tablename> set <condition> where <condition>; 

c. Modify <tablename> set < value> where <condition>; 

d. Modify <tablename> set <columnname = value> where <condition>; 

Ans: a. Update <tablename> set <columnname = value> where <condition>; 

 

72. A _______ helps the user to systematically store information in the database. 

a. Form 

b. Table 

c. Report 

d. None of the above 

Ans: a. Form 

 

73. A ________ enables users to view, enter, and change data directly in database objects such as 

tables. 

a. Table 

b. Form 

c. Report 

d. None of the above 

Ans: b. Form 

 

74. _________ statement retrieves zero or more rows from one or more database tables or database 

views. 

a. Select 

b. Update 

c. Delete 

                Page - 27 - d. None of the above 

Ans: a. Select 

 

75. By default, data is arranged in _______ order using ORDER BY clause. 

a. Ascending 

b. Descending 

c. Both a) and b) 

d. None of the above 

 

Ans:  

a. Ascending 

76. __________ statement is used for modifying records in a database. 

a. Select 

b. Update 

c. Delete 

d. None of the above 

Ans: b. Update 

 

77. To remove one or more records from a database, use the _________ statement. 

a. Select 

b. Update 

c. Delete 

d. None of the above 

 

Ans:  

c. Delete 

Session 5: Create Forms and Reports using Wizard 

78. A __________ provides the user a systematic way of storing information into the database. 

a. Query 

b. Form 

c. Table 

d. None of the above 

Ans: b. Form 

 

79. __________ will help you to display summarized data from the database. 

a. Report 

b. Form 

c. Table 

d. None of the above 

Ans: a. Report 

 

80. To create a form you need to select the _________ option available under the Database section. 

a. Form 

b. Query 

c. Report 

d. All of the above 

Ans: a. Form 

 

81. A ______ helps to collect specific information from the pool of data in the database. 

a. Form 

b. Query 

c. Report 

d. All of the above 

                Page - 28 - Ans: b. Query 

 

82. ________ is used to display the summary of data. 

a. Form 

b. Query 

c. Report 

d. All of the above 

Ans: c. Report 

 

83. _________ are the interfaces with which the user interacts. 

a. Form 

b. Query 

c. Report 

d. All of the above 

Ans: a. Form 

 

84. Data from multiple tables can be stored in _______. 

a. Data system 

b. Database 

c. Datatype 

d. None of the above 

Ans: b. Database 

 

85. Which data type is suitable for storing values for ‘date of birth’ field? 

a. Time 

b. Date 

c. Both of the above 

d. Timestamp 

Ans: b. Date 

 

86. Which data type is most suitable for storing a very large amount of data? 

a. LongVarchar or Memo 

b. Char 

c. Varchar 

d. Varchar_IgnoreCase 

 

Ans:  

a. LongVarchar or Memo 

87. Identify the odd one out. 

a. Binary Types 

b. Date & Day Type 

c. Numeric Types 

d. Alphanumeric Types 

Ans: b. Date & Day Type 

 

88. What does a single data item in a table represent? 

a. Columns 

b. Attribute 

c. Rows 

d. Field 

Ans: c. Rows 

 

89. Which toolbar helps us move from one record to another in a form in a database? 

                Page - 29 - a. Formatting Toolbar 

b. Image Toolbar 

c. Standard Toolbar 

d. Form Navigation Toolbar 

Ans: d. Form Navigation Toolbar 

 

90. What is the correct query to increase the salary of all employees by Rs.10000 in a table named 

Employee with a column name of Salary? 

a. Update Employee set Salary = Salary + 10000; 

b. Update * Employee set Salary = Salary + 10000. 

c. Update table Employee set Salary = Salary + 10000; 

d. Update table Employee set Salary = 10000; 

Ans: a. Update Employee set Salary = Salary + 10000; 

 

91. Which query will display the details of all the students in increasing order of Roll number? 

a. Select * from student order by ‘Rollno’; 

b. Select * student order by ‘Rollno’; 

c. Select all from student order by ‘Rollno’; 

d. Select * from student orderby ‘Rollno’; 

Ans: a. Select * from student order by ‘Rollno’; 

 

92. Which clauses can be used with the SELECT statement? 

a. Order by Clause 

b. Where clause 

c. Both a) and b) 

d. None of the above 

 

Ans:  

c. Both a) and b) 

93. In which relationship, no table has the primary key column? 

a. Many to One 

b. One to One 

c. Many to Many 

d. One to Many 

Ans: c. Many to Many 

 

94. Referential integrity refers to the _______________ between tables. 

a. communication 

b. consistency 

c. relationship 

d. joining 

Ans: c. relationship 

 

95. Which field property in Base must be set to “Yes” in order to require a value to be entered in a 

field? 

a. Entry Required 

b. Auto Value 

c. Format 

d. Length 

 

Ans:  

a. Entry Required 

96. In which view can field properties be set in Base? 

                Page - 30 - a. Design View 

b. Datasheet View 

c. Both of the above 

d. None of the above 

Ans: a. Design View 

 

97. Which of the following is a benefit of using a database management system? 

a. Improved data security 

b. Improved data accessibility 

c. Improved data consistency 

d. All of the above 

Ans: d. All of the above 

 

98. Which of the following is NOT a type of database model? 

a. Relational 

b. Object-oriented 

c. Hierarchical 

d. Procedural 

Ans: d. Procedural 

 

99. Which of the following is an example of an open-source RDBMS? 

a. Oracle 

b. Microsoft Access 

c. OpenOffice Base 

d. Microsoft SQL Server 

Ans: c. OpenOffice Base 

 

100. What is the purpose of a report in a database? 

a. Report is used to display information. 

b. Report is systematic way of storing information into the table. 

c. Both a) and b) 

d. None of the above. 

Ans: a. Report is used to display information. 

 

SHORT ANSWER TYPE QUESTIONS 

 

1. What is database? Give an example. What does DBMS stand for? 

Ans. A collection of related information organised as tables is known as database e.g. INGRES, 

MySQL etc. DBMS stands for DataBase Management System. It is a computer-based record 

keeping system. 

 

2. What is the difference between ‘Rows’ and ‘Columns’ in a table? 

Ans. In a table, rows are called records and columns are termed a fields. A row stores complete 

information of a record whereas column stores only similar data values for all records. 

 

3. What is field in database? Give an example. 

Ans. A field is an area, reserved for a specific piece of data. It is also known as attribute. e.g. 

Customer Name. 

  

4. Define forms and what is the need of using them? 

Ans. A form is a window or screen that contains numerous fields or spaces to enter data. Forms 

can be used to view and edit your data. It is an interface in user specified layout. 

 

                Page - 31 - 5. What does RDBMS stand for? 

Ans. RDBMS stands for Relational Database Management System. It is a type of DBMS that 

stores data in the form of relations (tables). 

 

6. How is data organized in a RDBMS? 

Ans. A relational database is a type of database. It uses a structure that allows us to identify and 

access datain relation to another piece of data in the database. Data in a relational database is 

organized into tables. 

 

7. Write the purpose of DBMS. 

Ans. DBMS is used to store logically related information at a centralised location. It facilitates 

data sharing among all the applications requiring it. 

 

8. Write any two uses of database management system. 

Ans. The two uses of database management system are as follows 

(i) DBMS is used to store data at a centralised location. 

(ii) It is used to minimise data redundancy and data inconsistency. 

 

9. Write any two advantages of using database. 

Ans. The two advantages of using database are as follows 

(i) It can ensure data security. 

(ii) It reduces the data redundancy. 

 

10. Give any two disadvantages of the database. 

Ans. The two disadiantages of the database are as follows 

(i) A database system creates additional complexity and requirements. 

(ii) A database system is a multi-user software, which is less efficient. 

 

11. A table named School (containing data of students of the whole school) is created, where 

each record consists of several fields including AdmissionNo (Admission Number), RollNo 

(Roll Number), Name. Which field out of these three should be set as the primary key and 

why? 

Ans. AdmissionNo should be set as primary key because admission numbers are unique for each 

and every students of the school, which is not possible in the case with RollNo and Name. 

 

12. Why Memo data type is preferred over Text data type for a field? 

Ans. When the length of the field is more than 255 characters. Text data type is not capable to 

store the project description because its length cannot be more than 255 characters so, Memo data 

type is preferred over Text data type. 

 

13. What happens when text is entered in a Number type field? 

Ans. When we enter text in a Number field and press Enter or press Tab key, it displays a 

message that ‘‘The value you entered does not match the Number data type in this column.’’ 

 

14. Damini is a programmer in an institute and is asked to handle the records containing 

information of students. Suggest any 5 fields name and their data type of students database. 

Ans.    

 

                Page - 32 - 15. Create a table of Student based on the following table instance.  

 

Ans. CREATE TABLE STUDENT (ID Integer, Name varchar (15), Stream_Id Integer); 

 

16. Write a SQL command to create the table BANK whose structure is given below. 

 

Ans. The SQL command to create a table as per given structure is as follows Mysql> CREATE 

TABLE BANK (ID Number integer (10) PRIMARY KEY, Name varchar (20), B date Date, 

Address varchar (50)); 

 

17. List datatypes available in Numeric data type. 

Ans. Datatypes available in numeric data type are TINYINT, SMALLCINT, MEDIUMINT, INT 

and BIGINT. 

 

18. Write one example of data field for which you would set the Required property to Yes. 

Ans. In a table, when we declare a field as a primary key, then the field’s Required property must 

be set to yes because in a primary key field, we need to enter data always. 

 

19. What is the purpose of Default Value field property? 

Ans. If there is a situation when you want to enter same value for all records. Then, to avoid 

typing the same thing many times, you can set as a Default Value property. 

 

20. Insert some information into a table COLLEGE, whose structure is given below. 

 

Ans. (i) Mysql>INSERT INTO COLLEGE (ROLL_NO, NAME, CLASS, BRANCH) VALUES 

(2, ‘VIKAS’,12, ‘SCIENCE’); (ii) Mysql>INSERT INTO COLLEGE (ROLL_NO, NAME, 

CLASS, BRANCH) VALUES (3, ‘RAJ’, 10, ‘SCIENCE’); 

 

21. What is the value of Entry Required field? 

Ans. The value of this property can be Yes or No. If entry required is Yes, the field cannot be 

absent i.e. should be necessarily present with a value. 

 

22. What is table? Also, define Candidate Key. 

                Page - 33 - Ans. A table consists of a number of rows and columns. Each record contains values for the 

attributes. A candidate key is the smallest subset of the super key for which there does not exist a 

proper subset that is super key. Any candidate key can be choosen to uniquely identify the 

records, it is called primary key. 

 

23. What is Data Control Language? 

Ans. Data Control Language is used to create roles, permissions, and referential integrity as well 

it is used to control access to the database by securing it. These SQL commands are used for 

providing security to database objects. These commands are GRANT and REVOKE. 

 

24. What is Data Transaction Control Language? 

Ans. Transaction control commands manage changes made by DML commands. These SQL 

commands are used for managing changes affecting the data. These commands are COMMIT, 

ROLLBACK, and SAVEPOINT. 

 

LONG ANSWER TYPE QUESTIONS  

 

25. Describe any four major problems associated with sustainable development. 

Ans. Four problems associated with sustained development are as follows 

(i) The concept of sustainable development is subject to criticism. What, exactly, is to be 

sustained in a sustainable development? Any positive rate of exploitation of a non-renewable 

resource will eventually lead to exhaustion of Earth’s final stock. 

(ii) Turning the concept of sustainability into policy raises questions about how to assess the well-

being of present and future generations. The issue is more complicated because our children do 

not just inherit environmental pollution and resource depletion, but also enjoy the fruits of our 

labour, in the forms of education, skills, and knowledge (i.e. human capital), as well as physical 

capital. 

(iii) Poor management of natural resources, combined with growing economic activities, will 

continue to pose serious challenges to environment. The problem arises because people, 

institutions and governments have failed to evolve mechanism and policies to strike a balance 

between development and conservation of resources and preservation of environment. 

(iv) The commonly held view that greater economic activity necessarily hurts the environment, is 

based on static assumptions about technology, tastes and environmental investments. In reality, 

the relationships between inputs and outputs and the overall effects of economic activities on the 

environment, are continually changing. 

 

26. Mention the main principles of sustainable development. 

Ans. Main principles of sustainable development are 

(i) Respect and care for all forms of life. 

(ii) Improving the quality of human life. 

(iii) Minimising the depletion of natural resources. 

(iv) Conserving the Earth’s vitality and diversity. 

(v) Enabling communities to care for their own environment. 

(vi) Changing personal attitude and practices towards the environment. 

 

27. Why is it important to adopt sustainable development? Explain. 

Ans. A three-year study using satellites and aerial photography undertaken by the United Nations 

long ago warned that the environment had deteriorated so badly that it was ‘critical’ in many of 

eighty-eight countries, investigated. In view of all these findings and problems, sustainable 

development acquires much importance. 

Nature and mankind live and die together. 

                Page - 34 - The Earth’s vital signs reveal a patient in declining health. We need to realise our ethical and 

moral obligations to the mother Earth. Human beings are caretakers of the planet and responsible 

trustees of the legacy of future generations. 

Due to the realisation of importance of sustainable development, now there is a transcending 

concern for survival of the people and planet. We need to take a holistic view of the very basis of 

our existence. The environmental problem does not necessarily signal our demise, rather it is our 

passport for the future. To save ourselves and our future generations from catastrophe, we require 

to take a holistic view, an ecological view, seeing the world as an integrated whole, rather than a 

dissociated collection of parts. 

 

28. Describe the meaning and importance of sustainable development. 

Ans. Sustainable development refers to the process of economic development where resources are 

used judiciously to satisfy needs of not only present generation but also to conserve them for the 

use of future generations. Sustainable development takes place without depleting the present 

natural resources. 

The importance of sustainable development is discussed below 

(i) It helps to conserve and make use of means and resources for the maximum benefit without 

wastage. 

(ii) It awares the people about the responsibility to use and preserve natural resources. 

(iii) It creates the feeling that natural resources are the common property of all and nobody can 

use the property according to his personal will. It helps to conserve natural and social 

environment. 

(iv) People’s participation  is to be given  priority in development work in order to achieve the 

aim of sustainable development. 

(v) It attempts to create the concept of maintaining the present work for the future and conserving 

natural resources for future generation.