What are constraints? Explain different types of
constraints?
Answer Posted / smita
Constraint mostly restrict the user from entering violated
data into the table..
Various types of constraints are:
Primary Key Constraint
Foreign Key Constraint
Unique key Constraint
Check Constraint
NOT NULL Constraint
Is This Answer Correct ? | 44 Yes | 23 No |
Post New Answer View All Answers
What are transactions in sql?
What are the transaction properties?
Explain the stored procedure?
Can you index views?
How to create an multi-statement table-valued function?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How does stuff differ from the replace function?
What is the main purpose of having conversation group?
What are the steps to process a single select statement?
What are the operating modes in which database mirroring runs?
What information is maintained within the msdb database?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is the difference between nvl and nvl2?