Introduction to SQL You can add a row using SQL in a database with which of the following? INSERT CREATE ADD MAKE INSERT CREATE ADD MAKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT, FROM, WHERE SELECT,WHERE,FROM FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM FROM, WHERE, SELECT WHERE, FROM,SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a database diagram. A view is a special stored procedure executed when certain event occurs. 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 database diagram. A view is a special stored procedure executed when certain event occurs. 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. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS