Advanced SQL A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid. True False True False ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL Which of the following statements is true concerning routines and triggers? Both have to be called to operate. Both consist of procedural code. Both run automatically. Both are stored in the database. Both have to be called to operate. Both consist of procedural code. Both run automatically. Both are stored in the database. 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
Advanced SQL Embedded SQL is which of the following? Hard-coded SQL statements in a program language such as Java. Hard-coded SQL statements in a procedure. Hard-coded SQL statements in a trigger. The process of making an application capable of generating specific SQL code on the fly. Hard-coded SQL statements in a program language such as Java. Hard-coded SQL statements in a procedure. Hard-coded SQL statements in a trigger. The process of making an application capable of generating specific SQL code on the fly. ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL What type of join is needed when you wish to return rows that do have matching values? All of these Equi-join Natural join Outer join All of these Equi-join Natural join Outer join ANSWER DOWNLOAD EXAMIANS APP
Advanced SQL Which of the following statements is true concerning subqueries? All of these Does not start with the word SELECT. Cannot return the same result as a query that is not a subquery. Involves the use of an inner and outer query. All of these Does not start with the word SELECT. Cannot return the same result as a query that is not a subquery. Involves the use of an inner and outer query. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS