Miscellaneous or General
1. A primary key if combined with a foreign key creates
A.  Parent-Child relationship between the tables that connect them. B.  Many to many relationship between the tables that connect them. C.  Network model between the tables that connect them. D.  None of the above.
2. In E-R Diagram relationship type is represented by
A.  Ellipse B.  Dashed ellipse C.  Rectangle D.  Diamond
3. A Dada manipulation command the combines the records from one or more tables is called
A.  SELECT B.  PROJECT C.  JOIN D.  PRODUCT
4. To delete a particular column in a relation the command used is:
A.  UPDATE B.  DROP C.  ALTER D.  DELETE
5. The ______ operator is used to compare a value to a list of literals values that have been specified
A.  BETWEEN B.  ANY C.  IN D.  ALL
6. A logical schema
A.  is the entire database B.  is a standard way of organizing information into a accessible part C.  describe how data is actually stored on disk D.  none of these
7. A B-tree of order m has maximum of _____________ children
A.  m B.  m+1 C.  m-1 D.  m/2
8. . _____________ function divides one numeric expression by another and returns the remainder
A.  POWER B.  MOD C.  ROUND D.  REMAINDER
9. In E-R diagram generalization is represented by
A.  Ellipse B.  Dashed ellipse C.  Rectangle D.  Triangle
10. _________ is a virtual table that draws its data from the result of an SQL SELECT statement.
A.  View B.  Synonym C.  Sequence D.  TrAnsaction