WGU - C170 - Data Management Applications Exam Questions with Correct Answers

Create Database Syntax Correct Answer CREATE DATABASE db_name; Simple SFW query syntax Correct Answer SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Correct Answer Outside Modality: Inside or outside? Correct Answer Inside What commands are used with data definition? Correct Answer create, alter, drop, truncate, comment, rename What commands are used with data manipulation? Correct Answer Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax Correct Answer CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), ); What does AUTO_INCREMENT attribute do for numeric values? Correct Answer It generates a series of unique identifier values. CREATE VIEW SYNTAX Correct Answer CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Primary Key Syntax Correct Answer CREATE TABLE table_name (