Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN NOT IN only IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . report table file form report table file form ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS