Column2 - Study guides, Class notes & Summaries

WGU C170 Focused on MSQL Code Problem Set Exam Questions with Complete Answers 2024/2025 Create a brand-new table. - correct answer CREATE TABLE tableName ( column1 datatype, column2 datatype, column3 datatype Delete an entire table along with all the table rows from a database. - correct answer DROP TABLE tableName; Data Type: Integer with range 0-255 - correct answer TINYINT UNSIGNED Data Type: Integer with range 0-65,535 - correct answer SMALLINT UNSIGNED Data Type: Integ...

WGU - D427 - SQL SYNTAX EXAMS QUESTIONS WITH CORRECT VERIFIED ANSWERS What are the three clauses for ALTER TABLE? ADD, CHANGE, DROP ADD syntax ADD ColumnName DataType CHANGE syntax CHANGE CurrentColumnName NewColumnName NewDataType DROP syntax DROP ColumnName What punctuation mark ends a SQL statement? ; (Semicolon) What are the two clauses for INSERT? INTO (optional), VALUES INSERT syntax INSERT [INTO] TableName (Column1, Column2, ...) VALUES (Value1, Value2, ...); DEFAULT cons...

WGU Data Management - Applications - C170 OA GSA1 Questions and Answers Add New Row INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:07 / 0:15 Full screen Delete Row DELETE FROM table_name WHERE condition; Inner Join SELECT column_name(s)...

WGU - D427 - SQL SYNTAX EXAMS QUESTIONS WITH CORRECT VERIFIED ANSWERS What are the three clauses for ALTER TABLE? ADD, CHANGE, DROP ADD syntax ADD ColumnName DataType CHANGE syntax CHANGE CurrentColumnName NewColumnName NewDataType DROP syntax DROP ColumnName What punctuation mark ends a SQL statement? ; (Semicolon) What are the two clauses for INSERT? INTO (optional), VALUES INSERT syntax INSERT [INTO] TableName (Column1, Column2, ...) VALUES (Value1, Value2, ...); DEFAULT cons...

Add New Row - -INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row - -UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row - -DELETE FROM table_name WHERE condition; Inner Join - -SELECT column_name(s)

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

Add/remove Primary key to table - correct answer ALTER TABLE table_name ADD PRIMARY KEY (column_name) remove a primary key from a table - correct answer ALTER TABLE table_name DROP PRIMARY KEY; Add Foreign Key - correct answer ALTER TABLE Orders ADD FOREIGN KEY (PersonID) REFERENCES Persons(PersonID); Remove Foreign Key - correct answer ...

The SELECT statement is used to select data from a database. The result is stored in a result table, called the result-set. correct answers SELECT column_name,column_name FROM table_name; SELECT * FROM table_name; The SELECT DISTINCT statement is used to return only distinct (different) values correct answers SELECT DISTINCT column_name,column_name FROM table_name; The WHERE clause is used to extract only those records that fulfill a specified criterion. correct answers SELECT colu...

WGU Data Management - Applications - CAdd 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; 170 OA GSA1accurate 100%

Add New Row - correct answer INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row - correct answer UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row - correct answer DELETE FROM table_name WHERE condition; Inner Join - correct answer SELECT column_name(s)