Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND UPDATE INSERT ADD APPEND UPDATE INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return None of these exactly 10 rows less than 10 rows more than 10 rows None of these exactly 10 rows less than 10 rows more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? 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. None of these A view is a special stored procedure executed when certain event occurs. 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. None of these A view is a special stored procedure executed when certain event occurs. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS