1. Which of the following best defines “information”?

a. Unprocessed raw facts such as names, marks, and addresses.

b. Organized and processed data that provides meaningful insights.
c. Audio, video, and graphics stored without any processing.
d. A collection of unrelated raw facts.
Hide Answer ⟵ b. Organized and processed data that provides meaningful insights.
2. What does referential integrity in a database ensure?
a. All primary keys are unique across the database.
b. All records in a table must have a value in every column.
c. Every foreign key value must match a primary key in the referenced table or be null.
d. Data can be freely deleted from any table without constraints.
Hide Answer ⟵ c. Every foreign key value must match a primary key in the referenced table or
be null.
3. Which of the following data models sets a relation between the two or more tables?
a. Relational Data Model
b. Network Data Model
c. Hierarchical Data Model
d. Connection Data Model
Hide Answer ⟵ a. Relational Data Model
4. Which of the following statements are true about primary key in a database?
a. It is a field that can have duplicate values.
b. It uniquely identifies each record in a table.
c. It can have null values
d. It is an optional field in a database table.
Hide Answer ⟵ b. It uniquely identifies each record in a table.
5. Which of the following dialog boxes appears when the Query Design window is opened for the
first time to design a query?
a. Add Table
b. Add Query
c. Add Query or Report
d. Add Table or Query
Hide Answer ⟵ d. Add Table or Query
6. What feature in OpenOffice Base allows users to present retrieved data in a user-friendly and
formatted manner?
a. Query
b. Form
c. Report
d. Data view
Hide Answer ⟵ c. Report
7. It enables users to view, enter, and change data directly in database objects.
a. Report
b. Query
c. Form
d. Database
Hide Answer - c. Form
8. There are _ types of Relationships in a table of a database.
a. One
b. 3
c. 4
d. Many
Hide Answer - b. 3
9. A Relational database uses _ commands which is a standard user application that provides an
easy programming interface for database interaction.
a. Access
b. Python
c. SQL
d. Protocol
Hide Answer ⟵ c. SQL
10. Suraj wants to create a database for his clients. For this purpose, she needs to store the Email
IDs of his clients. Which datatype should he use to accomplish this purpose?
a. Numeric
b. Varchar
c. Binary
d. Boolean
Hide Answer ⟵ b. Varchar
11. Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query
using keyboard keys. Suggest him the shortcut key to complete the task.
a. Enter
b. Ctrl + E
c. Space bar
d. F5
Hide Answer ⟵ d. F5
12. A table can have only _ primary key in a database.
a. 1
b. 2
c. 3
d. Many
Hide Answer ⟵ a. 1
13. Multiple copies of the same file leads to _.
a. Data Inconsistency
c. Data Redundancy
b. Data Consistency
d. Foreign Key
Hide Answer ⟵ c. Data Redundancy
14. Identify the property which help to set the number of characters in text/ varchar type field of
a table in DBMS.
a. Entry Required
c. Size
b. Default Value
d. Length
Hide Answer ⟵ d. Length
15. The length of the field value of text data type is _ characters by default in DBMS.
a. 10
b. 25
c. 20
d. 50
Hide Answer ⟵ d. 50
16. Identify the mode, where we can modify in the structure of table?
a. Datasheet view
c. Design view
b. Structure view
d. All of the above
Hide Answer ⟵ c. Design view
17. __ store data in a single table which is suitable to store less amount of Data.
a. Flat File
b. Relational
c. Mini File
d. Single File
Hide Answer ⟵ a. Flat File
18. Database servers are referred to as ___.
a. Front ends
b. Back-ends
c. Clients
d. Model
Hide Answer ⟵ b. Back-ends
19. 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
Hide Answer ⟵ b. Columns, Rows
20. Akshat wants to store a huge amount 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
Hide Answer - c. Either Relational or Flat file
21. __ database is a type of database that stores data in several tables.
a. Flat
b. Relational
c. both a. and b.
c. None of them
Hide Answer ⟵ b. Relational
22. In database _ helps us to retrieve the filtered data based upon some conditions.
a. Forms
b. Reports
c. Queries
d. Table
Hide Answer ⟵ c. Queries
23. 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
Hide Answer ⟵ c. Entry Required
24. __ can be set for a field if the user doesn’t provide any value while entering the values in the
table.
a. Required
b. Default
c. Primary Key
d. Format
Hide Answer ⟵ b. Default
25. Aadya 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
Hide Answer ⟵ c. Relationships
26. _ data type takes the values in the form of 0 and 1 in the database.
a. Integer
b. Text
c. Boolean
d. Memo
Hide Answer ⟵ c. Boolean
27. _ means that the query uses criteria you provide to hide some data and display only required
data.
a. Filtering
c. Report
b. Sorting
d. Forms
Hide Answer ⟵a. Filtering
28. Identify the mode, where we can modify in the structure of table?
a. Datasheet view b. Design view c. Structure view d. All of the above
29. What is the primary purpose of a query in a database?
(a) To enter new records (b) To create reports (c) To retrieve specific data (d) To design forms
30. Which of the following is NOT true about forms?
(a) It is the front end for data entry
(b) It can contain text fields
(c) Graphics can be inserted on the form
(d) It can accept only fixed number of records