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)?
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
Question 3
A relation in which every non-key attribute is fully functionally dependent on primary key and has no transitive dependency, is in :-
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:-
Question 5
Which operation combines rows from two tables by matching values in a common column?
Question 6
Intersection operation on two relations R1 and R2 of data base is :-
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.
Question 8
In E-R model when subgroups of a given entity type are defined, this is known as :-
Question 9
Cardinality ratio ' strong entity set : weak entity set' in their binary identifying relationship is :-
Question 10
In E-R diagram ------is represented by dashed ellipse :-
Previous papers with Database Management Systems questions
RPSC Assistant Professor (College Education) practice pack
The practice pack for RPSC Assistant Professor (College Education) is coming soon to LawMint.