GkSeries.com

SQL MCQs - Structured Query Language Interview Questions and Answers

Download PDF

DBMS multiple choice questions and answers page contain 5 questions from chapter Structured query language. Each SQL interview MCQ has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(26) Which of the following is not an SQL command ?
[A] CREATE
[B] DROP
[C] ALTER
[D] All are SQL commands

Comment

Answer: Option [D]
(27) Which of the following is correct ?
[A] A SQL query automatically eliminates duplicates.
[B] SQL permits attribute names to be repeated in the same relation
[C] A SQL query will not work if there are no indexes on the relations.
[D] None of these

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(28) The DMLs which require user to specify what data is needed and how to get it, is called :
[A] DDL DMLs
[B] Procedural DMLs
[C] Non-procedural DMLs
[D] None of the above

Comment

Answer: Option [B]
(29) Which of the following clauses is used in the CREATE TRIGGER command to create a row level trigger ?
[A] FOR ROW
[B] ROW LEVEL
[C] ROW LEVEL TRIGGER
[D] None of the above.

Comment

Answer: Option [D]
(30) Which of the following is used to evaluate a query execution strategy ?
[A] Query tree
[B] Access plan
[C] Database catalog
[D] None of the above

Comment

Answer: Option [A]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test