Which of the following is a feature of SQL? MCQ with Answer and Explanation

Which of the following is a feature of SQL?
A. It is used to define, manipulate, and control data
B. All of the above
C. It is a declarative language
D. It is the standard language for relational databases
Answer: Option B
Solution (By JKSSB Mock Tests)
SQL is a declarative language used for defining, manipulating, and controlling data in relational databases.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following is a valid constraint in SQL?
A. PRIMARY KEY
B. FOREIGN KEY
C. CHECK
D. All of the above

Correct Answer: Option D


Explanation:
CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL are all constraints in SQL.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which SQL statement is used to delete all rows from a table without logging individual row deletions?
A. TRUNCATE TABLE table_name;
B. REMOVE FROM table_name;
C. DELETE FROM table_name;
D. DROP TABLE table_name;

Correct Answer: Option A


Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
A. Projection Anomaly
B. Deletion Anomaly
C. Selection Anomaly
D. Insertion Anomaly

Correct Answer: Option B


Explanation:
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.

This question belongs to: Computer Database Management System (DBMS)