Advanced SQL A CASE SQL statement is which of the following? A way to establish an IF-THEN-ELSE in SQL. All of these A way to establish a data definition in SQL. A way to establish a loop in SQL. A way to establish an IF-THEN-ELSE in SQL. All of these A way to establish a data definition in SQL. A way to establish a loop in SQL. ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL Which of the following is true concerning triggers? They cannot cascade (cause another trigger to fire). You do not create them with SQL. They execute against only some applications that access a database. They have an event, condition, and action. They cannot cascade (cause another trigger to fire). You do not create them with SQL. They execute against only some applications that access a database. They have an event, condition, and action. ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL Embedded SQL is which of the following? Hard-coded SQL statements in a trigger. Hard-coded SQL statements in a procedure. Hard-coded SQL statements in a program language such as Java. The process of making an application capable of generating specific SQL code on the fly. Hard-coded SQL statements in a trigger. Hard-coded SQL statements in a procedure. Hard-coded SQL statements in a program language such as Java. The process of making an application capable of generating specific SQL code on the fly. ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL Subqueries can be nested multiple times. True False True False ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL How many tables may be included with a join? Three One Two All of these Three One Two All of these ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS