Question: If a primary key is not a unique number for each ID entered in as part of the INSERT command, an error message will be
If a primary key is not a unique number for each ID entered in as part of the INSERT command, an error message will be displayed.
Question 1 options:
| True | |
| False |
Question 2 (0.5 points)
This table has been created (Database Schema) and populated with values listed in RESULTS.
| Database Schema vehicletype 10 rows Id (PK) INTEGER typeofvehicle TEXT manufacturer TEXT year INTEGER inventoryonhand INTEGER | RESULTS
|
Which of the following commands would result in a value of 6 (six) being displayed?
Question 2 options:
|
|
SELECT MIN(inventoryonhand) FROM vehicletype;
|
|
|
SELECT MAX(inventoryonhand) FROM vehicletype;
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
