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, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ALIGN BY ORDER BY SORT BY GROUP BY ALIGN BY ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Equijoin Non-Equijoin None of these Self-Join Equijoin Non-Equijoin None of these Self-Join ANSWER DOWNLOAD EXAMIANS APP