WGU C170 Data Management - Applications SQL Syntax STUDY NOTES
CREATE TABLE syntax DDL - correct answer CREATE TABLE tableName ( colName dataType constraint INDEX indexName (colName) PRIMARY KEY (colName, colName) or colName dataType PRIMARY KEY FOREIGN KEY (colName, colName) REFERENCES tableName (colName) ); CREATE INDEX syntax DDL - correct answer CREATE [UNIQUE] INDEX indexName ON tableName (colName); UNIQUE should only be used on a column that should not have duplicate values. DROP INDEX syntax DDL - correct answer DROP INDEX indexName; DROP INDEX 'PRIMARY' ON tableName; drops PK ALTER INDEX DDL - correct answer ALTER INDEX indexName ON tableName (colName, colName);
Written for
- Institution
- WGU C170 - DATA MANAGEMENT APPLICATIONS
- Module
- WGU C170 - DATA MANAGEMENT APPLICATIONS
Document information
- Uploaded on
- February 10, 2024
- Number of pages
- 4
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
sql syntax
-
wgu c170 data management applications
Also available in package deal