Database & SQL: Class 12 Previous Year Questions

Database & 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. * 7 P a g e 13. Which of the following SQL command can change the degree of the existing relation ? 1 (A) DROP TABLE (B) ALTER TABLE (C) UPDATE…SET (D) DELETE
   Board 20261 markMCQ
2. * 25 P a g e 35. Peter has created a table named Account in MySQL database, SCHOOL, having following structure : 4  Stud_id – integer  Sname – string  Class – string  Fees – float Help him in writing a Python program to display records of those students wh…
   Board 20264 marksshort answer
3. MySQL     (relation)  2  (tuples)  3  (attributes)    2 Attributes   (delete)    4 tuples       (relation)   (cardinality)   ? 1 (A) 4 (B) 5 (C) 6 (D)
   Board 20261 markMCQ
4. * 20 P a g e 32.   STOCK     (table)            data       (set)   Table       (data)     table      : 4  1 = 4 (a)   …
   Board 20264 marksshort answer
5. * 22 P a g e 34.        (Finance House)                 (tables) : CUSTOMERS  LOANS      tables    (sample data)     : 4  1 = 4 Table:…
   Board 20264 marksshort answer
6. * 14 P a g e 27.        (Production Manager)     (mineral water)                   (table)            …
   Board 20262 marksshort answer
7. A table has two candidate keys, one of which is chosen as the primary key. How many alternate keys does this table have ? 1 (A) 0 (B) 1 (C) 2 (D)
   Board 20261 markMCQ
8.  query  output   ? 1 SELECT MACHINE_ID, MACHINE_NAME FROM INVENTORY WHERE QUANTITY <= 100; (A)  (INVENTORY)  (table)      (quantity) 100     (B)  (INVENTORY)   100    (quantity)  …
   Board 20261 markMCQ
9. * 8 P a g e 17. Computer Networks   ,      RJ 45      ? 1 (A) Radio Jockey 45 (B) Registered Jockey 45 (C) Radio Jack 45 (D) Registered Jack 45 91* 9 P a g e 14. What will be the output of the query ? 1 SELECT MACHI…
   Board 20261 markMCQ
10. * 11 P a g e 21. Assertion (A) : The PRIMARY KEY constraint in SQL ensures that each value in the column(s) is unique and cannot be NULL. 1 Reason (R) : Candidate keys are not eligible to become a primary key.  –  (7  2 = 14)
    Board 20261 markAssertion-Reason
11. (a) (b) PPP PPP· 91 Page 14 of 32 26. The code given below accepts N as an integer argument and returns the sum of all integers from 1 to N. Observe the following code carefully and rewrite it after removing all syntax and logical errors. Underline all the cor…
    Board 20253 marksshort answer
12. 3 H f (,.·) (Creative Art Gallery (CAG) 3 (IT)(Sculptures· mgfd1gfa(Art creations) m(Artists) (data): (table) Articles Artists 1 4×1 = 4 Table : Articles Code A Code DOC Article Price A0001 Painting 2018-10-19 PL001 20000 SC028 A0004 Sculpture 2021-01-15 16000…
    Board 20255 markslong answer
13. CINEMA database THEATRE fMT (table) f : 35. Field Type. Th_ID char(5) Name varchar(15) city varchar(15) Location i varchar(15) ISeats iint Delete_Theatre(·function f3qaf (user) Th_ID (Python-Database connectivity): Host : localhost, User : root, Password : Ex2…
    Board 20255 markslong answer
14. (construction site)(data) WORKER (table)WID·WNAME·WAGE·HOURS, TPE·TEdata WID WNAME WAGE HOURS SITEID 200 w01 Ahmed J 1500 Unskilled 103 w11 Naveen 520 100 Skilled 101 w02 Jacob B 780 95 Unskilled 101 w15 Nihal 560 110 Semiskilled NULL W10 1200 130 Anju skiiled…
    Board 20254 marksshort answer
15. l. Assertion (A) : We can retrieve records from more than one table in MYSQL. Reason (R) : Foreign key is used to establish a relationship between two tables. 91 Page 1l of 32 (7 × 2 = 14)
    Board 20252 marksAssertion-Reason
16. (table) 3(constraint) a (duplicate values) faf (insertion) ? (A) UNIQUE (B) DISTINCT (C) NOT NULL (D) HAVING
    Board 20251 markMCQ
17. MYSQ(value) (Quotation marks) (A) DATE (B) VARCHAR (C) FLOAT (D) CHAR
    Board 20251 markMCQ
18. (True) (False) : f(table)6 (rows) 3(columns)f 5 2· ·Cartesian product) 30 fa (rows) 3 5 im (columns)
    Board 20251 markvery short
19. o. Select the correct output of the following code : event="G20 Presidency@2023" L=event.split(' ') print(L[::-2]) (a) 'G201 (b) ['Presidency@2023'] (c) ['G20'] (d) 'Presidency@2023' 2191
    Board 20241 markMCQ
20. Observe the given Python code carefully : a=20 def convert(a) : b=20 a=a+b convert(10) print(a) Select the correct output from the given options : 10 (b) (a) 20 (c) 30 (d) Error
    Board 20241 markMCQ

Practise all 63 Database & SQL questions with answers →

Other Class 12 Computer Science (CS) chapters

Frequently asked questions