Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: The Active Cell is the currently selected cell in a spreadsheet, identified by its column letter and row number.
682
A relation can have more than one key (candidate key), but only one is chosen as the primary key.
TRUE FALSE
Medium
a.TRUE
b.FALSE
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
TRUE
Explanation: A relation may have multiple candidate keys (e.g., Aadhar_number, PAN, Voter_ID in a PERSON relation), but only one is designated the primary key.
683
Which wrapper class corresponds to the primitive data type 'boolean'?
MCQ
Easy
a.Bool
b.Boolean
c.Bit
d.Flag
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Boolean
Explanation: The Boolean class is the wrapper class for the boolean primitive data type.
684
What is the AutoFill feature used for in Calc?
SHORT
Easy
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: AutoFill is used to automatically generate data in a range of cells based on a defined series (e.g., continuing a sequence of numbers or dates, or copying a formula relatively across cells).
685
The set of all attributes of a relation is always a valid superkey.
TRUE FALSE
Medium
a.TRUE
b.FALSE
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
TRUE
Explanation: The combination of all attributes in a relation is always a superkey by definition, since no two tuples can have identical values across all attributes.
686
Which wrapper class corresponds to the primitive data type 'char'?
MCQ
Easy
a.Char
b.Character
c.String
d.Symbol
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Character
Explanation: The Character class is the wrapper class for the char primitive data type.
687
Explain the steps to filter data using Standard Filter in Calc to display male students having more than 75 marks (using AND).
LONG
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: Step 1: Select the data range. Step 2: Go to the Data menu and click Filter -> Standard Filter, which opens a dialog box. Step 3: Add the criteria Gender = 'Male' AND Marks > 75 in the dialog box. Step 4: Click OK. The AND operator ensures that only rows satisfying both criteria are displayed.
688
Referential integrity requires that the foreign key attribute and referenced primary key attribute must have the same name.
TRUE FALSE
Medium
a.TRUE
b.FALSE
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
FALSE
Explanation: It is NOT necessary for the foreign key to have the same name as the referenced primary key attribute; only the domain must match.
689
Which method of the Integer wrapper class allows access to the primitive int value it holds?
MCQ
Medium
a.getInt()
b.intValue()
c.toInt()
d.valueOf()
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
intValue()
Explanation: The intValue() method returns the primitive int value held by an Integer wrapper object.
690
List the steps required to insert a chart in Calc, and name any three types of charts available.
LONG
Medium
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Explanation: Step 1: Select the data to be included in the chart. Step 2: Go to Insert menu and select Chart (or click the Chart icon on the Standard toolbar). Step 3: The Chart Wizard dialog box opens allowing selection of chart type, data range, data series, and chart elements. Step 4: Select the desired chart type and click Finish. Calc offers a choice of 10 chart types including Column chart, Bar chart, Pie chart, Line chart, and Scatter chart.
691
Define Superkey, Key, Candidate Key and Primary Key in one or two lines each.
SHORT
Medium
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: Superkey: a set of attributes for which no two tuples have the same combination of values. Key (Candidate Key): a minimal superkey — removing any attribute would cause it to lose uniqueness. Candidate Key: any such minimal key of a relation (a relation may have several). Primary Key: the candidate key chosen to uniquely identify tuples in the relation.
692
A parameterless wrapper class cannot convert a String into its corresponding numeric value.
TRUE FALSE
Medium
a.TRUE
b.FALSE
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
FALSE
Explanation: Wrapper classes CAN convert Strings to numeric values, e.g., Integer.parseInt("345") converts the String "345" to the int 345.
693
Which tab in OpenOffice Impress is used to check the spelling of content in a presentation?
MCQ
Easy
a.Format
b.Tools
c.Insert
d.Slide Show
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Tools
Explanation: The Tools tab contains the Spelling command to check the spelling of presentation content.
694
Explain the five types of constraints in the relational model with a suitable example for each.
LONG
Hard
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: Domain Constraint: attribute values must come from the attribute's domain (e.g., Employee_ID must be a 4-digit number). Key Constraint: relates to superkeys, keys, candidate keys, and primary keys ensuring uniqueness of tuples. Null Value Constraint: certain attributes (e.g., Name) may be constrained to NOT NULL. Entity Integrity Constraint: the primary key of a relation cannot be NULL, since it must uniquely identify each tuple. Referential Integrity Constraint: a foreign key in one relation (R1) must either match a primary key value in the referenced relation (R2) or be NULL, ensuring consistency between related relations (e.g., Dept_No in Teacher referencing Dept_ID in Department).
695
Thread priority levels in Java can range from 1 to 10, set using the setPriority() method.
TRUE FALSE
Medium
a.TRUE
b.FALSE
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
TRUE
Explanation: The Thread class's setPriority() method allows setting a thread's priority level, ranging from 1 to 10.
696
Which tab contains commands like Slide Show Settings, Custom Animation, and Slide Transition?
MCQ
Medium
a.View
b.Format
c.Slide Show
d.Window
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Slide Show
Explanation: The Slide Show tab contains commands used during presentation of the slide show, such as Slide Show Settings, Custom Animation, and Slide Transition.
697
SQL comprises which two sub-languages?
MCQ
Easy
a.HTML and CSS
b.DDL and DML
c.GUI and CLI
d.JSON and XML
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
DDL and DML
Explanation: SQL comprises a Data Definition Language (DDL) used to define structure/constraints, and a Data Manipulation Language (DML) used to insert, modify and delete data.
698
How can threads be created in Java? Briefly name the two approaches.
SHORT
Medium
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Explanation: Threads can be created in two ways: (1) by creating a class that extends the Thread class and overriding its run() method, or (2) by creating a class that implements the Runnable interface and overriding its run() method, then passing an instance of it to a Thread object.
699
Which term refers to the visual pattern applied when moving from one slide to the next (e.g., wheel, diamond)?
MCQ
Medium
a.Slide Animation
b.Slide Transition
c.Slide Master
d.Slide Layout
Information Technology (802) · Class 11·Sep 26, 2026
Show answer
Slide Transition
Explanation: Slide Transition is the pattern shown when one slide changes to the next; Slide Animation applies to elements within a single slide.
700
In SQL terminology, what do relation, tuple, and attribute correspond to respectively?
MCQ
Easy
a.Table, row, column
b.Column, row, table
c.Row, column, table
d.Table, column, row
Information Technology (802) · Class 12·Sep 26, 2026
Show answer
Table, row, column
Explanation: SQL uses the terms table, row, and column for the relational model terms relation, tuple, and attribute respectively.