Database Query using SQL: Class 12 Previous Year Questions

Database Query using SQL questions asked in CBSE board exams

Repeated questions first. Open the free app to see each question as it appeared in the paper, with its marking scheme.

1. * 9 P a g e 17. State whether the following statement is True or False : 1 The INSTR(stringl, string2) function in SQL returns 0 if string2 is not present as a substring in string1.
   Board 20261 markvery short
2. State whether the following statement is True or False : In SQL, an aggregate function returns multiple values for each column on which it is applied.
   Board 20261 markvery short
3. * 24 P a g e 35. My Solutions Pvt. Ltd.     (software development)     (IT consulting firm)      (head office) Mysuru     Chennai      (regional office)   Mysuru …
   Board 20265 markscase-based
4. * 28 P a g e 37. (a)     SQL   : 5 I. /  (date/time expression) '2026-01-01 10:10:10'     (date part)      II. Customer   Cust_Name         (low…
   Board 20265 markscase-based
5. * 10 P a g e 21.  (A) :  name    NULL  (values) ,  SQL  SELECT COUNT(name) FROM students;   SELECT COUNT(*)FROM students;       1  (R) : COUNT(column_name) column  NON NULL  (values) …
   Board 20261 markMCQ
6. * 16 P a g e 31. (i)    , PRODUCTS    (table)     SQL  (statement)  : 3 Column Name Data Type Key PID Integer Primary Key PName Varchar of size 30 PCat Char of size 15 Price Decimal Number (ii) PRODUCTS …
   Board 20263 marksshort answer
7. * 19 P a g e 32. (a) Consider the following tables : 3 Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name (TName), Experience(Experience) and City (City) that they live in. TID TName Experience City 1 Kartik 5 Bhopal 2 Shahnaz 6 Nagpur 3 Rajendra 7…
   Board 20263 marksshort answer
8. Define the following terms with respect to RDBMS : 2 a. Domain b. Tuple
   Board 20262 marksshort answer
9. * 13 P a g e 26. Write SQL queries to perform the following : 2 (I) Display the month (in numeric form) of the date '2026-01-01'. (II) Display only the year part from the date '2026-01-01'.
   Board 20262 marksshort answer
10. What will be the result of the following SQL command ? 1 SELECT LENGTH ('Data Base'); (Note : There is single space between the words Data and Base.) (A) 7 (B) 8 (C) 9 (D) Error
    Board 20261 markMCQ
11. Which of the following is not an aggregate function in SQL ? (A) COUNT (*) (B) MIN() (C) LEFT() (D) AVG()
    Board 20251 markMCQ
12. State whether the following statement is True or False : The MoD() function in SQL returns the quotient of division operation between two numbers.
    Board 20251 markvery short
13. (a) An educational institution is maintaining a database for storing the details of courses being offered. The database includes a table COURSE with the following attributes : C_ID : Stores the unique ID for each course. C_NAME : Stores the course's name. INsT…
    Board 20255 markslong answer
14. Consider the string, "Informatics Practices". Write suitable SQL queries for the following : (i) To convert the entire string to uppercase. (ii) To display the total number of characters in the given string.
    Board 20252 marksshort answer
15. (i) ffa f·table· Customer f SQL statement ffg : (2+1) 3 Table:Customer Data Type Column Name Key Int CID Primary Key FName Varchar (20) LName Varchar(20) Age Int (ii)Table Customer LName 3q(descending order) RfaSQLquery1
    Board 20254 marksshort answer
16. (a) f (tables) : Table: STUDENTS S_ID NAME AGE CITY Rahul 20 Delhi Priya 22 Mumbai David 21 Delhi Neha 23 Bengaluru Khurshid 22 Delhi Table: GRADES S_ID SUBJECT GRADE Math English Math English Math fFafafaafm SQL queries fmfq· : (i) (iii)grades Page 18 of 32 3…
    Board 20254 marksshort answer
17. (a) fafafaa fm SQL query ffa : (i) STUDENTs table Score values 1 (ii) STUDENTS table Name (characters) (ii)·Trailing Spaces) STUDENTs table Name values 1 (iv) GRADES table Score (Score): (v) STUDE table100· FEE ··1 (b) fFafafaafm SQL queries fmfa : (i) (i) 456…
    Board 20254 marksshort answer
18. A small tech startup, is considering using open source software to develop their new project management tool. They are evaluating the benefits and potential challenges of adopting open source solutions. (i) Identify one key benefit of using open source softwar…
    Board 20252 marksshort answer
19. What will be the output of the following SQL command ? SELECT MONTHNAME('2024-08-02'); (A) 08 (B) 02 (C)February (D) August Temporary data files stored by websites in our computer can be used to track our online activities and also to personalize browsing expe…
    Board 20251 markMCQ
20. Which SQL function calculates ab ? (A) MOD () (B) POWER() RAISE() (C) (D) ROUND ()
    Board 20251 markMCQ

Practise all 76 Database Query using SQL questions with answers →

Other Class 12 Informatics Practices (IP) chapters

Frequently asked questions