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
- 16591 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 is difference between equi join and inner join?
What do you mean by a dependent functionality in a build?
Explain various On-Delete options in a DB table. Which is the default option?
What are drilldown reports?
What triggers long term care?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is implicit mode in sql server?
What types of replication are supported in sql server?
What is inner join? Explain with an example?
Can I use sql azure as a backup with log shipping or database mirroring?
How column data types are determined in a view?
What are the functions in sql server?
What's the information that can be stored inside a bit column?
What is difference between equi join and natural join?
What is molap and its advantage? : sql server analysis services, ssas
