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
- 18846 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
User wants only to display only pdf as export option in report manager. How to achieve this?
Why is sql server log file full?
How to get a list of columns using the "sys.columns" view in ms sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is difference between rownum and row_number?
What are “phantom rows”?
What is ems sql management studio? : sql server management studio
What is clustered primary key?
ow to bring suspect mode datbase online from scratch
Explain logical operators in sql server?
What is scalar user-defined function?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Please illustrate physical database architecture? : SQL Server Architecture
Is the order of columns in the set clause important in ms sql server?
what is database replicaion? : Sql server database administration
