Introduction to SQL Which of the following is valid SQL for an Index? CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; 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 SQL statement is used to update data in a database? MODIFY UPDATE SAVE AS SAVE MODIFY UPDATE SAVE AS SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT UNIQUE ONLY SINGLE DISTINCT UNIQUE ONLY SINGLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT MAX SUM All of these COUNT MAX SUM All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN AVG LEFT JOIN LEN AVG LEFT JOIN ANSWER DOWNLOAD EXAMIANS APP