WGU D426/D427 Syntax Test Answered Correctly | Latest Update
1. List all Databases SHOW DATABASES;
2. List all Tables in a data- USE Database;
base SHOW TABLES;
3. List all columns and SHOW COLUMNS
their properties in a FROM TableName;
table
4. Create a Table CREATE TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
ColumnName3 DataType,
...
);
5. Add a column to a table ALTER TABLE TableName
ADD ColumnName DataType;
6. Modify a column in a ALTER TABLE TableName
table CHANGE CurrentColumnName NewColumnName DateType;
7. Remove a column from ALTER TABLE TableName
a table DROP ColumnName;
8. Aggregate function (sin- SELECT Function(Column) AS NewColumnName
gle value output) FROM TableName;
9. Aggregate function SELECT LabelsColumn, FUNCTION(DataColumn)
(multi-value (summary) FROM TableName
output) GROUP BY LabelsColumn;
10. Insert new data into a INSERT INTO TableName
table (all columns) VALUES (Value1, Vaule2, Value3. );
1/5
, WGU D426/D427 Syntax Test Answered Correctly | Latest Update
11. Insert new data into a INSERT INTO TableName (Column1, Column2, Column3. )
table (not all columns) VALUES (Value1, Value2, Value3. );
12. Insert multiple rows of INSERT INTO TableName (Column1, Column2, Column3. )
data (not all columns) VALUES (Value1, Value2, Value3. ),
(Value1, Value2, Value3. ),
(Value1, Value2, Value3. );
13. Modify data in a table UPDATE TableName
(specific rows) SET ColumnName = NewValue
WHERE Condition;
14. Modify data in a table UPDATE TableName
(all rows) SET ColumnName = NewValue;
15. Remove data from a DELETE FROM TableName
table WHERE Condition;
16. Remove all data from a DELETE FROM TableName;
table
17. Set a primary key on an ALTER TABLE TableName
existing table ADD PRIMARY KEY (ColumnName);
18. Set a foreign key on an ALTER TABLE TableName
existing table ADD FORIEGN KEY (Column) REFERENCE Table (Column);
19. Create an index on a CREATE INDEX IndexName ON TableName (ColumnName);
table
20. Output all values from a SELECT * FROM TableName;
table
2/5
1. List all Databases SHOW DATABASES;
2. List all Tables in a data- USE Database;
base SHOW TABLES;
3. List all columns and SHOW COLUMNS
their properties in a FROM TableName;
table
4. Create a Table CREATE TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
ColumnName3 DataType,
...
);
5. Add a column to a table ALTER TABLE TableName
ADD ColumnName DataType;
6. Modify a column in a ALTER TABLE TableName
table CHANGE CurrentColumnName NewColumnName DateType;
7. Remove a column from ALTER TABLE TableName
a table DROP ColumnName;
8. Aggregate function (sin- SELECT Function(Column) AS NewColumnName
gle value output) FROM TableName;
9. Aggregate function SELECT LabelsColumn, FUNCTION(DataColumn)
(multi-value (summary) FROM TableName
output) GROUP BY LabelsColumn;
10. Insert new data into a INSERT INTO TableName
table (all columns) VALUES (Value1, Vaule2, Value3. );
1/5
, WGU D426/D427 Syntax Test Answered Correctly | Latest Update
11. Insert new data into a INSERT INTO TableName (Column1, Column2, Column3. )
table (not all columns) VALUES (Value1, Value2, Value3. );
12. Insert multiple rows of INSERT INTO TableName (Column1, Column2, Column3. )
data (not all columns) VALUES (Value1, Value2, Value3. ),
(Value1, Value2, Value3. ),
(Value1, Value2, Value3. );
13. Modify data in a table UPDATE TableName
(specific rows) SET ColumnName = NewValue
WHERE Condition;
14. Modify data in a table UPDATE TableName
(all rows) SET ColumnName = NewValue;
15. Remove data from a DELETE FROM TableName
table WHERE Condition;
16. Remove all data from a DELETE FROM TableName;
table
17. Set a primary key on an ALTER TABLE TableName
existing table ADD PRIMARY KEY (ColumnName);
18. Set a foreign key on an ALTER TABLE TableName
existing table ADD FORIEGN KEY (Column) REFERENCE Table (Column);
19. Create an index on a CREATE INDEX IndexName ON TableName (ColumnName);
table
20. Output all values from a SELECT * FROM TableName;
table
2/5
