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
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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 MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement