Self review: Practicing table creation

You need to create a table called "Players". The table must contain two columns. The first column is called "playername" and holds the names of each player as a text data type. The second column is called "playerAge" and contains the age of each player as a whole number value. Identify the correct syntax to create this table. a. CREATE TABLE Players ( playerName VARCHAR(100), playerAge INT ); b. CREATE TABLE Players ( playerName VARCHAR(100), playerAge DECIMAL );

a. CREATE TABLE Players ( playerName VARCHAR(100), playerAge INT );

Which of the following SQL statements can be used to build a table that stores data about cell phone products? a. CREATE TABLE cell_phone ( name VARCHAR(100), productionDate DATE, price DECIMAL ); b. CREATE TABLE cell_phone ( name VARCHAR(), productionDate DATE, price DECIMAL);

a. CREATE TABLE cell_phone ( name VARCHAR(100), productionDate DATE, price DECIMAL );

Which of the following SQL syntax statements can you use to create a table? Select all that apply. a. CREATE TABLE table_name; b. CREATE TABLE table name; c. create table table_name; d. CREATE table_name TABLE;

a. CREATE TABLE table_name; c. create table table_name;

Select all steps to create a table in the database. a. Select a database. b. Use the CREATE TABLE command. c. Write the table name. d. Define the columns of the table with relevant data types. e. Use the FROM keyword.

a. Select a database. b. Use the CREATE TABLE command. c. Write the table name. d. Define the columns of the table with relevant data types.

Identify which of the following SQL statements can be used to create a table called "Products" for an online store. The table must contain two columns named "ID" and "Quantity." The values within both columns must be whole numbers. a. CREATE TABLE products (ID CHAR, quantity VARCHAR); b. CREATE TABLE products (ID INT, quantity INT);

b. CREATE TABLE products (ID INT, quantity INT);