DATABASE QUESTION In your database you have the CUSTOMER tab

DATABASE QUESTION

In your database, you have the CUSTOMER table to record and maintain information related to your customers. The CUSTOMERNUMBER column is the primary key for this table. There is already a row in this table with CUSTOMER_NUMBER = 100. What is the outcome of an attempt to insert another row into this table with CUSTOMER NUMBER = 100? The system will remove the PRIMARY KEY definition from the CUSTOMER_NUMBER column and allow insertion of new row with CUSTOMER NUMBER = 100 A new row will be inserted into the table with CUSTOMER_NUMBER = 100 The existing row with CUSTOMER NUMBER = 100 will be replaced with the new row All the rows with CUSTOMER_NUMBER = 100 will be deleted Attempt to insert the new row will fail

Solution

As specified, CUSTOMER table has a primary key CUSTOMER_NUMBER, and there is a key value 100.

When you attempt to insert another row into this table, with a duplicate value,

E) Attempt to inser the new row will fail. SQL will return an error specifying that, the key value readily exists. Note that, Primary Key is not allowed to have duplicates.