DBMS MCQs Quiz Multiple Choice Questions & Answers Page 2

DBMS MCQs questions answers

Test Your Skills in DBMS Quiz Online

DBMS Questions with Answers

51. Relational Algebra is

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

53. An advantage of the database management approach is

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

55. The conceptual model is

56. DML is provided for

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

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

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 ?

61. The full form of DDL is

62. In E-R Diagram derived attribute are represented by

63. In E-R Diagram relationship type is represented by

64. In E-R diagram generalization is represented by

65. Which of the following is a comparison operator in SQL?

66. Which database level is closest to the users?

67. In a Hierarchical model records are organized as

68. The method in which records are physically stored in a specified order according to a keyfield in each record is

69. The database schema is written in

70. Conceptual design

71. The relational model feature is that there

72. A logical schema

73. A logical schema

74. The property / properties of a database is / are :

75. A table joined with itself is called

76. A B-tree of order m has maximum of _____________ children

77. 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:

78. The way a particular application views the data from the database that the applicationuses is a

79. SET concept is used in :

80. Which of the following is record based logical model?

81. In case of entity integrity, the primary key may be

82. In the relational modes, cardinality is termed as:

83. ODBC stands for

84. The language which has recently become the defacto standard for interfacing applicationprograms with relational database system is

85. A primary key is combined with a foreign key creates

86. A primary key if combined with a foreign key creates

87. Which are the two ways in which entities can participate in a relationship?

88. In the architecture of a database system external level is the


Multiple Choice Questions and Answers on DBMS

DBMS Multiple Choice Questions and Answers

DBMS Trivia Quiz

DBMS Question and Answer PDF Online

Spreading Knowledge Across the World

United States, United Kingdom, India, Nigeria, Philippines, Pakistan, Nepal, Singapore, Indonesia, Bangladesh, Ghana, United Arab Emirates, Kenya, Canada, Malaysia, Australia, Iran, South Africa, Uganda, France, Ireland, Egypt, Tanzania, Ethiopia, Thailand, Sri Lanka, Cameroon, Hong Kong, Spain, Vietnam, New Zealand, Japan, Brazil, Saudi Arabia, Zambia, Czechia, Italy, Russia, Myanmar (Burma), Netherlands, Germany, Romania, Mexico, Rwanda, Sierra Leone, Turkey, Zimbabwe, Poland, Iraq, Cyprus, Algeria, Liberia, Greece, Jamaica, Malawi, Qatar, Portugal, South Korea, Argentina, Colombia, Morocco, Peru, Kuwait, Lithuania, Finland, Somalia, Israel, Bulgaria, Chile, Hungary, Trinidad & Tobago, Uzbekistan, Ukraine, Sweden, Kazakhstan, Norway, Macedonia, Benin, Switzerland, Oman, Botswana, Belgium, Ecuador, Slovakia, China, Croatia, Brunei, Serbia, Papua New Guinea, Bahrain, Guyana, Denmark, Lesotho, Lebanon, Jordan, Azerbaijan, Latvia, Cambodia, Namibia, Mauritius, Austria, Mongolia, Albania, Libya, Gambia, Taiwan, Bhutan, Venezuela, Dominican Republic, Tunisia, Luxembourg, Bosnia & Herzegovina, Guatemala, Solomon Islands, Guam, Costa Rica, Yemen, Bolivia, and many more ...