How to store passage type questions and answers in sqlserver

Question

I am started doing a project :- Online Exam in ASP.NET with C# database:- SQL Server The exam consists of different sections such as Reasoning Quantitative Aptitude & Numerical ability English and Mathematics. The exam is of objective type like fill in the blacks option type and passage type. The question table consist of the following columns: QidQuestionOption1Option2Option3Option4correctAnswer The problem is how do I store passage type questions and answers in table??Because it will contain one long passage and based on that more than one questions will be asked with multiple choice options.

ali tuncer · Answer

keep the passages in a different table put a new column in question table called passageID...if passageID is not null display the corresponding passage from passage table..