Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

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

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

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]

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!

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

Chapters

LEAVE A COMMENT