SSC IMD Scientific Assistant 2026 Full-Length Master Mock Test-2 ⋆ CSE Study247

SSC IMD Scientific Assistant 2026 Full-Length Master Mock Test-2

Questions 156-160 of 200

0% completed (0/200 answered)

Question 156

MCQ · Single Correct 1 mark

[Q.36] Which SQL command is classified as a Data Definition Language (DDL) command?

A INSERT B UPDATE C ALTER D SELECT

Question 157

MCQ · Single Correct 1 mark

[Q.57] What is the main difference between SQL 'DELETE' and 'TRUNCATE' statements?

A TRUNCATE deletes schema structure; DELETE keeps schema B DELETE is DML (can be rolled back, deletes row by row); TRUNCATE is DDL (cannot be rolled back, removes all rows quickly) C DELETE cannot use a WHERE clause; TRUNCATE can D TRUNCATE logs every row deletion individually

Question 158

MCQ · Single Correct 1 mark

[Q.58] In Relational Database design, a candidate key that is NOT selected as the primary key is called a:

A Foreign Key B Alternate Key C Super Key D Composite Key

Question 159

MCQ · Single Correct 1 mark

[Q.59] A database table is in Second Normal Form (2NF) if it is in 1NF and:

A Every non-prime attribute is fully functionally dependent on the primary key (no partial dependency) B It contains no transitive dependencies C It contains no multi-valued dependencies D Every determinant is a super key

Question 160

MCQ · Single Correct 1 mark

[Q.60] What does the 'Atomicity' property in ACID transaction rules ensure?

A Data remains consistent before and after transaction execution B Concurrent transactions execute without interfering with each other C Committed changes persist permanently even after system failure D Either all operations of a transaction execute completely or none of them do (all-or-nothing)

SSC IMD Scientific Assistant 2026 Full-Length Master Mock Test-2

Question 156

Detailed Solution

Question 157

Detailed Solution

Question 158

Detailed Solution

Question 159

Detailed Solution

Question 160

Detailed Solution