WGU C170 Test questions & Answers. Graded A+. VERIFIED.

WGU C170 Test questions & Answers. Graded A+. VERIFIED. ON DELETE SET NULL A setting when creating a foreign key that says if a record in the parent table is deleted, then the corresponding records in the child table have their key value set to NULL. ON DELETE RESTRICT A setting when creating a foreign key that says when data is removed from a parent table and there is a Foreign Key associated with the child table you will receive an error or it will fail to delete. ON DELETE CASCADE A setting when creating a foreign key that says if a record in the parent table is deleted, then the corresponding records in the child table are also deleted. CREATE DATABASE IF NOT EXISTS command to create database only if it does not already exist CREATE TABLE new_table_name LIKE original_table_name; create an empty copy of a table INSERT INTO new_table_name ON DELETE SET NULL A setting when creating a foreign key that says if a record in the parent table is deleted, then the corresponding records in the child table have their key value set to NULL. ON DELETE RESTRICT A setting when creating a foreign key that says when data is removed from a parent table and there is a Foreign Key associated with the child table you will receive an error or it will fail to delete. ON DELETE CASCADE A setting when creating a foreign key that says if a record in the parent table is deleted, then the corresponding records in the child table are also deleted. CREATE DATABASE IF NOT EXISTS command to create database only if it does not already exist CREATE TABLE new_table_name LIKE original_table_name; create an empty copy of a table INSERT INTO new_table_name