Introduction to SQL Which SQL keyword is used to retrieve only unique values? DIFFERENT DISTINCT UNIQUE DISTINCTIVE DIFFERENT DISTINCT UNIQUE DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79 SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? CREATE INSERT MAKE ADD CREATE INSERT MAKE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature ends with two 0's Feature begins with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's Feature has more than two 0's Feature has two 0's in it, at any position ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? All of these Primary keys Data types Default values All of these Primary keys Data types Default values ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS