The SQL statements always end with …………… .

1. ,
2. :
3. ;
4. "

Shivam wants to see the table structure in MySQL. Select an appropriate command to help him.

1. Use
2. Show
3. Desc
4. Display

Rajveer wants to rename column in display result for his query. Select the appropriate query for the same:

1. Select Ename, Salary*12 Annual Salary From Emp;
2. Select Ename, Salary*12 Rename "Annual Salary" From Emp;
3. Select Ename, Salary*12 Change "Annual Salary" From Emp;
4. Select Ename, Salary*12 as "Annual Salary" From Emp;

The symbol Asterisk (*) in a select query retrieves …………… .

1. All data from the table
2. Data of primary key only
3. NULL data
4. None of these