Computer Science > QUESTIONS & ANSWERS > WGU - C170 - Data Management Applications Questions and Answers Rated A (All)

WGU - C170 - Data Management Applications Questions and Answers Rated A

Document Content and Description Below

WGU - C170 - Data Management Applications Questions and Answers Rated A Create Database Syntax ✔✔CREATE DATABASE db_name; Simple SFW query syntax ✔✔SELECT * FROM db_name 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 ( column1 data_type(size) PRIMARY KEY (column1) ); Create Index Syntax ✔✔CREATE INDEX index_name ON table_name(column_name) Insert syntax ✔✔INSERT INTO table_name VALUES (value1,value2,value3,...); Grant command syntax ✔✔GRANT privileges ON object TO user; Drop Syntax: Table, Index, Datab [Show More]

Last updated: 3 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: