Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE REMOVE ALTER COLLAPSE DELETE REMOVE ALTER COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Increased dependence on a single vendor All of these Reduced training costs Applications are not needed Increased dependence on a single vendor All of these Reduced training costs Applications are not needed ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 9 0 10 5 9 0 10 5 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS