Can we have more then primary Key in table ? Answer : We can't us

1. What are the grouping function in SQL ?

2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?

3. Difference between DROP, DELETE, TRUNCATE table ?

4. What is constraints and types ?

5. What is max size of nchar & nvarchar ?

6. Define ROLLBACK, COMMIT, SAVE POINT

7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise

8. Select 10 rows from a table ?

9. Define DML, DDL, DCL, DTL commands ?

10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?

11. Default constraints ?

12. Can we have more then primary Key in table ?

13. Type of integrity ? Entity, Referential, Domain ?

Question Posted / srivas

10 Answers
18182 Views
Perot Systems, I also Faced
E-Mail Answers

Answer Posted / srivas

Can we have more then primary Key in table ?

Answer : We can't use more than one Primary key in a
table because Primary key is Unique Value.

Is This Answer Correct ?

6 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which are the new data types introduced in sql server 2008?

844

Why is replication required on the sql server?

1010

What is the difference between web edition and business edition?

111

Is it possible to replicate data from sql server to oracle? : sql server replication

1036

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1007

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

901

What are the different types of indexes?

1049

How do I find the transaction log size in sql server?

917

what is the system function to get current user's user id? : Sql server database administration

951

What is scan table/view and seek table/view when its occurs? : sql server database administration

987

What are the methods used to protect against sql injection attack?

1001

Why main is user defined function?

954

What is trace flag in sql server?

977

role of sql sever 2005 in database rather than any other database

1889

Write a SQL query to delete a table?

1080