What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;

What is true about the ENUM data type?

Consider the select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?

Which is not a MySQL Data type?

Which is used to change the structure of a table once it has been created?

View the following Create statement: 1. Create table Pers 2. (EmpNo Int not null, 3. EName Char not null, 4. Join_dt Date not null, 5. Pay Int) Which line contains an error?

Which are valid INSERT statements?

Which functions are synonyms of NOW()?

Result of the following two queries? 1. SELECT 2+3 2. SELECT 2+(3'3)-5

Correct order in which the clauses of the SELECT statement are used? 1. SELECT 2. LIMIT 3. WHERE 4. ORDER BY 5. HAVING 6. FROM

Prior to MySOL 5.6.1. what did the isSimpie(g) function always return?