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
- 18446 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
Which are the olap features?
Why use “in” clause in sql server?
Can multiple columns be used in sql group by clause in ms sql server?
What is difference between after and before?
How to include text values in sql statements?
Is sql server a database?
What are the different index configurations a table can have?
What is spatial and temporal data?
What is the difference between having clause and where clause in sql server?
What are the differences between union, intersect, and minus operators?
What is Lock table in SQL?
How to test odbc dsn connection settings?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is a collation in ms sql server?
Define model database?
