Which attributes of columns in a table must always be defined in a CREATE TABLE statement?1 puntoDatatype and number of columns Datatype and Primary Key constraint Name and datatypeName and Primary Key constraint

Which of the following do you need to consider when you make a table in SQL?a.Data typesb.Primary keysc.Default valuesd.All of the mentioned

Which one of the following statements is used to create a table?Group of answer choicesCREATE TABLE table_name (column_type column_name);CREATE table_name (column_type column_name);CREATE table_name (column_name column_type);CREATE TABLE table_name (column_name column_type);

Which of the following are constraints that can be used with the create table command?Select one:a.references, alias, checkb.null, primary key, view ofc.primary key, not null, uniqued.primary key, default, between

What is the correct syntax for creating a new table in MySQL?NEW TABLE table_name (column1 datatype, column2 datatype, ...);CREATE NEW TABLE table_name (column1 datatype, column2 datatype, ...);CREATE TABLE table_name (column1 datatype, column2 datatype, ...);ADD TABLE table_name (column1 datatype, column2 datatype, ...);

In data definition language (DDL), which of the following statements can be used to add a primary key to a table?CREATE TABLE Artists ADD 'artist_pk' AS PRIMARY KEY (artistID)ADD CONSTRAINT 'artist_pk' PRIMARY KEY (artistID) ALTER TABLE Artists PRIMARY KEY (artistID)ALTER TABLE Artists ADD PRIMARY KEY (artist_pk);