gs gs113 Data Type Reference, Operators and Functions - Functions - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Type Reference, Operators and Functions. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: The server is told to accept spaces after function names by _____________
–sql-mode=SKIP_SPACE
–sql-mode=IGNORE_SPACE
–sql-mode=SPACE_IGNORE
–sql-mode=SPACE_SKIP
Question 2: Which function returns NULL if expr1 = expr2?
CASE
IF()
IFNULL()
NULLIF()
Question 3: The operator that compares sounds is _____________
MATCH SOUNDS
CHECK SOUNDS
SOUNDS LIKE
SOUNDS SIMILAR
Question 4: The string function that returns the index of the first occurrence of substring is _____________
INSERT()
INSTR()
INSTRING()
INFSTR()
Question 8: The one that is not optional is _____________
SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;
select_list
table_list
row_constraint
grouping_columns
Question 9: The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________
CARTESIAN JOIN
CROSS JOIN
INNER JOIN
RIGHT JOIN
Question 10: The facility that allows nesting one select statement into another is ______________
nesting
binding
subquerying
encapsulating
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
