Introduction to SQL Which of the following SQL commands can be used to add data to a database table? ADD UPDATE INSERT APPEND ADD UPDATE INSERT APPEND ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has two 0's in it, at any position Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; 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. UNIQUE ONLY DISTINCT SINGLE UNIQUE ONLY DISTINCT SINGLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY SORT BY ORDER BY ALIGN BY GROUP BY SORT BY ORDER BY ALIGN BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Join operation. Selection operation. Projection operation. Rename operation. Join operation. Selection operation. Projection operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP