What is the SQL statement needed to insert a new field in the Student table that would store the total number of credits each student has accumulated? What data type should we use, and why?

What will be an ideal response?

```
ALTER TABLE Student ADD credits TINYINT;
A TINYINT can be used because the number of credits a student has remains a relatively small number.

```

Computer Science & Information Technology

You might also like to view...

When using Windows 10, ________ enables you to manage your files and folders by showing the location and contents of every drive, folder, and file on your computer

A) Finder B) Internet Explorer C) System D) File Explorer

Computer Science & Information Technology

If you want to insert all the text from one document into another document, use the ________ button

A) Quick Parts B) Open C) Insert Object D) Insert File

Computer Science & Information Technology