JOIN ADRE 2.0 Telegram Group

Multiple Choice Interview Questions and Answers for SQL Database Administrator Jobs

Questions
31 Which of the following is a data query statement in QUEL ?
A RETRIEVE
B SELECT
C GET
D None of the above

Answer: Option [B]
32 Which type of join returns all rows that satisfy the join condition ?
A Inner join
B Outer join
C Semi Join
D Anti join

Answer: Option [B]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

33 Which one of the following aggregate SQL function returns number of rows ?
A avg
B min
C count
D sum

Answer: Option [C]
34 Which of the following is not transaction characteristic in SQL ?
A access mode
B diagnnostics size
C isolation level
D commit

Answer: Option [D]
35 Under which condition, the value R ⟨ S/S equal to R (here ⟨ stands natural join and/ denotes division).
A When R and S are having at least one attribute common
B The degree of S is less than the degree of R
C The degree of R is less than the degree of S
D When R and S are having no attribute in common

Answer: Option [A]

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