Which SQL statement is used to delete data (rows) from a table (from the textbook's MCQ exercise)?
MCQ
Easy
a.DELETE
b.DROP
c.TRUNCATE
d.REMOVE
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
DELETE
Explanation: DELETE is the correct SQL statement used to remove rows of data from a table.
422
Fill in the blank: ___________ command is used to add records in a relation.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: INSERT (INSERT INTO command).
423
Fill in the blank: SELECT is a type of ___________ command.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: DML (Data Manipulation Language).
424
Fill in the blank: BETWEEN operator includes __________ and __________ values given in the range.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: The lower bound value and the upper bound value (i.e., both boundary/extreme values are included).
425
Write SQL statements for the following operations on table GYM(PrCode, PrName, UnitPrice, Manufacturer): (a) Display details of all products with unit price less than Rs. 20000. (b) Add a new row for product 'P106', 'Vibro Exerciser', 23000, manufacturer 'Avon Fitness'. (c) Display details of all products with manufacturer name starting with 'A'.
LONG
Hard
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: (a) SELECT * FROM GYM WHERE UnitPrice < 20000; (b) INSERT INTO GYM VALUES('P106','Vibro Exerciser',23000,'Avon Fitness'); (c) SELECT * FROM GYM WHERE Manufacturer LIKE 'A%';
426
In a database, table Cabinet has a column where the data entry operator is unable to enter NULL values, and also unable to enter duplicate values. What is the likely reason?
LONG
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: This behaviour indicates that the column has been set as the PRIMARY KEY of the table (or has both a NOT NULL and a UNIQUE constraint applied), since a primary key column does not accept NULL values and does not accept duplicate values.
427
Convert: 2 KB = ______ Bytes.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 2 KB = 2 x 1024 Bytes = 2048 Bytes.
428
Convert: 3 KB = ______ Bytes.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 3 KB = 3 x 1024 Bytes = 3072 Bytes.
429
Convert: 4 KB = ______ Bytes.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 4 KB = 4 x 1024 Bytes = 4096 Bytes.
430
Convert: 5 KB = ______ Bytes.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 5 KB = 5 x 1024 Bytes = 5120 Bytes.
431
Convert: 6 KB = ______ Bytes.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 6 KB = 6 x 1024 Bytes = 6144 Bytes.
432
Convert: 7 KB = ______ Bytes.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 7 KB = 7 x 1024 Bytes = 7168 Bytes.
433
Convert: 2 MB = ______ KB.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 2 MB = 2 x 1024 KB = 2048 KB.
434
Convert: 3 MB = ______ KB.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 3 MB = 3 x 1024 KB = 3072 KB.
435
Convert: 4 MB = ______ KB.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 4 MB = 4 x 1024 KB = 4096 KB.
436
Convert: 5 MB = ______ KB.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 5 MB = 5 x 1024 KB = 5120 KB.
437
Convert: 6 MB = ______ KB.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 6 MB = 6 x 1024 KB = 6144 KB.
438
Convert: 7 MB = ______ KB.
SHORT
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 7 MB = 7 x 1024 KB = 7168 KB.
439
Convert: 2 GB = ______ MB.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: 2 GB = 2 x 1024 MB = 2048 MB.
440
Convert: 3 GB = ______ MB.
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026