Database Management > QUESTIONS & ANSWERS > WGU - C170 - Data Management Applications, Questions with accurate answers, rated A+ (All)

WGU - C170 - Data Management Applications, Questions with accurate answers, rated A+

Document Content and Description Below

WGU - C170 - Data Management Applications, Questions with accurate answers, rated A+ Create Database Syntax - ✔✔-CREATE DATABASE db_name; Simple SFW query syntax - ✔✔-SELECT * FROM db_na... me WHERE column_name operator value; Cardinality: Inside or outside? - ✔✔-Outside Modality: Inside or outside? - ✔✔-Inside What commands are used with data definition? - ✔✔-create, alter, drop, truncate, comment, rename What commands are used with data manipulation? - ✔✔-Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax - ✔✔-CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), ); What does AUTO_INCREMENT attribute do for numeric values? - ✔✔-It generates a series of unique identifier values. CREATE VIEW SYNTAX - ✔✔-CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Primary Key Syntax - ✔✔-CREATE TABLE table_name [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: