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...

Client-side scripting is written with programs such as ____ or VBScript.

A. CGI B. JavaScript C. Perl D. SQL

Computer Science & Information Technology

Describe four of the six menu standards that should be followed when including a menu in an application.

What will be an ideal response?

Computer Science & Information Technology

You can use arithmetic operators to perform arithmetic operations on class objects.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

List and briefly describe the five default sections of a report.

What will be an ideal response?

Computer Science & Information Technology