Why is the following GRANT statement considered a bad security practice: GRANT ALL PRIVILEGES ON db_test.* TO 'john'@'%' IDENTIFIED BY '0!Nh6l7tEjohn'

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?

Which operator is used to select values within a range?

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?