gs gs115 SQL Subqueries - SQL Null Functions - Quiz No.1
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 10 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 1: IS NULL( ) function in SQL server is used to _______
Return NULL values
Replace NULL values
Check NULL values of a table
Insert NULL values into a table
Question 2: What is the syntax of ISNULL ( ) function used in SQL server?
Select column_list, ISNULL (column_name, replace_value) From table_name; Select column_list From table_name Where ISNULL (column_name, replace_value); Select column_list, ISNULL (replace_value) From table_name; Select column_list From table_name Where ISNULL (replace_value);
Question 3: In MySQL ISNULL ( ) function is used to _____
Replace the NULL values
Insert NULL values into a table
Check NULL values in a table
Return NULL values
Question 4: What is the syntax of ISNULL ( ) function used in MySQL?
Select column_list ISNULL(column_name) From table_name; Select column_list From table_name ISNULL (column_name); Select column_list ISNULL From table_name; Select column_list From table_name Where ISNULL (column_name);
Question 5: IFNULL ( ) function is available in which of the following environment?
MySQL, SQL Server
SQL server, Oracle
MySQL
SQL server
Question 7: What is the syntax of IFNULL ( ) function?
Select column_list From table_name Where IFNULL (column_name, value_to_replace); Select column_list, IFNULL(column_name, value_to_replace) From table_name; Select column_list IFNULL(value_to_replace) From table_name; Select column_list From table_name Where IFNULL (value_to_replace);
Question 8: COALESCE ( ) function in SQL returns which of the following?
All non-NULL expressions among its arguments
All NULL expressions among its arguments
First NULL expression among its arguments
First non-NULL expression among its arguments
Question 9: If all the expressions of a COALESCE ( ) function are evaluated to be NULL, then it returns ______
Nothing
Error
Null
Some default value
Question 10: What is the syntax of COALESCE ( ) function?
Select column_list, COALESCE(expressions_list) From table_name; Select column_list From table_name Where COALESCE (expressions_list); Select column_list, COALESCE(expressions_list, replace_value) From table_name; Select column_list From table_name Where COALESCE (expressions_list); 
