Download PDF
DBMS multiple choice questions and answers page contain 5 questions from chapter Structured query language. Each SQL MCQ has 4 possible answers. Choose your answer and check it with the given correct answer.
(1)
Which command is used to remove all rows from a table ?
[A]
Delete
[B]
Remove
[C]
Truncate
[D]
Both [A] and [B]
Comment
(2)
What is the language used by most of the DBMS for helping their users to access data ?
[A]
High level language
[B]
Query language
[C]
SQL
[D]
4GL
Comment
(3)
The language used in application program to request data from the DBMS is referred to as the :
[A]
DML
[B]
DDL
[C]
Query language
[D]
All of the above
Comment
(4)
A command that lets you change one or more fields in a record is :
[A]
Insert
[B]
Modify
[C]
Look-up
[D]
All of the above
Comment
(5)
The modify operation is likely to be done after :
[A]
Delete
[B]
Look-up
[C]
Insert
[D]
None of the above
Comment
Chapters