Question 30Asked in Bihar STET 2025 Paper II Computer Science, 7 Nov 2025, Shift 1 (9:00 AM)

While creating a table, which constraint does not allow insertion of duplicate values inतालिका (table) तैयार करते समय कौन सा अवरोध (constraint) तालिका में प्रतिरूप मूल्‍यों

While creating a table, which constraint does not allow insertion of duplicate values in the table ?
तालिका (table) तैयार करते समय कौन सा अवरोध (constraint) तालिका में प्रतिरूप मूल्‍यों (duplicate values ) की प्रविष्टि (insertion) नहीं करने देता ?
  1. AUNIQUEUNIQUE
  2. BDISTINCTDISTINCT
  3. CNOT NULLNOT NULL
  4. DHAVINGHAVING
Show answerHide answer

Correct answer: (A) UNIQUEUNIQUE

Explanation

The UNIQUE constraint rejects duplicate values in a column. DISTINCT only removes duplicates from query results, NOT NULL forbids nulls, and HAVING filters groups.UNIQUE constraint किसी कॉलम में दोहराए मान अस्वीकार करता है। DISTINCT केवल क्वेरी परिणाम से दोहराव हटाता है, NOT NULL null मना करता है, और HAVING समूहों को फ़िल्टर करता है।

From Bihar STET 2025 Paper II Computer Science PYQ, 7 Nov 2025, Shift 1 (9:00 AM)

This is question 30 of Bihar STET 2025 Paper II Computer Science PYQ, 7 Nov 2025, Shift 1 (9:00 AM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.