Below are some of the well researched DBMS interview questions and answers in multiple choice Quiz format.

#1. Which of the following constraint is defined only at column level?

#2. What will be the output of following snippet? Create table Student( Name Varchar2(20) Primary Key, ID Number(4) Primary Key, DOB Date Primary Key);

#3. Which normal form is good for relational database design?

#4. Which Functional dependency types is present in following relations? R(A,B,C,D,E) F{ AB->C,B->D,D->E)

#5. Identify the candidate keys in following R(A,B,C,D,E,F,G,H,I,J) with following Functional dependencies: AB->C, A->DE, B->F, F->GH, D-> IJ

Facebook Comments Box

By Ram Ram