Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc ab 23 gh bc ab 23 gh ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? IS NULL operator EXISTS operator None of these NOT operator IS NULL operator EXISTS operator None of these NOT operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS