Time Left - 12:00 mins

UGC-NET 2018: (DBMS ) SpeedTest Quiz 20

Attempt now to get your rank among 569 students!

Question 1

Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems:
(a) Data redundancy and inconsistency
(b) Difficulty in accessing Data
(c) Data isolation
(d) Integrity problems

Question 2

If a relation with a Schema R is decomposed into two relations R₁ and R₂ such that

then which one of the following is to be satisfied for a lossless joint decomposition (

indicates functional dependency)

Question 3

The E-R model is expressed in term of
I. Entities
II. The relationship among entities.
III. The attributes of the entities.
IV. Functional relationship.

Question 4

A B+ -tree index is to be built on the Name attribute of the relation STUDENT. Assume that all student names are of length 8 bytes, disk block are size 512 bytes, and index pointers are of size 4 bytes. Given this scenario, what would be the best choice of the degree (i.e. the number of pointers per node) of the B+ -tree ?

Question 5

Consider the schema $R (A, B, C, D)$ and the functional dependencies $A \to B$ and $C \to D$ . If the decomposition is made as $R_{1} (A, B)$ and $R_{2} (C, D)$ then which of the following is TRUE?

Question 6

Given a Relation POSITION (Posting-No, Skill), then the query to retrieve all distinct pairs of posting-nos. requiring skill is

Question 7

ORACLE supports:

Question 8

The problem that occurs when one transaction updates a database item and then the transaction fails for some reasons is _________.

Question 9

Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock?
(a) 2-phase Locking
(b) Time stamp - ordering

Question 10

What is Granularity?

569 attempts
2 upvotes
13 comments

Tags :

GATE & PSU CS General

Mar 30GATE & PSU CS