WGU D426/D427 Syntax Test Answered Correctly | Latest Update

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