Q. Aggregate functions in SQL are:

View solution

Q. If a relation is in 2NF and 3NF forms then:

View solution

Q. The end of an SQL command is denoted by:

View solution

Q. Consider  the  query  :  SELECT  student_name  FROM  students  WHERE class_name=(SELECT  class_name  FROM  students  WHERE  math_marks=100); what will be the output ?

View solution

Q. Which of the following statements is wrong?

View solution

Q. A recursive foreign key is a:

View solution

Q. A sub class having more than one super class is called:

View solution

Q. A relation R={A,B,C,D,E,F} is given with following set of functional dependencies:

F={A→B,AD→C,B→F,A→E}.

Which of the following is Candidate Key?

View solution

Q. Which statement is false regarding data independence?

View solution

Q. In DBMS, deferred update means:

View solution

Q. Which statement is false regarding data independence ?

View solution

Q. Two phase protocol in a database management system is:

View solution

Q. A relation R = {A, B, C, D, E, F} is given with following set of functional dependencies:

F = {A→B, AD→C, B→F, A→E}

Which of the following is candidate key ?

View solution

Q. Immediate updates as a recovery protocol is preferable, when:

View solution

Q. Which of the following statement is wrong ?

View solution

Q. A subclass having more than one super class is called .................

View solution

Q. A schema describes:

View solution

Q. One approach to standardizing storing of data:

View solution

Q. In a relational schema, each tuple is divided in fields called:

View solution

Q. An embedded pointer provides:

View solution