Teachers and Examiners (CBSESkillEduction) collaborated to create the RDBMS Class 11 MCQ. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.
RDBMS Class 11 MCQ
1. A _________ is an organized collection of data.
a. Database
b. Digital Document
c. Spreadsheet
d. None of the above
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
3. In an RDBMS data is stored in _________.
a. Table
b. Form
c. Query
d. Report
4. A_________________ database management system is referred to as a relational model.
a. DBMS
b. RDBMS
c. DB
d. None of the above
RDBMS Class 11 MCQ
5. Example of the database ________.
a. Microsoft Access
b. OpenOffice Base
c. MySQL
d. All of the above
6. DBMS Stands for __________.
a. Database Management System
b. Database Manage System
c. Data Manage System
d. None of the above
7. A table refers to a _________ representation of data arranged in columns and rows.
a. Two dimensional
b. Three dimensional
c. Four dimensional
d. None of the above
8. __________ is used to manage databases in an RDBMS.
a. Structred Program
b. Structured Query Language (SQL)
c. Forms
d. Report
9. MySQL commands are divided into different categories_________.
a. DDL, DMC and DDP
b. DDL, DML and DPP
c. DDL, DML and DCL
d. None of the above
RDBMS Class 11 MCQ
10. _________ command is used to create databases and tables.
a. Create
b. Select
c. Insert
d. Modify
11. __________ statement is used to create a new database.
a. Select Database
b. Insert Database
c. Create Database
d. Modify Database
12. ___________ statement is used to create a new table.
a. Select Table
b. Insert Table
c. Create Table
d. Modify Table
13. The _________ statement is used to see the structure of a table.
a. Modify
b. Display
c. Describe
d. Select
14. ALTER TABLE statement is used to change the structure of a table.
a. Modify Table
b. Display Table
c. Alter Table
d. Select Table
RDBMS Class 11 MCQ
15. _______ command is used to delete tables.
a. Delete Table
b. Cut Table
c. Drop Table
d. None of the above
16. _________ statement is used to insert a new row in a table.
a. Insert into
b. Select into
c. Display into
d. Add into
17. Data stored in a single table is known as __________.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
18. 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
19. The _______ statement is used to fetch data from one or more database tables.
a. Insert statement
b. Select statement
c. Display statement
d. Add statement
RDBMS Class 11 MCQ
20. _________ means display all columns.
a. Insert *
b. Select *
c. Select %
d. Select @
21. The __________ clause is used to select specific rows.
a. What clause
b. When clause
c. Where clause
d. None of the above
22. We can change the structure of a table ie. add, remove or change its column(s) using the _________ statement.
a. Insert Table
b. Alter Table
c. Display Table
d. Add Table
23. The keyword _________ is used to eliminate redundant data from display.
a. Modify
b. Distinct
c. Describe
d. None of the above
24 Logical operators ________ are used to connect relational expressions in the WHERE clause.
a. OR
b. AND
c. NOT
d. All of the above
RDBMS Class 11 MCQ
25. Logical operator _______ is used to negate a condition.
a. OR
b. AND
c. NOT
d. All of the above
26. The _________ operator defines the range of values that the column values must fall into to make the condition true.
a. Multiplication
b. Modular
c. Equalto
d. Between
27. The __________ operator selects values that match any value in the given list of values.
a. Multiplication
b. Modular
c. IN
d. Between
28. Give the example of wild card character _______.
a. %
b. _
c. Both a) and b)
d. None of the above
29. The _________ symbol is used to represent any sequence of zero or more characters.
a. %
b. _
c. &
d. #
RDBMS Class 11 MCQ
30. The _________ symbol is used to represent a single character.
a. %
b. _
c. &
d. #
31. _________ represents a value that is unavailable, unassigned, unknown or inapplicable.
a. None
b. NULL
c. Empty
d. None of the above
32. The results of the SELECT statement can be displayed in the ascending or descending order of a single column or columns using _________ clause.
a. Non Order by
b. Modular
c. Order by
d. Where cause
33. ________ statement is used to modify existing data in a table.
a. Insert Table
b. Update Table
c. Display Table
d. Add Table
34. _________ statement is used to delete rows from a table.
a. Insert Statement
b. Alter Statement
c. Display Statement
d. Delete Statement
RDBMS Class 11 MCQ
35. 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
36. The unique field present in the table is called __________.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
37. 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
38. SQL stands for _____________.
a. Single Query Language
b. Structured Query Language
c. Semantic Query Language
d. None of the above
39. 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
RDBMS Class 11 MCQ
40. Which datatype is used for storing date and time both in the database.
a. Date
b. Time
c. Timestamp
d. None of the above
41. _____________ are used to identify which type of data we are going to store in the database.
a. Datatype
b. DataItem
c. DataValue
d. DataCat
42. By default the length of the numerical data type is _______.
a. 05
b. 10
c. 20
d. 30
43. ________ means to arrange the data in either ascending order or descending order.
a. Filter
b. Sorting
c. Arrangement
d. None of the above
44. In database, 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
RDBMS Class 11 MCQ
45. 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
46. The connection or association between two or more table is known as ____________
a. Connection
b. Relationship
c. Connector
d. None of the above
47. Relationships between tables help to __________.
a. Save time
b. Reduce data-entry errors
c. Summarize data from related tables
d. All of the above
48. 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>;
49. 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
50. A ______________ is a language that enables users to access and manipulate data in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above
Employability Skills Class 11 Notes
- Unit 1 : Communication Skills Class 11 Notes
- Unit 2 : Self-Management Skills Class 11 Notes
- Unit 3 : Information and Communication Technology Skills Class 11 Notes
- Unit 4 : Entrepreneurial Skills Class 11 Notes
- Unit 5 : Green Skills Class 11 Notes
Employability Skills Class 11 MCQ
- Unit 1 : Communication Skills Class 11 MCQ
- Unit 2 : Self-Management Skills Class 11 MCQ
- Unit 3 : Information and Communication Technology Skills Class 11 MCQ
- Unit 4 : Entrepreneurial Skills Class 11 MCQ
- Unit 5 : Green Skills Class 11 MCQ
Employability Skills Class 11 Questions and Answers
- Unit 1 : Communication Skills Class 11 Questions and Answers
- Unit 2 : Self-Management Skills – III
- Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
- Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
- Unit 5 : Green Skills Class 11 Questions and Answers
Information Technology Class 11 Notes
- Unit -1 : Computer Organization Class 11 Notes
- Unit -2 : Networking And Internet Class 11 Notes
- Unit-3 : Office Automation Tools Class 11 Notes
- Unit-4: RDBMS Class 11 Notes
- Unit-5: Fundamentals of Java Class 11 Notes
Information Technology Class 11 MCQ
- Unit -1 : Computer Organization Class 11 MCQ
- Unit -2 : Networking And Internet Class 11 MCQ
- Unit-3 : Office Automation Tools Class 11 MCQ
- Unit-4: RDBMS Class 11 MCQ
- Unit-5: Fundamentals of Java Class 11 MCQ