Using MySQL create a schema name it Assignment10 then create a table named Quiz as follows:

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

The Quiz table stores multiple-choice questions. Suppose the multiple-choice questions are stored in the attached text file Quiz.text in the following format:

1. question1

2. choice a

3. choice b

4. choice c

5. choice d

Answer: cd

2. question2

3. choice a

4. choice b

5. choice c

6. choice d

Answer: a

..

Write a program that reads the data from the file and populate it into the Quiz table

Quiz.txt

1. ________ is the physical aspect of the computer that can be seen. a. Hardware b. Software c. Operating system d. Application program Answer:a

2. __________ is the brain of a computer. a. Hardware b. CPU c. Memory d. Disk Answer:b

3. The speed of CPU is measured in __________.

public class A {

}

a. megabytes b. gigabytes c. megahertz d. gigahertz Answer:cd

4. Why do computers use zeros and ones? a. because combinations of zeros and ones can represent any numbers and characters. b. because digital devices have two stable states and it is natural to use one state for 0 and the other for 1. c. because binary numbers are simplest. d. because binary numbers are the bases upon which all other number systems are built. Answer:b

5. One byte has ________ bits. a. 4 b. 8 c. 12 d. 16 Answer:b

6. A 3.5-inch floppy can hold up to _________ bytes. a. 0.5 MB. b. 1.44 MB. c. 10 MB. d. 100 MB. Answer:b

7. A regular CD-ROM can hold up to _________ bytes. a. 100 MB. b. 700 MB. c. 1 GB. d. 10 GB. Answer:b

8. ____________ is a device to connect a computer to a local area network (LAN). a. regular modem b. DSL c. Cable modem d. NIC Answer:d

9. ____________ are instructions to the computer. a. Hardware b. Software c. Programs d. Keyboards Answer:bc