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 
Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box. 

Again if we select multiple items in second listbox then the
related to those selected items should display . 

In this scenario how will you design database,tables?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
Answer
# 1		 
e.g. create two table 
1-department(dept_id int PK,dept_name)
2-employee(emp_id int Primary key,Name varchar(40),dept_id 
FK)

now create two listbox employee and department.

step1-when multiple departments are selected...dispaly 
employee related to selected department in employee listbox

step2-when multiple employees are selected...dispaly 
respective department in department listbox
 
Is This Answer Correct ?    0 Yes 0 No
Pawan K. Dubey
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
i need some interview questions on sql server developer plz any onee send some links.  1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  16
In which year relase the 7.0& 2000 & 2005?  1
what is the difference between Delete and Truncate Geo-Research-Centre3
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query Wipro3
What is referential integrity? What are the advantages of it? Digital-Domain3
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?  4
What are defaults? Is there a column to which a default can't be bound?  2
How do you measure the performance of a stored procedure? Infosys1
Name three version of sql server 2000 and also their differences?  1
How to select Distinct columns from the table, table having 20 columns and i want all coulmns Wipro3
Plz tell about backup&recovery?  2
to explain sql server 2000 architecture & authentication  1
IN Vs OR operator which is best to use sql server.  3
What is the appropriate number of test cases that you can write on a database? Microsoft1
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?  7
What is an Index? Yardi-Software3
can you any body tell me the difference between candidate key and primary key  4
What is normalization and what are the different forms of normalizations?  1
What do u mean by orphan users, how will u list them in the DB IBM2
 
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