(Top QUALITY 2024/2025 EXAM REVIEW) WGU C170 Performance Assessment Questions and answers, rated A+
WGU C170 Performance Assessment Questions and answers, rated A+ Syntax for updating a specific column in a specific row - -UPDATE table SET atrribute = value WHERE primary key = value; Syntax for deleting a row - -DELETE FROM TableName WHERE PrimaryKey = #; Syntax for creating a view - -CREATE VIEW name AS SELECT columnname CONCAT (attribute, ' ', attribute) AS newname, attributes FROM tablename Syntax to create an Index - -CREATE INDEX indexname ON table (attribute); Syntax for inserting rows into a table - -INSERT INTO TableName (ColumnName1, ColumnName2, ColumnName3) VALUES (Column1Value, Column2Value); Syntax for updating a value in a specific row - -UPDATE Ta
Geschreven voor
- Instelling
- Western Governors University
- Vak
- WGU C170 - Data Management – Applications
Documentinformatie
- Geüpload op
- 2 november 2023
- Aantal pagina's
- 2
- Geschreven in
- 2023/2024
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
wgu c170 performance assessment questions and answ
Ook beschikbaar in voordeelbundel