Online Quiz

← Back
Get daily current affairs & exam alerts – follow us YouTube WhatsApp Channel Telegram Channel Facebook Page Instagram
Share with friends & study groups
Link to this page from your website / blog (HTML code)
1.  
Which command removes only those rows of a table that meet a condition given in a WHERE clause?

Correct Answer: A [DELETE]

Explanation:

DELETE … WHERE removes chosen rows; TRUNCATE empties the whole table; DROP removes the table.

2.  
Which of the following is a DML command?

Correct Answer: E [UPDATE]

Explanation:

UPDATE changes data → DML.

3.  
A table has 9 columns and 1,200 rows. What are its degree and cardinality?

Correct Answer: B [9 and 1,200]

Explanation:

Degree = columns 9; cardinality = rows 1,200.

4.  
A candidate key that is not chosen as the primary key is called a(n):

Correct Answer: C [alternate key]

Explanation:

Alternate = candidate − primary.

5.  
Two tellers update the same account at the same moment. Which ACID property makes each transaction run as if it were alone?

Correct Answer: D [Isolation]

Explanation:

Isolation keeps concurrent transactions from interfering; durability = survives a crash.

6.  
A table is in Second Normal Form (2NF) when it is in 1NF and has no:

Correct Answer: A [partial dependency on part of a composite key]

Explanation:

2NF: every non-key column depends on the whole key; 3NF removes transitive dependency.

7.  
In the table ACC of this chapter, what does SELECT COUNT(*) FROM ACC WHERE Balance > 40000; return?

Correct Answer: E [4]

Explanation:

Ravi 45000, Meena 120000, Divya 250000, Priya 75000 → 4.

8.  
Which clause is used to filter groups formed by GROUP BY?

Correct Answer: D [HAVING]

Explanation:

WHERE filters rows; HAVING filters groups.

9.  
In the LIKE operator, which symbol stands for exactly one character?

Correct Answer: B [_ (underscore)]

Explanation:

% = any number of characters; _ = exactly one.

10.  
In an ER diagram, a multi-valued attribute is shown by a:

Correct Answer: C [Double ellipse]

Explanation:

Double ellipse = multi-valued; dashed = derived.

11.  
A rule that a foreign key value must match an existing primary key value in the referred table is called:

Correct Answer: B [referential integrity]

Explanation:

Entity integrity = PK not NULL; referential integrity = FK must match.

12.  
Match the command with its category:
List I: (a) ALTER; (b) INSERT; (c) REVOKE; (d) SAVEPOINT
List II: (1) TCL; (2) DDL; (3) DCL; (4) DML

Correct Answer: D [a-2, b-4, c-3, d-1]

Explanation:

ALTER DDL; INSERT DML; REVOKE DCL; SAVEPOINT TCL.

13.  
Which data model stores data as a tree with one parent and many children?

Correct Answer: E [hierarchical model]

Explanation:

Tree = hierarchical; graph (many parents) = network.

14.  
Store of historical, integrated data from many systems, used for analysis and reports, is a:

Correct Answer: C [data warehouse]

Explanation:

Data warehouse → analysis (OLAP).

15.  
On ACC, what does SELECT MIN(Balance) FROM ACC WHERE Branch = 'Coimbatore'; return?

Correct Answer: A [15000]

Explanation:

Coimbatore rows: Divya 250000, Suresh 15000 → MIN 15000.

16.  
Which of these statements about NULL is correct?

Correct Answer: C [NULL means unknown or not applicable; test it with IS NULL]

Explanation:

NULL ≠ 0 ≠ space; '= NULL' never matches; COUNT(*) counts every row.

📘 IBPS Clerk 2026 – B4 Computer Aptitude (PDF book)
Here you get the answer with a one-line explanation. 690 questions, each with a full step-by-step explanation · shortcuts, tables, trap alerts · Prelims + Mains sectional mocks. All 5 books together: ₹599.
Get the book – ₹149 →
Score: 0 Answered: 0 / 0