Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEFT LEN AVG JOIN LEFT LEN AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator EXISTS operator BETWEEN operator None of these LIKE operator EXISTS operator BETWEEN operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: a programming language. a DBMS. a data sublanguage. an operating system. a programming language. a DBMS. a data sublanguage. an operating system. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? CREATE MAKE INSERT ADD CREATE MAKE INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS