19. What column names are displayed when this SQL command is executed? SHOW COLUMNS FROM TableA LIKE '%name' ; A. first_
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
19. What column names are displayed when this SQL command is executed? SHOW COLUMNS FROM TableA LIKE '%name' ; A. first_
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