JOIN ADRE 2.0 Telegram Group

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

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]
Advertisement
Article and Schedule Quiz Start Test!

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

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]

ADRE 2.0 FULL LENGTH MOCK TEST

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!

Chapters

Advertisement