Question
a.
It ensures that no two values under an attribute are identical
b.
It ensures that all the attributes are perfectly unique in their data type
c.
It ensures that all the relations in the database have a unique set of attributes
d.
It does not have any function in SQL
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What is the function of the unique constraint?
Similar Questions
Discover Related MCQs
Q. What is the functions of on delete cascade?
View solution
Q. What does the following condition do?
check( name in( ‘Ryan’, ‘Cristiano’, ‘Leo’))
View solution
Q. Referential integrity constraints are also called as _________
View solution
Q. ________ is a predicate that we expect the database to always satisfy
View solution
Q. State true or false: Oracle does not support complex check conditions
View solution
Q. What statement is used to define a new assertion in SQL?
View solution
Q. Which of the following is not a valid Date and Time data type?
View solution
Q. What is a timestamp?
View solution
Q. What does p indicate in the following data type?
time(p)
View solution
Q. What is a default value?
View solution
Q. Which of the following is an illegal data type in SQL
View solution
Q. State true or false: Users can define new data types in SQL
View solution
Q. What does the following statement do?
create table temp_inst like institute
View solution
Q. Which of the following is a privilege in SQL standard?
View solution
Q. The _________ statement is used in SQL to confer authorization.
View solution
Q. revoke select on takes from amit;
What does the above query perform?
View solution
Q. Which of the following is/are a function of dynamic SQL?
View solution
Q. What is the full form of JDBC?
View solution
Q. State true or false: Developers cannot write their own functions into SQL
View solution
Q. Which of the following are not a part of PL/SQL
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
