Question:
In SQL, which of the following constraint means that no two values in any column should be the same?
In SQL, which of the following constraint means that no two values in any column should be the same?
Updated On: Oct 18, 2024
- DISTINCT
- UNIQUE
- ORDER BY
- GROUP BY
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :UNIQUE
Was this answer helpful?
0
0
Top Questions on SQL
- Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
On a relation named Loan of a bank:
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)?
View More Questions
Questions Asked in CUET exam
- Two slits are made 0.1 mm apart and the screen is placed 2 m away. The fringe separation when a light of wavelength 500 nm is used is______.
Fill in the blank with the correct answer from the options given below. - Lower half of a convex lens is made opaque. Which of the following describes the image of the object placed in front of the lens?(A) No change in image
(B) Image will show only half of the object
(C) Intensity of image gets reduced
Choose the correct answer from the options given below. - Complete the sentences given in List-I with the appropriate prepositions given in List-II:
- If $f(x) = x^2 + bx + 1$ is increasing in the interval $[1, 2]$, then the least value of $b$ is:
- CUET (UG) - 2024
- Increasing and Decreasing Functions
- What will be the increasing order of basic strength of the following compounds: \(\text{C}_2\text{H}_5\text{NH}_2, (\text{C}_2\text{H}_5)_2\text{NH},(\text{C}_2\text{H}_5)_3\text{N},\text{C}_6\text{H}_5\text{NH}_2\)
View More Questions