Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Self-Join Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS