Introduction to SQL Which of the following must be enclosed in double quotes? All of these Dates Column Alias Strings All of these Dates Column Alias Strings ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT MAX SUM All of these COUNT MAX SUM All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? All of these Increased dependence on a single vendor Reduced training costs Applications are not needed All of these Increased dependence on a single vendor Reduced training costs Applications are not needed ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a CREATE statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? EXISTS operator None of these IS NULL operator NOT operator EXISTS operator None of these IS NULL operator NOT operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS