Database Management System - DBMS MCQ Multiple Choice Questions - Page 3 for Practice

61. DA stands for:

62. Which command enables alteration the data stored in existing records:

63. Data Manipulation Language enables users to

64. A logical schema

65. Which of the following is a group of one or more attributes that uniquely identifies a row?

66. To eliminate duplicate rows ……………… is used

67. Which is installs, configures, troubleshoots and maintains a database system:

68. Centralizing the integrity checking directly under the DBMS ………… duplication and ensures the consistency and validity of the database.

69. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

70. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

71. To delete a database .................. command is used

72. ……………… ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.

73. ……………… means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is complete

74. The ……………… statement is used to end a successful transaction.

75. ……………… joins are SQL server default

76. Which are the three levels of abstraction:

77. Row is synonymous with the term:

78. Table is synonymous with the term:

79. How many types of keys in relation database design:

80. The candidate key is that you choose to identify each row uniquely is called ……………..

81. Which key is referencing a primary key in a table:

82. The primary key is selected from the:

83. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ............... Is needed

84. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ----------------- is needed

85. A relation is in this form if it is in BCNF and has no multivalued dependencies:

86. ……………..specifies a search condition for a group or an aggregate.

87. ……………..specifies a search condition for a group or an aggregate.

88. ………………….operator is basically a join followed by a project on the attributes of first relation.

89. FD stands for:

90. The different classes of relations created by the technique for preventing modification anomalies are called:


Tags

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online