ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
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;"
 Question Submitted By :: Balu.kopparapu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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;"
Answer
# 1
1.No.In a table only one primary key.we have to use the
behavior of primary key i.e in a colon to set unique key and
not null.
2.Cluster index is the leaf node directly consist a values.
and non cluster index is the leaf node consists address of
value at same task or heap. 
3.No
 
Is This Answer Correct ?    2 Yes 4 No
Kishore
 
  Re: 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;"
Answer
# 2
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 ?    6 Yes 0 No
Debi
 
 
 
  Re: 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;"
Answer
# 3
1. A table can only have one primary key.
2. Answer #1 is right. To add it, primary key is clustered
index and when we index a column (non-primary key) it is
non-clustered index.
3. Yes this will act almost as OUTER join
 
Is This Answer Correct ?    2 Yes 0 No
Koushik Roy
 
  Re: 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;"
Answer
# 4
1.We cant see more than one primary key for the table,
however we could create composite index using clustered
index in a table.
2.Clustered index - Order the data in the physical order.
Non clustered index does not order the data
3.We can select both the table using that script which u
mentioned.
 
Is This Answer Correct ?    0 Yes 1 No
Prasanna
 
  Re: 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;"
Answer
# 5
1)No We can't have more than 1 primary key. Even if you try
to save it will pop an error message and nothing will be stored.
2)Clustered Index is attached with Unique. A table can have
1 and only 1 Clustered Index and it will be mostly created
on the Primary Key of the Table. 
Non Clustered can be up to 254(not sure about the
number)created for a single table.
3)You can definitely select from 2 tables but all the
columns will be merged. Please check how you want the data
from those 2 tables
 
Is This Answer Correct ?    1 Yes 1 No
Ramya
 
  Re: 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;"
Answer
# 6
1. No.

2.when create primary key on a table clustered index 
automatically created.1 clustered index is possible for a 
table.
when we create a unique key on table Non clustered index 
automatically created. 253 non clustered indexes are 
possible for a table.

3. yes (its not recommended)
 
Is This Answer Correct ?    0 Yes 0 No
Madhusudan Bowenpalli
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is Transaction?  2
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages. 247Customer3
what is difference between primary key and Unique  8
How to Execute an Operating System Command From Within SQL Server ?  2
What is the difference between windows authentication and sql server authentication HCL4
How to work on DTS?what is the main requirement? ivan1
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  2
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
UPDATE statement can on a single table or on the multiple table? iGate5
what is the query and condition to delete datas in sql server.  2
what is physical sort data and logical sort data in index?  2
what is the difference between group and having give an example with query and sample output  2
Which is best Subquery (or) joins in sql server? explain why  2
What is normalization?  6
CLR Integration ? what is Notification services ? Satyam1
how to find nth highest salary NexGen30
WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT CTS10
Explain fundamentals of Data ware housing & OLAP?  1
Hi..here i would like to know the Backup and Restore models? HCL2
What types of integrity are enforced by a foreign-key constraint  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com