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]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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]

Chapters

ADRE 3.0 Complete Study Material