Introduction to SQL The result of a SQL SELECT statement is a ________ . file form report table file form report table ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs FLASE Nothing TRUE Hi FLASE Nothing TRUE Hi ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? NUMERIC All of these FLOAT CHARACTER NUMERIC All of these FLOAT CHARACTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS