Interested to Buy Any Domain ? << Click Here >> for more details...
1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;"
- 8 Answers
- 9219 Views
- I also Faced
- E-Mail Answers
Answer Posted / debi
1.no we can't set more than one primary key for a table
3. yes we can write a query like select 8 from table1,table2
this is generally used in case of cartesian product
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is apply operator in sql?
What command is used to delete a table from the database in the sql server and how?
What is subquery? Explain the properties of a subquery?
What is the data tier application?
explain different levels of normalization? : Sql server database administration
Describe in brief system database.
Can we hide the definition of a stored procedure from a use?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Do you know what are the differences between lost updates and uncommitted dependencies?
How do you create a clustered index?
How to enter unicode character string literals in ms sql server?
What are the advantages of using cte?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Explain optimistic and pessimistic concurrency?
How can you fetch alternate records from a table?
