Q. Which function returns the average value of a column?
Q. Which of the operations constitute a basic set of operations for manipulating relational
Q. Which of the following is another name for weak entity?
Q. Which of the following database object does not physically exist?
Q. Which of the following is record based logical model?
Q. A data dictionary is a special file that contains:
Q. A file manipulation command that extracts some of the records from a file is called ________ .
Q. The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
Q. Using Relational Algebra the query that finds customers, who have a balance of over
1000 is _______ ?
Q. A primary key combined with a foreign key creates _______ .
Q. In E-R Diagram derived attribute are represented by _______ .
Q. An instance of relational schema R(A, B, C) has distinct values of A including NULL
values. Which one of the following is true??
Q. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is: