Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT All of these MAX SUM COUNT All of these MAX SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the full form of SQL? Structured Query Language Simple Query Language None of these Structured Query List Structured Query Language Simple Query Language None of these Structured Query List ANSWER DOWNLOAD EXAMIANS APP