Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89672 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bose
constraint is a mechanism it is used to prevent the invalid
data entry in to the table is called constraint
| Is This Answer Correct ? | 43 Yes | 9 No |
Post New Answer View All Answers
How to send email from database?
What is the purpose of update statistics and scope_identity() function?
What are rest-style architecture's?
What is the sql server agent?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is reference section?
what is the system function to get the current user's user id? : Sql server database administration
What are distributed partitioned views?
What is 1nf 2nf and 3nf?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How can I know what locks are running on which resource?
What are logical/boolean operations in ms sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
Explain table valued parameters in sql server? Why tvp used?
