Interested to Buy Any Domain ? << Click Here >> for more details...
check, not null,unique
- 2 Answers
- 5167 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasanthi
Check Constraint:
The CHECK constraint is used to limit the value range that
can be placed in a column.
not null constraint:
if we give not null constraint to any column it will not
accept null values.
Unique Conatraint:
Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.
| Is This Answer Correct ? | 5 Yes | 0 No |
What are the steps you will take to improve the performance of a poor performing query?
What is the order in which the sql query is executed?
What is the maximum size of column in sql server?
What does it mean to be in union?
What is dml command?
What is unpivot?
What is a join in sql? What are the types of joins?
How to find the version of sql server? : sql server database administration
What is the difference between truncate and delete commands?
What is the security principal at the server level that represents your session?
how many no of arguments can be passed in procedures and functions
What is referential integrity? What are the advantages of it?
4 Answers Descon, Digital Domain,
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
