Create a table named Quiz as follows:

The Quiz table stores multiple-choice questions. Suppose the multiple-choicequestions are stored in a text file accessible from www.cs.armstrong.edu/liang/data/ Quiz.txt in the following format:1. question1a. choice ab. choice bc. choice cd. choice d

Answer:cd

2. question2a. choice ab. choice bc. choice cd. choice dAnswer:a...Write a program that reads the data from the file and populate it into the Quiz table.

Transcribed Image Text:

create table Quiz( questionId int, question varchar(4000), choicea varchar(1000), choiceb varchar(1000), choicec varchar(1000), choiced varchar(1000) , answer varchar(5));