WGU - C170 - Data Management Applications exam (100% correct and graded A+)

Create Database Syntax - Answer-CREATE DATABASE db_name; Simple SFW query syntax - Answer-SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? - Answer-Outside Modality: Inside or outside? - Answer-Inside What commands are used with data definition? - Answer-create, alter, drop, truncate, comment, rename What commands are used with data manipulation? - Answer-Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax - Answer-CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), ); What does AUTO_INCREMENT attribute do for numeric values? - Answer-It generates a series of unique identifier values. CREATE VIEW SYNTAX - Answer-CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Primary Key Syntax - Answer-CREATE TABLE table_name( column1 data_type(size) PRIMARY KEY (column1) ); Create Index Syntax - Answer-CREATE INDEX index_name ON table_name(column_name) Insert syntax - Answer-INSERT INTO table_name VALUES (value1,value2,value3,...); Grant command syntax - Answer-GRANT privileges ON object TO user; Drop Syntax: Table, Index, Database - Answer-DROP TABLE table_name; ALTER TABLE table_name DROP INDEX index_name; DROP DATABASE database_name Count() Syntax - Answer-SELECT COUNT(column_name) FROM table_name; returns # of values in a column SELECT COUNT(*) FROM table_name; returns number of records in a table Inner Join Description - Answer-Returns all rows when there is at least one match in BOTH tables Left Join Description - Answer-Return all rows from the left table, and the matched rows from the right table