Exam (elaborations)
C170 Performance Assessment Questions & Answers, 100% Accurate. VERIFIED.
Rating
Sold
-
Pages
2
Grade
A+
Uploaded on
23-08-2023
Written in
2023/2024
C170 Performance Assessment Questions & Answers, 100% Accurate. VERIFIED. 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 TableName SET Attribute = NewValue
Show more
Read less
Institution
Course
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
- Western Governors University
- Course
- WGU C170 Data Management
All documents for this subject (27)
Document information
- Uploaded on
- August 23, 2023
- Number of pages
- 2
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
c170 performance assessment questions answers 1
$6.99
Get access to the full document:
Wrong document? Swap it for free
Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
