GkSeries.com

Multiple Choice Interview Questions and Answers for SQL Database Administrator Jobs

Download PDF

DBMS multiple choice interview questions and answers for Database administrator job page contain 5 questions from chapter Structured query language. Each objective question has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(31) Which of the following is a data query statement in QUEL ?
[A] RETRIEVE
[B] SELECT
[C] GET
[D] None of the above

Comment

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

Comment

Answer: Option [B]

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

Comment

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

Comment

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

Comment

Answer: Option [A]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test