DATA ANALYSIS > EXAM > WGU - C170 - Data Management Applications 2023/2024 (All)

WGU - C170 - Data Management Applications 2023/2024

Document Content and Description Below

Create Database Syntax Ans- CREATE DATABASE db_name; Simple SFW query syntax Ans- SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Ans- Outside Modality: Insi ... de or outside? Ans- Inside What commands are used with data definition? Ans- create, alter, drop, truncate, comment, rename What commands are used with data manipulation? Ans- Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax Ans- CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), ); What does AUTO_INCREMENT attribute do for numeric values? Ans- It generates a series of unique identifier values. CREATE VIEW SYNTAX Ans- CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Primary Key Syntax Ans- CREATE TABLE table_name ( column1 data_type(size) PRIMARY KEY (column1) ); Create Index Syntax Ans- CREATE INDEX index_name ON table_name(column_name) Insert syntax Ans- INSERT INTO table_name VALUES (value1,value2,value3,...); Grant command syntax Ans- GRANT privileges ON object TO user; Drop Syntax: Table, Index, Database Ans- DROP TABLE table_name; ALTER TABLE table_name DROP INDEX index_name; DROP DATABASE database_name Count() Syntax Ans- 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 Ans- Returns all rows when there is at least one match in BOTH tables Left Join Description Ans- Return all rows from the left table, and the matched rows from the right table Right Join Description Ans- Return all rows from the right table, and the matched rows from the left table Full Join Description Ans- Return all rows when there is a match in ONE of the tables Join Syntax Ans- SELECT columns FROM table1 INNER/LEFT/RIGHT/FULL JOIN table2 ON table1.column = table2.column; IN description & syntax Ans- allows you to specify multiple values in a WHERE clause SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...); LIKE description & syntax Ans- Used to search for a specified pattern in a column SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: