Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

Relational Database Management System - DBMS Short Questions and Answers

Download PDF

Database management system short questions and answers page contain 5 questions from chapter Relational DBMS. Each objective question has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(21) The set of attributes X ⊆ Schema (R) is a super key for relation schema R only if :
[A] For all relations r over R the number of tuples in projection over X of r is the same as the number of tuples in r
[B] All attributes of X are having non null values
[C] All attributes of X are having unique values
[D] None of the above

Comment

Answer: Option [C]
(22) B+ Trees are preferred to binary trees since :
[A] Disk capacities are higher than memory capacities
[B] Memory access is faster than disk access
[C] Disk are more reliable than memory
[D] Disk data transfer rates are much less than memory transfer rates

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(23) The physical location of a record is determined by a mathematical formula that transforms a file key in to a record location in :
[A] AB-tree File
[B] An indexed file
[C] A hashed file
[D] None of the above

Comment

Answer: Option [C]
(24) To represent many to many relationship between two entity types A and B in a relational model :
[A] put identifying attribute (s) of A in the relation representing B
[B] put identifying attribute (s) of B in the relation representing A
[C] create a new relation to represent the relationship
[D] it can not be represented

Comment

Answer: Option [B]
(25) Which of the following is not a valid relational database ?
[A] SYBASE
[B] Oracle
[C] FoxPro
[D] UNIFY

Comment

Answer: Option [D]

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