41. There is an equivalent join expression that can be substituted for all subquery expressions. 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
42. A dynamic view is one whose contents materialize when referenced. 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
43. SQL is a programming language. 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
44. SELECT DISTINCT is used if a user wishes to see duplicate columns in a 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
45. Indexes can usually be created for both primary and secondary keys. 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
46. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. 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
47. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. 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
48. SQL is a data sublanguage. 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
49. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. 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
50. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. 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