MCQ Type 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]

Article and Schedule Quiz	Start Test!

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]

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!