LawMint Sign in

RPSC Assistant Professor (College Education) Database Management Systems Previous Year Questions

Try the preview and open any solution for a worked explanation.

RPSC Assistant Professor (College Education) practice pack

The practice pack for RPSC Assistant Professor (College Education) is coming soon to LawMint.

Question 1

If a relation with a Schema R is decomposed into two relations R1 and R2 such that (R1 ∪ R2) = R then which one of the following is to be satisfied for a lossless join decomposition (→ indicates functional dependency)?

Select one answer

Question 2

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1(AB) and R2(CD) is

Select one answer

Question 3

A relation in which every non-key attribute is fully functionally dependent on primary key and has no transitive dependency, is in :-

Select one answer

Question 4

A relational schema R is in...........if whenever a non - trivial functional dependency x → A hold in R, the x is a superkey of R:-

Select one answer

Question 5

Which operation combines rows from two tables by matching values in a common column?

Select one answer

Question 6

Intersection operation on two relations R1 and R2 of data base is :-

Select one answer

Question 7

If relation R1 has P attributes and m tuples and relation R2 has q attributes and n tuples, then relation R1 X R2 has .........attributes and .........tuples.

Select one answer

Question 8

In E-R model when subgroups of a given entity type are defined, this is known as :-

Select one answer

Question 9

Cardinality ratio ' strong entity set : weak entity set' in their binary identifying relationship is :-

Select one answer

Question 10

In E-R diagram ------is represented by dashed ellipse :-

Select one answer

Continue practising

The practice pack for RPSC Assistant Professor (College Education) is coming soon to LawMint.

RPSC Assistant Professor (College Education) practice pack

The practice pack for RPSC Assistant Professor (College Education) is coming soon to LawMint.