Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146546 Views
- IAS, IBM, I also Faced
- E-Mail Answers
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
What are the key features of dbms?
Explain about normal forms?
Explain about the storage and physical database design?
What are data modelling techniques?
Explain what a database is?
Explain about the relational database?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What are the 18 schemas?
How to use timestamp datatypes
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
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?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How is data stored in dbms?
How to use online Backups?
