19. What column names are displayed when this SQL command is executed? SHOW COLUMNS FROM TableA LIKE '%name' ; A. first_
Posted: Fri Jul 08, 2022 6:44 am
- 19 What Column Names Are Displayed When This Sql Command Is Executed Show Columns From Tablea Like Name A First 1 (95.69 KiB) Viewed 43 times
19. What column names are displayed when this SQL command is executed? SHOW COLUMNS FROM TableA LIKE '%name' ; A. first_name B. store_name C. company_name D. all of the above 20. What is xyz in the following statement? SELECT abc FROM xyz; A. row name B. column name C. table name D. database name Section 2: Fill in the blanks Total Points: 6 (All questions are equally weighted) 1. Item table has primary key ItemID AUTO_INCREMENT and 10 rows of data inserted. Change AUTO_INCREMENT to start from 100. ALTER TABLE 2. Table Employee has columns (empid, name and managerid). Complete to find employees who are also managers. SELECT e. name FROM employee e INNER JOIN