CBSE Class 12 Information Practices HOTs Relational Database Management System

Refer to CBSE Class 12 Information Practices HOTs Relational Database Management System. We have provided exhaustive High Order Thinking Skills (HOTS) questions and answers for Class 12 Informatics Practices Relational Database Management System. Designed for the 2025-26 exam session, these expert-curated analytical questions help students master important concepts and stay aligned with the latest CBSE, NCERT, and KVS curriculum.

Relational Database Management System Class 12 Informatics Practices HOTS with Solutions

Practicing Class 12 Informatics Practices HOTS Questions is important for scoring high in Informatics Practices. Use the detailed answers provided below to improve your problem-solving speed and Class 12 exam readiness.

HOTS Questions and Answers for Class 12 Informatics Practices Relational Database Management System

Relational Database Management System
Oracle SQL Revision Tour
109 Convert the given relation in to 2 NF: 2
R(A,B,C,D,E) AB→C, AB→D, AB→E, B→C, A→D
 
110 Convert the following relation in to 3 NF: 2
R(A,B,C,D,E)  A→B, A→C,A→D,A→E, B→C, D→E
 
111 Assume that the following relation has possible two sets of candidate keys (Prof_code, Dept) and 4 (Prof_code, Hod). The functional dependency is shown as:
(Prof_code, Dept) →Hod, (Prof_code, Dept)→Ptime, (Prof_code, Hod)→Dept, (Prof_code, Hod)→Ptime  and  Dept→Hod
 
Answer the following questions based on above scenario:
a)   What is the amount of normalization already achieved.
b)   Give a situation for deletion anamoly in the above relation.
c)   Normalize the above relation in the next higher normal form.
 
112 It is required to create the following tables in Oracle database:
Chicken:   (CID INTEGER PRIMARY KEY, EID INTEGER FOREIGN KEY)
Egg: (EID INTEGER PRIMARY KEY, CID INTEGER FOREIGN KEY)
 
The structure of the table states that the primary key of Chicken is a foreign key in Egg and vise
versa.
Give a possible solution to create the two tables in oracle database.
 
113 Write the result of the follwoting queries: 4
a)   SELECT ROUND(150.79, -2) from DUAL
b)   SELECT LTRIM(‘NATASHA’, ‘NAT’) from DUAL
c)   SELECT ADD_MONTHS(’30-DEC-2007’, 2) FROM DUAL
d)   SELECT NEXT_DAY(SYSDATE, 'MONDAY') FROM DUAL
 CBSE_Class_12_information_Relational_Database_Management_System_2
a)   What level of normalization does the above table achieved?
b)   Write the situation when an insertion anamoly arises in the above table.
c)   Normailze the above table in to next higher normal form.
CBSE_Class_12_information_Relational_Database_Management_System_3 
TrainNo,StationFr→Train, TrainNo,StationFr→StationFr, TrainNo,StationFr→SationTo,
TrainNo,StationFr→WeekDay, TrainNo,StationFr→Superfast
TrainNo→Train, TrainNo→Superfast
 
a) What level of normalization the above table achieved?
b) Write the situation when an updation anamoly arises in the above table.
c) Normailze the above table in to next higher normal form.
 
117 Create a sequence studseq in Oracle to generate an autonumber field for the ID attribute of student. 4
The sequence starts from 100 with no upper limit and there is no repetition. The student table has the structure STUDENT(ID,NAME, DOB, CLASS). Insert a row in the student table using the sequence.
 
118 The EMPLOYEE table with structure EMPLOYEE(ID, NAME, DOB, DEPTNO, SAL, PANNO) 2 has the PANNO field with NOT NULL constraint. Change the structure of EMPLOYEE table so that NULL values may be accepted in the PANNO field.
Write the SQL queries asked below referring the following tables:
CBSE_Class_12_information_Relational_Database_Management_System_4
119 To count the number of students in each subject with an average stipend more than 350.
 
120 To display the name and stipend of all the students who are receiving highest stipend in each subject.
 
121 To display the name, subject and average of every student whose average is less than the maximum average in each subject.
 
122 To display the names of all the students who are having the same average.
 
123 To display the name subject and advisor for each student whose average is greater than the average of JOHN.
 
124 To display the subject and advisor that are not referenced in Student  table.
 
125 To display the student name and advisor all the students who are offering either Physics or Chemistry.
CBSE_Class_12_information_Relational_Database_Management_System_5
126  Display the department name of employee KING.
 
127  Display the department name of highest paid employee.
 
128  Display the department name of second highest paid employee.
 
129  Display the details of all the employees who work in the same department in which SCOTT works.
 
130  Display the details of highest paid employee in each department.
 
131  Display department names in DEPT table that are not referenced in EMP table.
 
132 Display the name and the job of all the employees who has same job but works for different departments.
 
133 Display the details of the employees who are drawing more than the average salary in each department.
 
134 Display the employee names and hire date of those employee who were hired during the same month.
 
135 Display the emp no and ename of all the employees who are also acting as managers.
 
136 Display the employee  name and location for all the employees who are managers in same department.
 
137 Display the employee details who is drawing the second highest salary in the emp table.
 
138 Display the employee names and their manager names in the employee tables.
 
139 Display the employee names and their hire dates who have joined prior to the joining date of their managers.
 
Given the following tables, write the queries for questions 140 to 150
CBSE_Class_12_information_Relational_Database_Management_System_6
140 To display the Cities from Supplier table those are not available in Product table. 2
 
141 To display the product names from Supplier table those are not available in the Product table. 2
 
142 To display the product names from product table whose quantity is more than their average 2 quantity.
 
143 To display the product names those are supplied by the same supplier. 2
 
144 To display the products whose total price (price*Qty) is the highest in the supplier table. 2
 
145 To display the product names those are supplied in minimum quantities for each group. 2
 
146 Create a table SUPPLIER_AUDIT with the details of all the suppliers who have registered supplies more than the average supplies. (Supply= qty*price)
 
147 What is the difference between the two operations stated below: 2
DELETE FROM SUPPLIER;
TRUNCATE TABLE SUPPLIER;
 
148 As it is seen from the Supplier table there is no supplier for S9. Write a query to make the 2
SNAME for S9 to be HLL.
 
149 To display the product names and supplier names who are either operating in DELHI, 2
MUMBAI or KOLKATA
 
150 To display the number of product names for each supplier with more than one supplier.
 
151 To display the details of all the suppliers who are not supplying at KOLKATA in the 2 descending 
All Chapters
CBSE Class 12 Information Practices HOTs
Business Computing
CBSE Class 12 Information Practices HOTs Business Computing
Oracle SQL
CBSE Class 12 Information Practices HOTs Oracle SQL PL
Programming Visual Basic
CBSE Class 12 Information Practices HOTs Programming Visual Basic
Relational Database Management System
CBSE Class 12 Information Practices HOTs Relational Database Management System
Visual Basic
CBSE Class 12 Information Practices HOTs Visual Basic

More free study material for Informatics Practices

HOTS for Relational Database Management System Informatics Practices Class 12

Students can now practice Higher Order Thinking Skills (HOTS) questions for Relational Database Management System to prepare for their upcoming school exams. This study material follows the latest syllabus for Class 12 Informatics Practices released by CBSE. These solved questions will help you to understand about each topic and also answer difficult questions in your Informatics Practices test.

NCERT Based Analytical Questions for Relational Database Management System

Our expert teachers have created these Informatics Practices HOTS by referring to the official NCERT book for Class 12. These solved exercises are great for students who want to become experts in all important topics of the chapter. After attempting these challenging questions should also check their work with our teacher prepared solutions. For a complete understanding, you can also refer to our NCERT solutions for Class 12 Informatics Practices available on our website.

Master Informatics Practices for Better Marks

Regular practice of Class 12 HOTS will give you a stronger understanding of all concepts and also help you get more marks in your exams. We have also provided a variety of MCQ questions within these sets to help you easily cover all parts of the chapter. After solving these you should try our online Informatics Practices MCQ Test to check your speed. All the study resources on studiestoday.com are free and updated for the current academic year.

Where can I download the latest PDF for CBSE Class 12 Information Practices HOTs Relational Database Management System?

You can download the teacher-verified PDF for CBSE Class 12 Information Practices HOTs Relational Database Management System from StudiesToday.com. These questions have been prepared for Class 12 Informatics Practices to help students learn high-level application and analytical skills required for the 2025-26 exams.

Why are HOTS questions important for the 2026 CBSE exam pattern?

In the 2026 pattern, 50% of the marks are for competency-based questions. Our CBSE Class 12 Information Practices HOTs Relational Database Management System are to apply basic theory to real-world to help Class 12 students to solve case studies and assertion-reasoning questions in Informatics Practices.

How do CBSE Class 12 Information Practices HOTs Relational Database Management System differ from regular textbook questions?

Unlike direct questions that test memory, CBSE Class 12 Information Practices HOTs Relational Database Management System require out-of-the-box thinking as Class 12 Informatics Practices HOTS questions focus on understanding data and identifying logical errors.

What is the best way to solve Informatics Practices HOTS for Class 12?

After reading all conceots in Informatics Practices, practice CBSE Class 12 Information Practices HOTs Relational Database Management System by breaking down the problem into smaller logical steps.

Are solutions provided for Class 12 Informatics Practices HOTS questions?

Yes, we provide detailed, step-by-step solutions for CBSE Class 12 Information Practices HOTs Relational Database Management System. These solutions highlight the analytical reasoning and logical steps to help students prepare as per CBSE marking scheme.