Introduction to SQL The result of every SQL query is a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY ORDER BY GROUP BY SORT BY ALIGN BY ORDER BY GROUP BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Projection operation. Join operation. Selection operation. Rename operation. Projection operation. Join operation. Selection operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Self-Join Equijoin None of these Non-Equijoin Self-Join Equijoin None of these Non-Equijoin 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 SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS