gs gs115 SQL Subqueries - SQL Null Functions - Quiz No.2
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 5 multiple choice questions (MCQs) to prepare and belongs to topic SQL Subqueries. 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 2: How many arguments are there for NULLIF ( ) function?
Zero
One
Two
Any number
Question 3: What is the syntax of NULLIF ( ) function?
Select column_list From table_name Where NULLIF (exp1, exp2); Select column_list, NULLIF (exp1, exp2) From table_name; Select column_list, NULLIF (exp1, exp2,exp3) From table_name; Select column_list From table_name Where NULLIF (exp1);
Question 5: NVL ( ) function is similar to which of the following function(s)?
IFNULL ( ) in MySQL, ISNULL ( ) in SQL server
IFNULL ( ) in MySQL, COALESCE ( ) in SQL server
COALESCE ( ), ISNULL ( ) in SQL server
COALESCE ( ), NULLIF ( ) in SQL server
