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]