Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which SQL DDL command is used to create an empty Delta table named 'players' with columns playerId (INT), playerName (STRING), and playerRuns (LONG), only if a table with this name does not already exist?
A
CREATE OR REPLACE TABLE players( playerId INT, playerName STRING, playerRuns LONG)USING DELTA;
B
CREATE TABLE IF NOT EXISTS players( playerId INT, playerName STRING, playerRuns LONG);
C
CREATE OR REPLACE TABLE players WITH COLUMNS( playerId INT, playerName STRING, playerRuns LONG)USING DELTA;
D
CREATE TABLE players IF NOT EXISTS( playerId INT, playerName STRING, playerRuns LONG)USING DELTA;
E
CREATE OR REPLACE TABLE players ASSELECT playerId INT, playerName STRING, playerRuns LONGUSING DELTA;
