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...
To change table attributes on the LAYOUT tab, click the ________ button
Fill in the blank(s) with correct word
Computer Science & Information Technology
Good coding practice dictates that elements within a statement should be separated by a space to make the statement easier to read, even though the space is not required.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology