Questions Library

Class 11

Information Technology (802)

443 questions available

Refine

All questions

443 results
241

What will be the result of the Calc formula =5*5-5 ?

MCQ Medium
a. 20
b. 40
c. 19
d. 21
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
20
Explanation: Following operator precedence (parentheses, then multiplication/division, then addition/subtraction, left to right), =5*5-5 evaluates to 20.
242

Differentiate between Primary Key, Candidate Key, Alternate Key, and Foreign Key with examples.

LONG Hard
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Candidate Key: any column/set of columns that can uniquely identify a row (e.g., RollNo and Admission_No in a student table). Primary Key: the candidate key chosen to uniquely identify rows in the table (e.g., Admission_No). Alternate Key: candidate key(s) not chosen as primary key (e.g., RollNo, if Admission_No is the primary key). Foreign Key: a primary key of one table used as a column in another table to establish a relationship (e.g., DeptID in the Employee table referencing DeptID, the primary key of the Department table).
243

What will be the result of the Calc formula =5*(5-5) ?

MCQ Medium
a. 0
b. 1
c. 2
d. 3
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
0
Explanation: Following operator precedence (parentheses, then multiplication/division, then addition/subtraction, left to right), =5*(5-5) evaluates to 0.
244

MySQL is pronounced as:

MCQ Easy
a. My Sequel
b. My Squeal
c. My Sql
d. My System
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
My Sequel
Explanation: MySQL is pronounced as 'My Sequel'.
245

What will be the result of the Calc formula =100/10/2 ?

MCQ Medium
a. 5
b. 10
c. 4
d. 6
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
5
Explanation: Following operator precedence (parentheses, then multiplication/division, then addition/subtraction, left to right), =100/10/2 evaluates to 5.
246

Which SQL command category permits creation or deletion of database tables and defines constraints?

MCQ Easy
a. DML
b. DDL
c. DCL
d. TCL
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
DDL
Explanation: DDL (Data Definition Language) commands like CREATE TABLE, ALTER TABLE, and DROP TABLE define/modify database structure.
247

Expand the abbreviation: ALU

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Arithmetic Logic Unit
248

Which MySQL data type is used for a fixed-length string, right-padded with spaces?

MCQ Medium
a. VARCHAR(size)
b. CHAR(size)
c. TEXT
d. INT
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
CHAR(size)
Explanation: CHAR(size) is a fixed-length string data type, right-padded with spaces to the specified length.
249

Expand the abbreviation: CPU

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Central Processing Unit
250

Which command is used to see the structure of a table, including its columns, types, and keys?

MCQ Easy
a. SHOW TABLES
b. DESCRIBE <table>
c. SELECT * FROM <table>
d. USE <table>
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
DESCRIBE <table>
Explanation: The DESCRIBE (or DESC) statement displays the structure of a table, including column names, data types, and keys.
251

Expand the abbreviation: CU

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Control Unit
252

Which constraint ensures that NULL and duplicate values are NOT accepted in a column?

MCQ Medium
a. NOT NULL
b. UNIQUE
c. PRIMARY KEY
d. FOREIGN KEY
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
PRIMARY KEY
Explanation: PRIMARY KEY constraint ensures a column has no NULLs and no duplicate values, uniquely identifying each row.
253

Expand the abbreviation: RAM

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Random Access Memory
254

Which statement correctly creates a new database named 'School'?

MCQ Easy
a. CREATE TABLE School;
b. CREATE DATABASE School;
c. USE School;
d. NEW DATABASE School;
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
CREATE DATABASE School;
Explanation: CREATE DATABASE <name>; is the correct syntax to create a new database.
255

Expand the abbreviation: EEPROM

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Electrically Erasable Programmable Read Only Memory
256

Which command is used to add a new column to an existing table?

MCQ Medium
a. UPDATE TABLE ... ADD
b. ALTER TABLE ... ADD
c. MODIFY TABLE ... ADD
d. INSERT TABLE ... ADD
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
ALTER TABLE ... ADD
Explanation: ALTER TABLE <table_name> ADD <column_name> [datatype]; is used to add a new column to an existing table.
257

Expand the abbreviation: ROM

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Read Only Memory
258

Which command permanently removes a table's structure and data from the database?

MCQ Easy
a. DELETE TABLE
b. TRUNCATE
c. DROP TABLE
d. REMOVE TABLE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
DROP TABLE
Explanation: DROP TABLE <tablename>; deletes the table's structure as well as its data from the database.
259

Expand the abbreviation: DRAM

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Dynamic Random Access Memory
260

Table names and column names in MySQL are case sensitive.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: Table names and column names are NOT case sensitive in MySQL; e.g., STUDENT and student are treated the same.

Related resources

More for Information Technology (802)
Question papers Notes Practice quiz

Latest questions

Convert: 7 GB = ______ MB.
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
Which characteristic of a computer refers to producing wrong output due to wrong input, commonly called GIGO?
Information Technology (802) Sep 26, 2026
Convert: 3 TB = ______ GB.
Information Technology (802) Sep 26, 2026
Which of the following is an example of secondary storage?
Information Technology (802) Sep 26, 2026