Suppose you want to implement the following relationships while designing tables. How would you do it?
a.) One-to-one
b.) One-to-many
c.) Many-to-many
Submitted by: Administratora.) One-to-One relationship - can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
b.) One-to-Many relationships - by splitting the data into two tables with primary key and foreign key relationships.
c.) Many-to-Many - by using a junction table with the keys from both the tables forming the composite primary key of the junction table.
Submitted by: Administrator
b.) One-to-Many relationships - by splitting the data into two tables with primary key and foreign key relationships.
c.) Many-to-Many - by using a junction table with the keys from both the tables forming the composite primary key of the junction table.
Submitted by: Administrator
Read Online SQL Database Concepts Job Interview Questions And Answers
Top SQL Database Concepts Questions
| ☺ | Explain what are Magic tables in SQL Server? |
| ☺ | Do you know how to send email from database? |
| ☺ | How to search for a string in all stored procedure in SQL Server? |
| ☺ | Explain how to use Linked Server? |
| ☺ | Explain difference between cross join and Full outer join? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
