CBSE Class 12 Information Practices HOTs Oracle SQL PL

CBSE Class 12 Information Practices HOTs Questions Database for chapter Oracle SQL PL. Based on CBSE and NCERT guidelines. The students should practice these HOTs Questions to gain perfection which will help him to get more marks in CBSE examination. Based on CBSE and NCERT guidelines. Based on the same pattern as released by CBSE every year. CBSE releases HOTs Questions every year. These papers are released prior to the CBSE board examinations so that students can do practice. database of 1 marks, 2 marks, 3 marks and 5 marks questions

Oracle SQL Revision

166 Re-write the following using a join query:

SELECT ename FROM emp WHERE deptno =

(SELECT deptno FROM emp WHERE ename = 'JONES');2

167 Re-write the following using NOT EXISTS clause:

SELECT dept.dname FROM dept

WHERE dept.deptno NOT IN

(

SELECT deptno

FROM emp

WHERE deptno IS NOT NULL

);2

168 What will be the output of the following query on EMP table:

SELECT *

FROM emp

WHERE (sal, mgr) =

(SELECT sal, mgr FROM emp

WHERE sal = (SELECT MIN(sal) FROM EMP

WHERE sal > (SELECT MIN(sal) FROM emp)));2

169 What will be the output of the following query:

SELECT * FROM emp

WHERE empno IN (SELECT empno FROM emp

WHERE sal = (SELECT MAX(sal) FROM EMP

WHERE sal < (SELECT MAX(sal) FROM emp)));2

Please refer to link below to download pdf file of CBSE Class 12 Information Practices HOTs for Oracle SQL PL

Tags: 

 


Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Applied Mathematics Introduced by CBSE as Elective for Class 11 and Class 12

Mathematics Syllabus Revised by CBSE at the Senior Secondary Level! The Central Board of Secondary Education (CBSE) to offer 'Applied Mathematics' as an Elective for XI and XII standard students. The elective subject, Applied Mathematics, is focused at evolving an...

Class 12 Board Exams Datesheet Announced

CBSE has announced the datesheet of the remaining class 12 board exams, see below:  

CBSE Recommends Arogya Setu App, Writes To School Principals

Written recommendation from CBSE to school principals for initiating the Arogya Setu App! New Delhi:  The Central Board of Secondary Education has advised all school principals through a written communication recommending the “Arogya Setu App” and Health Ministry's...

Class 10 Board Exams to be held

The CBSE board has announced that there is no change in the decision of conducting the CBSE board exams for the 29 subjects, which were canceled due to coronavirus crisis. So when the lockdown gets relaxed completely, the board will conduct the exams for the students,...

CBSE Board Exams in July Press Release

CBSE has released press note for the dates for the CBSE Board exams for Class 10. CBSE said “With regards to conduct of Class X examinations several queries are being received by the CBSE. In this context, it is once again reiterated that remaining examinations of...

Important announcement regarding rescheduling of Class 10 and 12 Board Exams

CBSE Board Exams 2020: Here's when Board will organize the CBSE Class X and Class XII Board Exams. All the candidates appearing for CBSE Standard X and Standard XII Board Exams 2020 can cross check the essential notice released by the board concerning rearrangement of...

×
Studies Today