Interested to Buy Any Domain ? << Click Here >> for more details...
what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 17037 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / monal
Joins: Joins are used to retrieve data from two or more
tables when there is either matching row exist in another
table or not.
Primary Key: Primary key ensures uniqueness of data in a
table so that no two rows in the table can have same value.
Foreign Key: Foreign key ensures that data entered in a
column must be checked with data already entered in the
primary key column of another table.
Candidate Key: In some tables there is possibility that more
than one column can carry unique values to make sure
uniqueness of data all across the table. one of those key
column becomes Primary key and other column become candidate
key.
| Is This Answer Correct ? | 39 Yes | 9 No |
Post New Answer View All Answers
How can you insert null values in a column while inserting the data?
What are the kinds of subquery?
How to transfer data from a cursor to variables with a "fetch" statement?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How to use subqueries with the exists operators in ms sql server?
Can you roll back the ddl statement in a trigger?
Explain log shipping?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Does sql server use t sql?
optimization techinques
What is meant by dirty read?
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 a database in ms sql server?
How do you delete duplicate records in sql server?
Do you know what is a with(nolock)?
