WGU - D427 - SQL SYNTAX EXAMS QUESTIONS WITH
CORRECT VERIFIED ANSWERS
What are the three clauses for ALTER TABLE?
ADD, CHANGE, DROP
ADD syntax
ADD ColumnName DataType
CHANGE syntax
CHANGE CurrentColumnName NewColumnName NewDataType
DROP syntax
DROP ColumnName
What punctuation mark ends a SQL statement?
; (Semicolon)
What are the two clauses for INSERT?
INTO (optional), VALUES
INSERT syntax
INSERT [INTO] TableName (Column1, Column2, ...) VALUES (Value1, Value2, ...);
DEFAULT constraint
CORRECT VERIFIED ANSWERS
What are the three clauses for ALTER TABLE?
ADD, CHANGE, DROP
ADD syntax
ADD ColumnName DataType
CHANGE syntax
CHANGE CurrentColumnName NewColumnName NewDataType
DROP syntax
DROP ColumnName
What punctuation mark ends a SQL statement?
; (Semicolon)
What are the two clauses for INSERT?
INTO (optional), VALUES
INSERT syntax
INSERT [INTO] TableName (Column1, Column2, ...) VALUES (Value1, Value2, ...);
DEFAULT constraint
