Define candidate key, alternate key, composite key?
Answer Posted / vishal sharma
hi, to all. In a interview i asked a question that
"How to apply practically candidate key in SQL SERVER ?
like for primary key we apply PRIMERY KEY keyword how to apply in SQL-SEVER ?"
Plz help me to solve this question Plzzzzzzzz
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Write short notes on manual refreshes.
Explain about the database management systems.
How to replace not in with not exist?
Explain the rollup operator?
What is normalization? Explain different levels of normalization?
Where is dbms used?
What is an application role and explain a scenario when you would use one?
fact table and dimension table containg one to many relationship or many to one relastionship
Explain what a database is?
What is database design and development?
What is the maximum length of an extended property?
How is data stored in dbms?
What is the physical representation for a many-to-many relationship?