Relational Database Management System - DBMS Short Questions and Answers

Questions

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

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

Answer: Option [B]

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

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

Answer: Option [B]

25 Which of the following is not a valid relational database ?

A SYBASE

B Oracle

C FoxPro

D UNIFY

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!