adplus-dvertising
frame-decoration

Question

What is the function of the not null constraint?

a.

It prevents illegal data from being entered into the database

b.

It ensures that data is entered into the database

c.

It ensures that the data entered is unique

d.

None of the mentioned

Posted under DBMS

Answer: (b).It ensures that data is entered into the database

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 not null constraint?

Similar Questions

Discover Related MCQs

Q. What is the function of the unique constraint?

Q. What is the functions of on delete cascade?

Q. What does the following condition do?
check( name in( ‘Ryan’, ‘Cristiano’, ‘Leo’))

Q. Referential integrity constraints are also called as _________

Q. ________ is a predicate that we expect the database to always satisfy

Q. State true or false: Oracle does not support complex check conditions

Q. What statement is used to define a new assertion in SQL?

Q. Which of the following is not a valid Date and Time data type?

Q. What is a timestamp?

Q. What does p indicate in the following data type?
time(p)

Q. What is a default value?

Q. Which of the following is an illegal data type in SQL

Q. State true or false: Users can define new data types in SQL

Q. What does the following statement do?
create table temp_inst like institute

Q. Which of the following is a privilege in SQL standard?

Q. The _________ statement is used in SQL to confer authorization.

Q. revoke select on takes from amit;
What does the above query perform?

Q. Which of the following is/are a function of dynamic SQL?

Q. What is the full form of JDBC?

Q. State true or false: Developers cannot write their own functions into SQL