Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DML HTML XML DDL DML HTML XML DDL ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. A view is a special stored procedure executed when certain event occurs. None of these A view is a database diagram. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. A view is a special stored procedure executed when certain event occurs. None of these A view is a database diagram. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? FROM, WHERE, SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE WHERE, FROM,SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE ANSWER DOWNLOAD EXAMIANS APP