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);
Geschreven voor
- Instelling
- WGU C170 - DATA MANAGEMENT APPLICATIONS
- Vak
- WGU C170 - DATA MANAGEMENT APPLICATIONS
Documentinformatie
- Geüpload op
- 10 februari 2024
- Aantal pagina's
- 4
- Geschreven in
- 2023/2024
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
sql syntax
-
wgu c170 data management applications
Ook beschikbaar in voordeelbundel