Question: please answer this question as quick as possible I will give thumbs up 11. Idepify the correet statement for successfully importing a CSV fite named
11. Idepify the correet statement for successfully importing a CSV fite named data.csv into an SQLite3 table; tb) data, and then replacing values within that table for a specifio field. (1) mode esv -import data.cesv tbl_data; replace tbl_data where field-'value'; B) import data.csv tbl_data; update tbl data where field ='value; C) create table tbl_data; set values import data.esv; D) dump tbi_data; import data.esv; E) None of the above Use this example table to answer the following questions with Sqlite3 statements with this tahla whl classrooms: 12. From the statements below, select the one that would return results showing the building, room number an the square footage of each classroom, ordered by area in descending order. A) SELECT * FROM tbl_classrooms ORDER BY area; B) SELECT RoomNo, Building, area FROM tbl classrooms; C) SELECT *, area FROM tbl_classrooms ORDER BY area desc; D) None of the above 13. From the statements below, select the one that would be able to update the table to replace empty Cap with a value: A) REPLACE VALUES (Capacity) as 50 where Capacity is null; B) INSERT 50 into VALUE (Capacity) where (SELECT capacity FROM tbl classrooms WHERE capacity = ""); C) UPDATE tbl_classrooms SET Capacity =50; D) UPDATE tbl_classrooms SET Width, Length, Capacity=50 WHERE Capacity IS NULL; E) Nonc of the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
