Introduction to SQL Which of the following is a valid SQL type? NUMERIC All of these CHARACTER FLOAT NUMERIC All of these CHARACTER FLOAT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: All of these query database data only. modify database data only. create database structures only. All of these query database data only. modify database data only. create database structures only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these SUM MAX COUNT All of these SUM MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints ab 23 bc gh ab 23 bc gh ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT BY ORDER ORDER BY SORT SORT BY ORDER ORDER BY SORT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS