Class 11

Information Technology (802)

443 questions available

Refine

All questions

443 results
221

What will be the result of the Calc formula =2+3*4-1 ?

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

A software that enables users to create and maintain a database is called:

MCQ Easy
a. Operating System
b. DBMS
c. Compiler
d. Spreadsheet
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
DBMS
Explanation: A Database Management System (DBMS) is software that enables users to create and maintain databases.
223

What will be the result of the Calc formula =(4+3)*2 ?

MCQ Medium
a. 14
b. 16
c. 28
d. 13
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
14
Explanation: Following operator precedence (parentheses, then multiplication/division, then addition/subtraction, left to right), =(4+3)*2 evaluates to 14.
224

A database that stores data in separate related tables connected via a common column is called a:

MCQ Easy
a. Flat file database
b. Hierarchical database
c. Relational database
d. Object database
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Relational database
Explanation: A Relational database stores data in separate tables that are related through the use of a common column.
225

What will be the result of the Calc formula =(10-2)*3 ?

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

In relational database terminology, the horizontal subset of a table is known as a:

MCQ Easy
a. Field/Column
b. Row/Tuple
c. Domain
d. Key
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Row/Tuple
Explanation: A Record (Row/Tuple) is the horizontal subset of a table representing one entity's data.
227

What will be the result of the Calc formula =20/4+1 ?

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

A column or group of columns used to uniquely identify each row of a table is called its:

MCQ Easy
a. Foreign Key
b. Alternate Key
c. Primary Key
d. Domain
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Primary Key
Explanation: The Primary Key uniquely identifies each row/record of a relation.
229

What will be the result of the Calc formula =20/(4+1) ?

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

Which key of a table, when used in another (related) table, is called a Foreign Key?

MCQ Medium
a. Candidate Key
b. Primary Key of the base table
c. Alternate Key
d. Composite Key only
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Primary Key of the base table
Explanation: A Foreign Key is the Primary Key of one (base) table when used as a column in another related table.
231

What will be the result of the Calc formula =6*2-3*1 ?

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

Candidate keys of a table that are NOT selected as the primary key are called:

MCQ Medium
a. Foreign Keys
b. Alternate Keys
c. Composite Keys
d. Domains
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Alternate Keys
Explanation: Candidate keys not chosen as the primary key are known as Alternate Keys.
233

What will be the result of the Calc formula =(6-2)*(3+1) ?

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

The pool/collection of possible values from which a column's values are derived is called its:

MCQ Medium
a. Domain
b. Attribute
c. Tuple
d. Schema
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Domain
Explanation: Domain is the set of possible values from which the value for a column is derived.
235

What will be the result of the Calc formula =15-3*2+1 ?

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

A table can have more than one candidate key but only one primary key.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: A table may have multiple candidate keys, but only one of them is designated as the primary key.
237

What will be the result of the Calc formula =8+12/4 ?

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

The primary key column and the foreign key column referencing it must have the same data type and size.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: For referential integrity, the primary key and its corresponding foreign key column must match in data type and size.
239

What will be the result of the Calc formula =(8+12)/4 ?

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), =(8+12)/4 evaluates to 5.
240

Name two benefits of using a DBMS.

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Redundancy can be controlled; inconsistency can be avoided (also: data can be shared, and security restrictions can be applied).