Question: A database administrator can create a basic table for customers starting with just first and last name information by running the SQL statement _ _

A database administrator can create a basic table for customers starting with just first and last name information by running the SQL statement ____.
a.
CREATE TABLE CUSTOMER (CUST_ID INTEGER,FNAME CHAR (5),LNAME CHAR(5),PRIMARY KEY (CUST_ID));
b.
CREATE TABLE CUSTOMER (CUST_ID INTEGER,FNAME CHAR (30),LNAME CHAR(30),PRIMARY KEY (CUST_ID));
c.
CREATE TABLE CUSTOMER (PRIMARY KEY (CUST_ID INTEGER),FNAME CHAR (30),LNAME CHAR(30));
d.
CREATE TABLE CUSTOMER (FNAME CHAR (30),LNAME CHAR(30),PRIMARY KEY (CUST_ID));

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!