Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEN LEFT AVG JOIN LEN LEFT AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Both of above Data Definition Language(DDL) None Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None Data Manipulation Language(DML) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP