WGU - C170 - Data Management Applications Exam 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,...);
Document information
- Uploaded on
- October 22, 2023
- Number of pages
- 2
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
