Introduction to SQL 'AS' clause is used in SQL for Selection operation. Join operation. Projection operation. Rename operation. Selection operation. Join operation. Projection operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: None of these GROUP BY. ORDER BY. SORT BY. None of these GROUP BY. ORDER BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these SUM MAX COUNT All of these SUM MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN only NOT IN only LIKE only IN and NOT IN IN only NOT IN only LIKE only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Manipulation Language(DML) None Both of above Data Definition Language(DDL) Data Manipulation Language(DML) None Both of above Data Definition Language(DDL) 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