WGU Data Management - Applications -
C170 OA GSA1 Question and answers
verified to pass
Add New Row - correct answers INSERT INTO table_name (column1,
column2, ...)
VALUES (value1, value2, value3, ...);
Update Row - correct answers UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Delete Row - correct answers DELETE FROM table_name
WHERE condition;
Inner Join - correct answers SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
CREATE VIEW - correct answers CREATE VIEW viewname AS
SELECT Col1, Col2
FROM table
WHERE condition;
Concatenate - correct answers CONCAT(Col1, Col2) AS NewColumnName;
C170 OA GSA1 Question and answers
verified to pass
Add New Row - correct answers INSERT INTO table_name (column1,
column2, ...)
VALUES (value1, value2, value3, ...);
Update Row - correct answers UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Delete Row - correct answers DELETE FROM table_name
WHERE condition;
Inner Join - correct answers SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
CREATE VIEW - correct answers CREATE VIEW viewname AS
SELECT Col1, Col2
FROM table
WHERE condition;
Concatenate - correct answers CONCAT(Col1, Col2) AS NewColumnName;
