Multiple Choice Interview Questions and Answers for SQL Database Administrator Jobs

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]

Random GK Questions

Q. Which from the following countries is not a permanent member of the UN Security Council?
Q. The Ashoka major rock edicts which tell us about the Sangam Kingdom include rock edicts:
Q. Who was the First Speaker of Independent India’s Lok Sabha?
Q. What was the main cause behind the famous tribal war which is mentioned in Rigveda as “Battle of Ten Kings” or 'Dashradnya Yuddha'?
Q. The achieve high rates of growth of national output, the economy has to
Q. The stream which gets divided into a network of channels forming bars of send and bland is known as

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics