Structured Query Language Multiple Choice Questions and Answers for Interview

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]

Article and Schedule Quiz	Start Test!

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]

Take Mock Tests

Missiles Mock Test	Start Test!
SSC MTS Mock Test	Start Test
IBPS CLERK MOCK TEST	Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH)	Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi)	Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH)	Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH)	Start Test!
IB Security Assistant Mock test 1 (english)	Start Test!
UP POLICE CONSTABLE MOCK TEST 1	Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI)	Start Test!