Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of values. columns. distinct values. groups. values. columns. distinct values. groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys All of these Default values Data types Primary keys All of these Default values Data types ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a database diagram. None of these 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. A view is a database diagram. None of these 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. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ALIGN BY SORT BY ORDER BY GROUP BY ALIGN BY SORT BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . table file report form table file report form ANSWER DOWNLOAD EXAMIANS APP