31. The SQL keyword BETWEEN is used: A. for ranges. B. to limit the columns displayed. C. as a wildcard. D. None of the above is correct. 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
32. A subquery in an SQL SELECT statement: A. can only be used with two tables. B. can always be duplicated by a join. C. has a distinct form that cannot be duplicated by a join. D. cannot have its results sorted using ORDER BY. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
33. ________ was adopted as a national standard by ANSI in 1992. A. Oracle B. SQL C. Microsoft Access D. DBase 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
34. SQL is: A. a programming language. B. an operating system. C. a data sublanguage. D. a DBMS. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
35. The condition in a WHERE clause can refer to only one value. 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
36. The ADD command is used to enter one row of data or to add multiple rows as a result of 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
37. SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. 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
38. The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. 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
39. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. 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
40. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. 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