12.2k views
0 votes
Which of the following creates a new table called 'game_scores' with 2 columns 'player_name' and 'player_score'?

(a) CREATE TABLE game_scores (
player_name string(45),
player_score integer(10)
);

(b) NEW TABLE (
player_name varchar(45),
player_score int(10)
) AS game_scores;

(c) NEW TABLE game_scores (
player_name varchar(45),
player_score int(10)
);

(d) CREATE TABLE (
player_name varchar(45),
player_score int(10)
) AS game_scores;

(e) CREATE TABLE game_scores (
player_name varchar(45),
player_score int(10)
);

1 Answer

4 votes

Answer:

e

Step-by-step explanation:

the valid sql syntax for creating table is

CREATE TABLE table_name (

column_name column_type

)

varchar and int are the valid sql types not string and integer

AS is used in select queries to aggregate results under given name

User William Patton
by
8.7k points

Related questions