Sail E0 Webinar

MCQs

Total Questions : 34 | Page 4 of 4 pages
Question 31. Which operator is used to match column values against a list of values?
  1.    between
  2.    IN
  3.    Like
  4.    Is Null
 Discuss Question
Answer: Option B. -> IN
Question 32. Write a query to display first_name and last_name of all employees who have their first_name starting with 'A'
  1.    Select first_name from employess where first_name LIKE '%A';
  2.    Select first_name from employess where first_name LIKE "'A'%";
  3.    Select first_name from employess where first_name LIKE 'A%';
  4.    Select first_name from employess where first_name LIKE '%A%';
 Discuss Question
Answer: Option C. -> Select first_name from employess where first_name LIKE 'A%';
Question 33. The maximum length of char data type is
  1.    65535 bytes
  2.    255 bytes
  3.    256 bytes
  4.    456 bytes
 Discuss Question
Answer: Option B. -> 255 bytes
Question 34. Which of the following is not a keyword of MYSQL?
  1.    Select
  2.    Top
  3.    Group
  4.    Insert
 Discuss Question
Answer: Option B. -> Top

Latest Videos

Latest Test Papers