Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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

11 Which command is used to add a column to an existing table ?
A Create
B Update
C Alter
D None of these

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

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

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

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

Answer: Option [D]

Computer Science Books