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
- 18521 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
What do you understand by the denormalisation?
Explain cross join or cartesian product in sql?
What is implicit cursors?
What is tempdb database? : SQL Server Architecture
What is the difference between DataRow.Delete() and DataRow.Remove()?
How to invoke a trigger on demand?
How to create a large table with random data for index testing in ms sql server?
What is normalization and its types?
What are the different subsets of sql?
What is the Disadvantage of indexed sequential file.
What is the purpose of sql profiler in sql server? : sql server database administration
How the authentication mode can be changed?
What are the differences between clustered and non-clustered index?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How do I debug a stored procedure in sql server?
