GkSeries.com

Structured Query Language Multiple Choice Questions and Answers for Interview | Objective Type Questions

Download PDF

DBMS multiple choice interview questions and answers page contain 5 questions from chapter Structured query language. Each SQL objective question has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(11) Which command is used to add a column to an existing table ?
[A] Create
[B] Update
[C] Alter
[D] None of these

Comment

Answer: Option [C]
(12) Which one is not an aggregate function in SQL ?
[A] Count
[B] Mean
[C] Min
[D] All are aggregate function

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(13) Which one of the following is a valid join type ?
[A] natural
[B] full outer join
[C] on
[D] using

Comment

Answer: Option [B]
(14) One of the following steps is not involved in processing a query :
[A] parsing and translation
[B] optimization
[C] evaluation
[D] distribution

Comment

Answer: Option [D]
(15) Which of the following statement on the view concept in SQL is invalid ?
[A] all views are not updatable
[B] the views may be referenced in an SQL statement whenever tables are referenced
[C] the views are instantiated at the time they are referenced and not when they are defined
[D] the definition of a view should not have GROUP BY clause in it

Comment

Answer: Option [D]

Please share this page

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

Chapters

Click Here to Read more questions

Teacher Eligibility Test