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?

Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating(the popularity of the book on a scale of 1 to 10) Language(such as French, English, German etc) Subjects --------- SubjectId Subject(such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country Which is the query to determine the number of Authors who have written books on more than 2 subjects?

Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

What does DETERMINISTIC mean in the creation of a function?

What is wrong with the following statement? create table foo (id int auto_increment, name int);

Maximum size of a row in a MyISAM table?

Which methods can speed up the INSERT statements?

Which optimization tips holds true?

Which forms of the SELECT statement writes a single row to a f‌ile without any formatting?

Which is INCORRECT regarding the DECIMAL data type?

Which data type has been deprecated in MySQL 5.6?