Database Management System - DBMS Quizzes | Trivia Quiz for Practice

76. What SQL structure is used to limit column values of a table?

1. The LIMIT constraint
2. The CHECK constraint
3. None of the above is correct.
4. The VALUE constraint

77. A ................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

1. First
2. Second
3. Fourth
4. Third

78. A .................normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.

1. First
2. Second
3. Fourth
4. Third

79. In the ..........normal form, a composite attribute is converted to individual attributes.

1. First
2. Second
3. Fourth
4. Third

80. In the.......... Normal form, a composite attribute is converted to individual attributes.

1. First
2. Second
3. Fourth
4. Third

81. Which one is based on multi-valued dependency:

1. First
2. Second
3. Fourth
4. Third

82. In decomposition technique of splitting a relation into ……………… relation:

1. ONE or MORE
2. TWO or MORE
3. FOUR or MORE
4. THREE or MORE

83. ………………… is preferred method for enforcing data integrity

1. Constraints
2. Stored Procedure
3. Cursors
4. Triggers

84. Which are the dependencies types:

1. Full functional dependency
2. Partial dependency
3. All of these
4. Trivial functional dependency

85. The number of entities associated in relationship is called as its.....................

1. Cardinality
2. Degree
3. Entity
4. Tuples

86. A relation is considered a:

1. Column
2. One dimensional table
3. Three dimensional table
4. Two dimensional table

87. Identify the criteria for designing database from the point of view of user

1. No redundancy
2. No inapplicable attributes
3. All of the above
4. Uniformity in naming & definitions of the data items

88. Identify the criteria for designing database from the point of view of user

1. No redundancy
2. No inapplicable attributes
3. All of the above
4. Uniformity in naming & definitions of the data items

89. The ........... operator preserves unmatched rows of the relations being joine

1. Inner join
2. Outer join
3. Union join
4. Union

90. The DML is called:

1. Sublanguages
2. Host languages
3. DDL
4. VDL