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 ?
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 do I start sql server agent automatically?
What is snapshot replication?
What are the operating modes in which database mirroring runs?
How to list all tables in the database using odbc_tables()?
What is bit data type? What's the information that can be stored inside a bit column?
List out the difference between union and union all in sql server?
How secure is sql server database?
Can I use sql azure as a backup with log shipping or database mirroring?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Why do you need a sql server?
Can sql servers link to other servers?
How to transfer a table from one schema to another?
How exceptions can be handled in sql server programming?
What is a sql join?
What are orphan records?