Relational Database Management System - DBMS Short Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
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]

Random GK Questions

Q. Which of the following is an indirect tax?
Q. Sour taste of Coca Cola is due to the presence of
Q. Tides in the sea have stored in them :
Q. In which year the Arjuna Awards were instituted ?
Q. The radical wing of the Congress Party, with Jawaharlal Nehru as one of main leaders, founded the Independence for India League in opposition to:
Q. In terms of area, India is the ________ largest country of the world.

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics