Introduction to SQL Which of the following is a SQL aggregate function? AVG LEN JOIN LEFT AVG LEN JOIN LEFT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? MODIFY SAVE UPDATE SAVE AS MODIFY SAVE UPDATE SAVE AS ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. UNIQUE SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY READ None of these SELECT QUERY READ None of these SELECT ANSWER DOWNLOAD EXAMIANS APP