Introduction to SQL The SQL keyword BETWEEN is used: as a wildcard. None of these to limit the columns displayed. for ranges. as a wildcard. None of these to limit the columns displayed. for ranges. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Default values All of these Primary keys Data types Default values All of these Primary keys Data types ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs FLASE TRUE Hi Nothing FLASE TRUE Hi Nothing ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM MAX All of these COUNT SUM MAX All of these COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS