DBMS MCQ Multiple Choice Questions Answers - Page 3 | Quiz for Practice

Q: 31. A report generator is used to

Correct Answer is: print files on paper.

Q: 34. It is possible to define a schema completely using

Correct Answer is: DDL and DML.

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

Correct Answer is: A view definition is permanently stored as part of the database.

Q: 38. Which of the following is correct:

Correct Answer is: None of these

Q: 39. Cartesian product in relational algebra is

Correct Answer is: a Binary operator.

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

Correct Answer is: all the tuples of R1 and R2 which have common columns

DBMS MCQ Questions for Practice

31. A report generator is used to

update files.
print files on paper.
data entry.
delete files.

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

users.
separate files.
database.
database administrator.

33. Count function in SQL returns the number of

values.
distinct values.
groups.
columns.

34. It is possible to define a schema completely using

VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.

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

View
Synonym
Sequence
TrAnsaction

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

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

37. A relational database developer refers to a record as

a criteria.
a relation.
a tuple.
an attribute.

38. Which of the following is correct:

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

39. Cartesian product in relational algebra is

a Unary operator.
a Binary operator.
a Ternary operator.
not defined.

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

all the tuples of R1
all the tuples of R2
all the tuples of R1 and R2
all the tuples of R1 and R2 which have common columns

41. The statement in SQL which allows to change the definition of a table is

Alter.
Update.
Create.
select.

42. A set of possible data values is called

attribute.
degree.
tuple.
domain.

43. Which of the following database object does not physically exist?

base table
index
view
none of the above

44. The ______ operator is used to compare a value to a list of literals values that have beenspecified.

BETWEEN
ANY
IN
ALL

45. The physical location of a record is determined by a mathematical formula that trAnsformsa file key into a record location is :

B-Tree File
Hashed File
Indexed File
Sequential file.