Define the one-to-one relationship while designing tables.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  


What is a collation?

0 Answers  


What is equi join with example?

0 Answers  


What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,


can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  






Does a full backup include transaction log?

0 Answers  


Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  


How to use union to merge outputs from two queries together in ms sql server?

0 Answers  


Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,


What is the difference between createstatement and preparedstatement?

0 Answers  


What are views used for?

0 Answers  


How many nested transaction can possible in sql server?

3 Answers   Bank Of America,


Categories