What value return "type" column in EXPLAIN plans for a full table scan of select query?

Which statements is true?

Correct query to find out the number of ENUM('M','F','NA') datatypes columns that exist in all databases?

Examine the description of the STUDENTS table: STD_ID INT COURSE_ID VARCHAR (10) START_DATE DATE END_DATE DATE The aggregate functions valid on the START_DATE column are:

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 query will determine how many books have a popularity rating of more than 7 on each subject?

How can a InnoDB database be backed up without locking the tables?

InnoDB prevents which operations when innodb_force_recovery is greater than 0?

Which are valid encryption functions?

You can not associate a Trigger with?

Consider the following Table EMP: ------ empId empName empSalary empJoinDate Which SQL is incorrect for finding out the count of records on EMP table where empJoinDate is between 2012-10-01 and 2012-12-30?

Which is correct in regards to the syntax of the code below? SELECT table1.this, table2.that, table2.somethingelse FROM table1 INNER JOIN table2 ON table1.foreignkey = table2.primarykey WHERE (some other conditions)