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
State the acid rules?
What are the three basic rules which are to be followed for the relational model of the database?
Write the fastest query to find out how many rows exist in a table?
Explain about query and reporting.
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is a database development?
How to use online Backups?
Explain the cube operator?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
Who are end users in dbms?
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 is DB Development software?
Explain about post-relational databases?
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 to read and create .LDC data files which are used by linguatic dictionary.