D427 OA Example Questions

D427 OA Example Questions Leave the first rating Students also studied Terms in this set (13) Western Governors UniversityD 426 Save WGU - D427 - Data Management - ...66 terms helen_robertson4 Preview WGU - D427 Data Management - Ap...27 terms helen_robertson4 Preview C839v5/D334 Additional Practice Teacher 165 terms ShawnD_Preview Data M 107 term jed Practice questions for this set Learn1 / 7Study using Learn DROP INDEX index_name ON table_name; Add/remove Primary key to tableALTER TABLE table_name ADD PRIMARY KEY (column_name) remove a primary key from a tableALTER TABLE table_name

DROP PRIMARY KEY;

Choose an answer 1add an index to a table column2modify a table column type 3remove a constraint from a table column 4remove an index from a table column Don't know?

Add Foreign KeyALTER TABLE Orders ADD FOREIGN KEY (PersonID) REFERENCES Persons(PersonID); Remove Foreign KeyALTER TABLE Orders DROP FOREIGN KEY FK_PersonOrder; add a viewCREATE VIEW view_name AS SELECT column1, column2, ...FROM table_name WHERE condition;

REMEMBER AS PORTION

remove a viewDROP VIEW view_name; add an index to a table columnCREATE INDEX index_name ON table_name (column_name); remove an index from a table columnDROP INDEX index_name ON table_name; remove rows from a table based on conditions DELETE FROM table_name WHERE condition; remove rows from a table with specific valuesDELETE FROM table_name WHERE column_name = value; insert values into a tableINSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); update row values in a table based on conditions UPDATE table_name SET column1 = new_value1, column2 = new_value2, ...WHERE condition; add a column to an existing tableALTER TABLE table_name ADD column_name data_type;