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

Q: 46. _______ produces the relation that has attributes of R1 and R2

Correct Answer is: Cartesian product

Q: 47. The natural join is equal to :

Correct Answer is: Combination of projection and Cartesian product

Q: 48. Which of the following is a valid SQL type?

Correct Answer is: All of the above

Q: 50. The view of total database content is

Correct Answer is: Conceptual view.

Q: 51. Relational Algebra is

Correct Answer is: Procedural query Language

Q: 52. Related fields in a database are grouped to form a

Correct Answer is: data record.

Q: 53. An advantage of the database management approach is

Correct Answer is: data is integrated and can be accessed by multiple programs.

Q: 54. Which of the following is an advantage of view?

Correct Answer is: All of the above

Q: 55. The conceptual model is

Correct Answer is: independent of both hardware and software.

Q: 56. DML is provided for

Correct Answer is: Manipulation & processing of database.

DBMS MCQ Questions for Practice

46. _______ produces the relation that has attributes of R1 and R2

Cartesian product
Difference
Intersection
Product

47. The natural join is equal to :

Cartesian Product
Combination of Union and Cartesian product
Combination of selection and Cartesian product
Combination of projection and Cartesian product

48. Which of the following is a valid SQL type?

CHARACTER
NUMERIC
FLOAT
All of the above

49. Which of the following is another name for weak entity?

Child
Owner
Dominant
All of the above

50. The view of total database content is

Conceptual view.
Internal view.
External view.
Physical View.

51. Relational Algebra is

Data Definition Language .
Meta Language
Procedural query Language
None of the above

52. Related fields in a database are grouped to form a

data file.
data record.
menu.
bank.

53. An advantage of the database management approach is

data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.

54. Which of the following is an advantage of view?

Data security
Derived columns
Hiding of complex queries
All of the above

55. The conceptual model is

dependent on hardware.
dependent on software.
dependent on both hardware and software .
independent of both hardware and software.

56. DML is provided for

Description of logical structure of database.
Addition of new structures in the database system.
Manipulation & processing of database.
Definition of physical structure of database system.

57. The method of access which uses key trAnsformation is known as

Direct
Hash
Random
Sequential

58. The method of access which uses key transformation is known as

direct.
hash.
random.
sequential.

59. The language used in application programs to request data from the DBMS is referred to as the

60. E-R model uses this symbol to represent weak entity set ?

Dotted rectangle.
Diamond
Doubly outlined rectangle
None of these