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
- 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? On a relation named Loan of a bank:
- 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:
The following SQL query is executed:
SELECT L1.loannumber FROM Loan L1 WHERE L1.amount \(>\) (SELECT MAX(L2.amount) FROM Loan L2 WHERE L2.branchname = 'SR Nagar');- An OTT company is maintaining a large disk-based relational database of different movies with the following schema :
Movie (ID, Customer Rating)
Genre (ID, Name)
Movie Genre (MovieID, GenreID)
Consider the following SQL query on the relation database above :
SELECT *
FROM Movie, Genre, Movie_Genre
WHERE
Movie. CustomerRating > 3.4 AND
Genre.Name = "Comedy" AND
Movie_Genre.MovieID = Movie. ID AND
Movie_Genre.Genre ID = Genre. ID;
This SQL query can be sped up using which of the following indexing options ?
View More Questions
Questions Asked in CUET exam
- Find the ratio of de-Broglie wavelengths of deuteron having energy E and \(\alpha\)-particle having energy 2E :
- CUET (UG) - 2026
- Dual nature of radiation and matter
- The angles of elevation of the top of a tower from two points at a distance of 5 meters and 20 meters along the same straight line from the base of the tower, are complementary. Find the height of the tower.
- CUET (UG) - 2025
- Trigonometry
- Had he ________ the importance of the meeting, he would have made sure to attend.
Rearrange the following parts to form a meaningful and grammatically correct sentence:
P. a healthy diet and regular exercise
Q. are important habits
R. that help maintain good physical and mental health
S. especially in today's busy world- CUET (UG) - 2025
- Sentence Arrangement
- The following solutions were prepared by dissolving 1 g of solute in 1 L of the solution. Arrange the following solutions in decreasing order of their molarity: (A) Glucose (molar mass = 180 g mol$^{-1}$)
(B) NaOH (molar mass = 40 g mol$^{-1}$)
(C) NaCl (molar mass = 58.5 g mol$^{-1}$)
(D) KCl (molar mass = 7(4)5 g mol$^{-1}$)
- CUET (UG) - 2025
- Mole concept and Molar Masses
View More Questions