C170 Performance Assessment
Complete 2023
Syntax for updating a specific column in a specific row Ans- UPDATE <table>
SET <atrribute> = <value>
WHERE <primary key> = <value>;
Syntax for deleting a row Ans- DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Syntax for creating a view Ans- CREATE VIEW <name>
AS SELECT <columnname>
CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes>
FROM <tablename>
Syntax to create an Index Ans- CREATE INDEX <indexname>
ON <table> (<attribute);
Syntax for inserting rows into a table Ans- INSERT INTO <TableName> (ColumnName1, ColumnName2,
ColumnName3)
VALUES (Column1Value, Column2Value);
Syntax for updating a value in a specific row Ans- UPDATE <TableName>
SET <Attribute> = <NewValue>
WHERE <PrimaryKey> = <#>;
Syntax for deleting a row from table Ans- DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Complete 2023
Syntax for updating a specific column in a specific row Ans- UPDATE <table>
SET <atrribute> = <value>
WHERE <primary key> = <value>;
Syntax for deleting a row Ans- DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Syntax for creating a view Ans- CREATE VIEW <name>
AS SELECT <columnname>
CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes>
FROM <tablename>
Syntax to create an Index Ans- CREATE INDEX <indexname>
ON <table> (<attribute);
Syntax for inserting rows into a table Ans- INSERT INTO <TableName> (ColumnName1, ColumnName2,
ColumnName3)
VALUES (Column1Value, Column2Value);
Syntax for updating a value in a specific row Ans- UPDATE <TableName>
SET <Attribute> = <NewValue>
WHERE <PrimaryKey> = <#>;
Syntax for deleting a row from table Ans- DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
