Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys All of these Data types Default values Primary keys All of these Data types Default values ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NON-EQUIJOIN EQUIJOIN NATURAL JOIN OUTER JOIN NON-EQUIJOIN EQUIJOIN NATURAL JOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? None of these BETWEEN operator EXISTS operator LIKE operator None of these BETWEEN operator EXISTS operator LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS