C170 Performance Assessment QUESTION AND ANSWER

C170 Performance Assessment QUESTION
AND ANSWER

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>

WHERE <PrimaryKey> = <#>;



Syntax for deleting a row from table - ✔✔DELETE FROM <TableName>

WHERE <PrimaryKey> = <#>;



Going from Unnormalized to 1NF - ✔✔Add a primary key