Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Data types Default values All of these Primary keys Data types Default values All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? JOIN INSERT SELECT DELETE JOIN INSERT SELECT DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator EXISTS operator None of these IS NULL operator NOT operator EXISTS operator None of these IS NULL operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 456789 6789 1234 2345 456789 6789 1234 2345 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS