Which of the following results in 0 (false)?
Correct Answer: BINARY "EXPERTRATING" LIKE "Exp%"
Explanation:
Note: This Question is unanswered, help us to find answer for this one
MySQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More MySQL MCQ Questions
Which ones are true?
Consider the following table structure of students: rollno number(4) name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?
Consider the following queries: create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade); Which of the following statements is true?
In which sequence are queries and sub-queries executed by the SQL Engine?
What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;
Return value in case str is not found? FiELD(str.str1.str2.str3,...)
Which queries will return NULL records from the table myTable?
Which are reserved words in MySQL 5.6?
Which is INCORRECT regarding the date data type?
Which is correct regarding the CREATE DATABASE statement?