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

Class

Subject

Type

All questions

794 results

621

What is the difference between Email and Chat?

SHORT Medium

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

Explanation: Email allows asynchronous, written communication where a message is sent and can be read by the recipient later, often with attachments; Chat is typically a real-time, synchronous exchange of short text messages between users who are online at the same time.

622

Which type of DBMS user is responsible for authorizing access, monitoring use, and acquiring software/hardware resources?

MCQ Easy

a. End User

b. Database Administrator (DBA)

c. Application Programmer

d. System Analyst

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Database Administrator (DBA)

Explanation: The Database Administrator (DBA) administers the database and DBMS, authorizes access, and acquires resources.

623

Which three parameters are typically required to establish a database connection via getConnection()?

MCQ Medium

a. Table name, column name, data type

b. URL of the database, username, and password

c. Class name, method name, object name

d. Query, result, exception

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

URL of the database, username, and password

Explanation: getConnection() requires the URL of the database, a username, and a password to connect.

624

Which tab in OpenOffice Writer contains the command to check spelling and grammar of a document?

MCQ Easy

a. Edit

b. View

c. Tools

d. Table

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

Tools

Explanation: The Tools tab contains the 'Spelling and Grammar' command to check the document for errors.

625

Which type of DBMS user determines the requirements of end users and develops specifications to meet them?

MCQ Medium

a. End User

b. DBA

c. Application Programmer

d. System Analyst

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

System Analyst

Explanation: The System Analyst determines end-user requirements and develops specifications, playing a major role in database design.

626

Which method of the Connection object returns a Statement object used for sending SQL statements to the database?

MCQ Medium

a. executeQuery()

b. createStatement()

c. getConnection()

d. next()

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

createStatement()

Explanation: The createStatement() method of the Connection object returns a Statement object used to send SQL statements.

627

Which command is used to convert selected text into a table (or vice versa) in OpenOffice Writer?

MCQ Medium

a. Insert > Table

b. Table > Convert

c. Format > Table

d. Edit > Paste Special

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

Table > Convert

Explanation: Table > Convert provides options to convert Text to Table or Table to Text.

628

Which of these is an advantage of using the DBMS approach?

MCQ Easy

a. Increased data redundancy

b. Reduction in redundancy and improved consistency

c. Higher dependency on computer specialists

d. Reduced data availability

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Reduction in redundancy and improved consistency

Explanation: The DBMS approach reduces redundancy (central repository) and improves consistency since there's a single copy of data accessed by all users.

629

Which method of the Statement object is used to execute a SELECT query and returns a ResultSet?

MCQ Medium

a. executeUpdate()

b. executeQuery()

c. runQuery()

d. fetch()

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

executeQuery()

Explanation: The executeQuery(query) method executes a SELECT SQL statement and returns a ResultSet object containing the results.

630

Which tab is used to change the alignment (left, right, centered, justified) of selected text?

MCQ Easy

a. Format

b. View

c. Insert

d. Table

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

Format

Explanation: Format > Alignment is used to set text alignment as left, right, centered, or justified.

631

What is a key limitation of using the DBMS approach?

MCQ Medium

a. It cannot store large volumes of data

b. High cost of implementation and security/recovery overheads

c. It does not allow multiple users

d. It cannot be used for small databases

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

High cost of implementation and security/recovery overheads

Explanation: The DBMS approach has a high implementation cost and involves security/recovery overheads (e.g., regular backups), making it less preferred for small, simple databases.

632

A ResultSet object represents:

MCQ Medium

a. A single row of data

b. A table of data returned by an SQL query

c. The database connection itself

d. An exception object

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

A table of data returned by an SQL query

Explanation: A ResultSet is a table of data (rows and columns) returned by executing an SQL query via executeQuery().

633

Which OpenOffice Writer command displays the number of words and characters in a document or selected text?

MCQ Easy

a. Tools > Word Count

b. Format > Character

c. View > Status Bar

d. Insert > Fields

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

Tools > Word Count

Explanation: Tools > Word Count displays the number of words and characters in the selected text, or the whole document if nothing is selected.

634

The relational database model was developed by:

MCQ Medium

a. Charles Babbage

b. E.F. Codd

c. Dennis Ritchie

d. James Gosling

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

E.F. Codd

Explanation: The relational database model was developed by E.F. Codd at IBM in 1970.

635

Which method of the ResultSet object is used to move to the next row and returns false when there are no more rows?

MCQ Medium

a. hasNext()

b. next()

c. getNext()

d. moveNext()

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

next()

Explanation: The next() method of ResultSet moves the cursor to the next row and returns false when there are no more rows left.

636

The Format tab in OpenOffice Writer is used to apply formatting to text that has already been selected.

TRUE FALSE Medium

a. TRUE

b. FALSE

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

TRUE

Explanation: When using the Format tab, formatting commands apply to the text that has been selected by the user.

637

In the relational model, a row of a table is called a:

MCQ Easy

a. Domain

b. Attribute

c. Tuple

d. Relation

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Tuple

Explanation: In relational model terminology, a row is called a Tuple, a column is an Attribute, and a table is a Relation.

638

Which type of exception is typically thrown by database connectivity operations, requiring a try-catch block?

MCQ Medium

a. ArithmeticException

b. SQLException

c. NullPointerException

d. ArrayIndexOutOfBoundsException

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

SQLException

Explanation: Database connectivity operations can throw an SQLException, so they should be enclosed in a try-catch block.

639

The Window tab in OpenOffice Writer allows checking spelling and grammar.

TRUE FALSE Medium

a. TRUE

b. FALSE

Information Technology (802) · Class 11 · Sep 26, 2026

Show answer

FALSE

Explanation: The Window tab allows opening a new window, closing an existing window, and shows names of open windows; spelling/grammar check is under the Tools tab.

640

In the relational model, the number of attributes in a relation is called its:

MCQ Easy

a. Cardinality

b. Degree

c. Domain

d. Schema

Information Technology (802) · Class 12 · Sep 26, 2026

Show answer

Degree

Explanation: The Degree of a relation is the number of attributes (columns) it has; Cardinality is the number of tuples (rows).