class 10 402 DataBase Objective Type Question Set-1 Board Examination

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

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)

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

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

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
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;

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

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

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

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

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

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

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?

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

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

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

 Class 10 Important Questions for board Examination

A. Fill in the Blanks

1. A database is an organized collection of data.

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

3. A RDBMS is a database management system that is based on the relational model.

4. Three popular DBMS software are Microsoft Access, OpenOfficeBase & MySQL.

5. A Primary Key is a unique value that identifies a row in a table.

6. Composite Key is a combination of one or more columns.

7. A table is a set of data elements that is organized using a model of vertical columns and

horizontal rows.

8. A column is a set of data values of a particular type, one for each row of the table.

9. A row represents a single, data item in a table.

10. Datatypes are used to identify which type of data we are going to store in the database.

11. Create table DDL command is used to create a table.

12. Common DDL statements are create, alter and drop.

13. The types of languages used for creating and manipulating the data in the Database are DDL &

DML.

14. A DDL is a standard for commands that define the different structures in a database.

15. A DML is a language that enables users to access and manipulate data in a database.

16. A Select is a part of DML involving information retrieval only.

17. A popular data manipulation language is SQL.

18. Tables are the basic building blocks of a database.

19. There are three types of Relationships in a table.

20. A form helps the user to systematically store information in the database.

B. Subjective Questions

1. In how many ways tables can be created in Base?

Ans. Tables can be created in two ways.

1. In Design view

2. Using Wizard

2. List datatypes available in Numeric Datatype?

Ans. The different types of numeric data types are:

Boolean	Numeric
Tinyint	Decimal
Smallint	Real
Integer	Float
Bigint	Double

3. List datatypes available in Alphanumeric Data Type?

Ans. The different types of Alphanumeric Data Type are:

 Longvarchar

 Char

 Varchar

 Varchar_Ignore Case

4. Define the structure of a table.

Ans. A table is a set of data elements (values) that is organized in vertical columns and horizontal rows. A table has a defined number of columns, but can have any number of rows.

5. Differentiate between Tuples and Attributes of a table

Ans. A row also called a Record or Tuple represents a single, data item in a table. Whereas A column is a set of data values of a particular simple type, one for each row of the table.

6. Name different Binary data types.

Ans. The different Binary data types are:

 Longvarbinary

 Binary

 Varbinary

7. How many types of relationships can be created in Base? Explain each of them.

Ans. There are three types of relationship in OpenOffice Base.

 ONE to ONE: In this relationship, both the tables must have primary key columns. Example: In

the given tables EMP and DEPT, EMP_ID in EMP table and DEPT_ID in DEPT table are the

primary keys.

 ONE to MANY: In this relationship, one of the table must have primary key column. It signifies

that one column of primary key table is associated with all the columns of associated table.

 MANY to MANY: In this relationship, no table has the primary key column. It signifies that all

the columns of primary key table are associated with all the columns of associated table.

8. What do you mean by Sorting? In how many ways it can be done?

Ans. Sorting means arranging elements in particular sequence. It can be done in two ways.

 Increasing order

 Decreasing Order