Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . table report file form table report file form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator EXISTS operator None of these BETWEEN operator LIKE operator EXISTS operator None of these BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS