WGU Data Management - Applications - C170 OA GSA1 Questions With 100% Correct Answers.

Add New Row - Answer-INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row - Answer-UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row - Answer-DELETE FROM table_name WHERE condition; Inner Join - Answer-SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW - Answer-CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate - Answer-CONCAT(Col1, Col2) AS NewColumnName; Create Index - Answer-CREATE INDEX index_name ON table_name (column1, column2, ...); Create Database - Answer-CREATE DATABASE databasename;Drop Database - Answer-DROP DATABASE databasename; Create Table - Answer-CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... ); Set Primary Key - Answer-CREATE TABLE Persons ( ID int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int, PRIMARY KEY (ID) ); Set Foreign Key - Answer-CREATE TABLE Orders ( OrderID int NOT NULL, OrderNumber int NOT NULL, PersonID int, PRIMARY KEY (OrderID), FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) );