Questions Library

A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Class 10 Class 11 Class 12

Refine

All questions

794 results
761

Given int a=19, b=6; what is the value of a%b?

MCQ Easy
a. 1
b. 3
c. 114
d. 13
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
1
Explanation: The % operator returns the remainder of a divided by b. 19 % 6 = 1.
762

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.
763

MySQL server 5.6.20 fully supports the RESTRICT and CASCADE options for the DROP TABLE command.

TRUE FALSE Hard
a. TRUE
b. FALSE
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
FALSE
Explanation: MySQL server 5.6.20 does NOT support RESTRICT and CASCADE options (though they are permitted syntactically for porting ease); it simply won't allow dropping a table referenced elsewhere.
764

Given int a=15, b=4; what is the value of a/b using integer division?

MCQ Medium
a. 3
b. 3.75
c. 19
d. 4
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
3
Explanation: Integer division truncates the fractional part. 15 / 4 = 3.
765

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.
766

The referenced table (containing the primary key) must be created before the referencing table containing the foreign key.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
TRUE
Explanation: The referenced table must be created first, since the foreign key clause in the referencing table needs to point to an existing primary key.
767

Given int a=22, b=7; what is the value of a/b using integer division?

MCQ Medium
a. 3
b. 3.14
c. 1
d. 29
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
3
Explanation: Integer division truncates the fractional part. 22 / 7 = 3.
768

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.
769

A primary key can be dropped using ALTER TABLE even if it is the only primary key of the table, without any error.

TRUE FALSE Hard
a. TRUE
b. FALSE
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
FALSE
Explanation: Attempting to drop the only primary key of a table using ALTER TABLE will result in an error.
770

Given int a=9, b=5; what is the value of a/b using integer division?

MCQ Medium
a. 1
b. 1.8
c. 4
d. 14
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
1
Explanation: Integer division truncates the fractional part. 9 / 5 = 1.
771

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.
772

Write the SQL command to create a database named 'School'.

SHORT Easy
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Explanation: CREATE DATABASE School;
773

Given int a=31, b=6; what is the value of a/b using integer division?

MCQ Medium
a. 5
b. 5.17
c. 1
d. 37
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
5
Explanation: Integer division truncates the fractional part. 31 / 6 = 5.
774

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.
775

Write the SQL command to view the structure/description of the table 'Teacher'.

SHORT Easy
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Explanation: DESC Teacher; (or DESCRIBE Teacher;)
776

Given int a=18, b=4; what is the value of a/b using integer division?

MCQ Medium
a. 4
b. 4.5
c. 2
d. 22
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
4
Explanation: Integer division truncates the fractional part. 18 / 4 = 4.
777

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.
778

Write the CREATE TABLE command for a Department table with Dept_ID (INTEGER, Primary Key) and Dept_Name (VARCHAR(30), NOT NULL).

SHORT Medium
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
Explanation: CREATE TABLE Department (Dept_ID INTEGER PRIMARY KEY, Dept_Name VARCHAR(30) NOT NULL);
779

Given int a=50, b=7; what is the value of a/b using integer division?

MCQ Medium
a. 7
b. 7.14
c. 1
d. 57
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
7
Explanation: Integer division truncates the fractional part. 50 / 7 = 7.
780

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.

Related resources

Latest questions

Convert: 7 GB = ______ MB.
Information Technology (802) Sep 26, 2026
Which command is used to insert a new tuple into a relation?
Information Technology (802) Sep 26, 2026
Evaluate the Java relational expression: 3 < 1
Information Technology (802) Sep 26, 2026
The term 'Computer' is derived from which word?
Information Technology (802) Sep 26, 2026
Convert: 2 TB = ______ GB.
Information Technology (802) Sep 26, 2026
If an attribute value is not explicitly specified in an INSERT command and it has no DEFAULT value defined, what value is used?
Information Technology (802) Sep 26, 2026