Why do we use sql limitations? Which constraints can we use while making a database in sql?
- 1 Answers
- 1164 Views
- I also Faced
- E-Mail Answers
Answer Posted / Bablu Kumar
SQL limitations, such as constraints and data types, help ensure the integrity and consistency of the data stored in a database. They prevent invalid or inconsistent data from being entered and maintained within the database. Some constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, and INDEX. These can be used to enforce rules on columns, tables, and relationships between tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we solve concurrency problems?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the different types of subquery?
What is a scheduled job or what is a scheduled task?
What is the difference between for xml raw and for xml auto?
Is it possible to have clustered index on separate drive from original table location?
What is normalization and what are the advantages of it?
Disadvantages of the indexes?
Can we shrink data file in sql server?
what is the difference between openrowset and openquery?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How do I find the sql server version?
What is subquery? Explain the properties of a subquery?
What are the different SQL Server Versions you have worked on?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
