Current Affairs Quiz 2024GKCourses AptitudeADRE 2.0English

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

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

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]

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!

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

Chapters

LEAVE A COMMENT