DATABASE MANAGEMENT SYSTEM
NCERT/CBSE TEXTBOOK QUESTIONS
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.
Prepared by: M. S. KumarSwamy, TGT(Maths) Page - 1 -
,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
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
Prepared by: M. S. KumarSwamy, TGT(Maths) 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)
Prepared by: M. S. KumarSwamy, TGT(Maths) 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
Prepared by: M. S. KumarSwamy, TGT(Maths) Page - 4 -
NCERT/CBSE TEXTBOOK QUESTIONS
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.
Prepared by: M. S. KumarSwamy, TGT(Maths) Page - 1 -
,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
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
Prepared by: M. S. KumarSwamy, TGT(Maths) 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)
Prepared by: M. S. KumarSwamy, TGT(Maths) 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
Prepared by: M. S. KumarSwamy, TGT(Maths) Page - 4 -
