WGU D426/D427 Syntax questions with verified answers

WGU D426/D427 Syntax questions with verified
answers
Add a column to a table Ans✓✓✓-ALTER TABLE TableName
ADD ColumnName DataType;


Aggregate function (multi-value (summary) output) Ans✓✓✓-SELECT
LabelsColumn, FUNCTION(DataColumn)
FROM TableName
GROUP BY LabelsColumn;


Aggregate function (single value output) Ans✓✓✓-SELECT Function(Column) AS
NewColumnName
FROM TableName;


Apply a hierarchal sort using multiple columns Ans✓✓✓-SELECT Column1,
Column2
FROM TableName
ORDER BY Column1, Column2;


Create a Table Ans✓✓✓-CREATE TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
ColumnName3 DataType,
...
);

, Create a table with complex constraints on numerical or date columns Ans✓✓✓-
CREATE TABLE TableName (
ColumnName1 DataType CHECK (ColumnName Condition),
ColumnName2 DataType CHECK (ColumnName Condition)
);


Create a table with complex constraints on string columns Ans✓✓✓-CREATE
TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
CHECK (ColumnName1 Constraint),
CHECK (ColumnName2 Constraint)
);


Create a table with constraint functions Ans✓✓✓-CREATE TABLE TableName (
ColumnName1 DataType Constraint1 Constraint2,
ColumnName2 DataType Constraint1
);


Create a view Ans✓✓✓-CREATE VIEW ViewName AS
SELECT Column1, Column2, Column3...
FROM TableName;