WGU - C170 - Data Management Applications Exam Questions with Correct Answers
Create Database Syntax Correct Answer CREATE DATABASE db_name; Simple SFW query syntax Correct Answer SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Correct Answer Outside Modality: Inside or outside? Correct Answer Inside What commands are used with data definition? Correct Answer create, alter, drop, truncate, comment, rename What commands are used with data manipulation? Correct Answer Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax Correct Answer CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), ); What does AUTO_INCREMENT attribute do for numeric values? Correct Answer It generates a series of unique identifier values. CREATE VIEW SYNTAX Correct Answer CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Primary Key Syntax Correct Answer CREATE TABLE table_name (
Written for
- Institution
- WGU C170
- Course
- WGU C170
Document information
- Uploaded on
- October 7, 2023
- Number of pages
- 2
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
Also available in package deal