21. 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. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
22. When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
23. The UNION clause is used to combine the output from multiple queries together into a single result table. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
24. ROLLBACK WORK asks SQL to empty the log file. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
25. The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
26. Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
27. A correlated subquery is where the outer query depends on data from the inner query. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
28. A function returns one value and has only output parameters. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
29. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
