Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 10 Answers
- 18566 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
How to get the query of a table in sql server?
What are partitioned views?
What is a transact-sql statement?
What are the steps to insert a table?
What is 5nf in normalization form?
How to defragment table indexes?
What is sparse columns of sql server 2008?
How to write a query with an inner join in ms sql server?
What is a full text index?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is an identity column in insert statements?
Does sql server 2000 full-text search support clustering?
What are system databases into sql server (2005/2008) : sql server database administration
What is a primary index?
Explain the benefits of user-defined functions?
