SQL is a: MCQ with Answer and Explanation

Question
SQL is a:
A. Assembly language
B. Machine language
C. Procedural language
D. Declarative language
Answer: Option D
Solution (By JKSSB Mock Tests)
SQL is a declarative language where you specify what data you want, not how to get it.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What does the ROLLBACK statement do?
A. Saves the changes
B. Starts a new transaction
C. Undoes all changes made in the current transaction
D. Creates a savepoint
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which normal form requires that all attributes in a table contain only atomic, indivisible values, and prohibits multi-valued attributes?
A. Third Normal Form (3NF)
B. Boyce-Codd Normal Form (BCNF)
C. First Normal Form (1NF)
D. Second Normal Form (2NF)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A relation is in First Normal Form (1NF) if and only if the domain of every attribute contains only atomic (indivisible) values, and no repeating groups exist.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What does ACID stand for in database transactions?
A. Access, Create, Insert, Delete
B. Accuracy, Control, Integrity, Data
C. Atomicity, Consistency, Isolation, Durability
D. All Correct Information Display
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ACID properties ensure reliable transaction processing in DBMS.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Microsoft Office 1199 Memory and Storage Devices 438 Internet and Web Technologies 461 Database Management System (DBMS) 278 Computer Networking 325
Explore Subjects
Current Affairs 575 Maths 5575 Static General Knowledge 6362 Economy GK 2220 Geography GK 6121
Practice Mix
She ___ a great singer.
Which national park in Madhya Pradesh has the 'Mandla Plant Fossils'?
Who was the first woman to command a space mission?
In a school, 60% are boys and 40% are girls. 20% of boys and 25% of girls get scholarship. What percent of students do not get scholarship?
Which of the following is a characteristic of 'Reference-Dependent Preferences'?