Define candidate key, alternate key, composite key.
Answers were Sorted based on User's Feedback
Answer / unknown
If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.
Is This Answer Correct ? | 18 Yes | 28 No |
Answer / mustafa
How do we specify an ALTERNATE KEY while creating a table?
Is This Answer Correct ? | 15 Yes | 30 No |
Answer / jheelum
A CANDIDATE KEY ISA PRIMERY KEY. OTHER ARE ALTERNATE KEY
Is This Answer Correct ? | 26 Yes | 82 No |
What is the difference between delete and truncate statements?
What is the filtered index?
What is a virtual table in sql?
Explain the steps to create and execute a user-defined function in the sql server?
Where can you add custom error messages to sql server?
Does index slows down insert statements?
What are the advantages of user-defined functions over stored procedures in sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
Can anybody explain me cold backup and hot backup?
How adventureworkslt tables are related?
Can you explain what are various ways to enhance the ssrs report?