DBMS Multiple Choice Questions and Answers

31. A report generator is used to

1. update files.
2. print files on paper.
3. data entry.
4. delete files.

32. The database environment has all of the following components except:

1. users.
2. separate files.
3. database.
4. database administrator.

33. Count function in SQL returns the number of

1. values.
2. distinct values.
3. groups.
4. columns.

34. It is possible to define a schema completely using

1. VDL and DDL.
2. DDL and DML.
3. SDL and DDL.
4. VDL and DML.

35. _________ is a virtual table that draws its data from the result of an SQLSELECT statement.

1. View
2. Synonym
3. Sequence
4. TrAnsaction

36. Which one of the following is not true for a view:

1. View is derived from other tables.
2. View is a virtual table.
3. A view definition is permanently stored as part of the database.
4. View never contains derived columns.

37. A relational database developer refers to a record as

1. a criteria.
2. a relation.
3. a tuple.
4. an attribute.

38. Which of the following is correct:

1. a SQL query automatically eliminates duplicates.
2. SQL permits attribute names to be repeated in the same relation.
3. a SQL query will not work if there are no indexes on the relations
4. None of these

39. Cartesian product in relational algebra is

1. a Unary operator.
2. a Binary operator.
3. a Ternary operator.
4. not defined.

40. The result of the UNION operation between R1 and R2 is a relation that includes

1. all the tuples of R1
2. all the tuples of R2
3. all the tuples of R1 and R2
4. all the tuples of R1 and R2 which have common columns