Database Management > QUESTIONS & ANSWERS > WGU - C170 - DATA MANAGEMENT APPLICATIONS QUESTIONS WITH CORRECT ANSWERS (All)
WGU - C170 - DATA MANAGEMENT APPLICATIONS QUESTIONS WITH CORRECT ANSWERS
Document Content and Description Below
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? Corr... ect 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 [Show More]
Last updated: 2 years ago
Preview 1 out of 3 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$4.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Nov 25, 2022
Number of pages
3
Written in
Additional information
This document has been written for:
Uploaded
Nov 25, 2022
Downloads
0
Views
52
