WGU C170 - Data Management Applications Questions and answers. VERIFIED.
WGU C170 - Data Management Applications Questions and answers. VERIFIED. 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.
Written for
- Institution
- Western Governors University
- Course
- WGU C170 Data Management
Document information
- Uploaded on
- August 23, 2023
- Number of pages
- 3
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
wgu c170 data management applications questions
