Which of the Following Statements About Legacy SQL and Standard

question 34

Multiple Choice

Which of the following statements about Legacy SQL and Standard SQL is not true?

• A) Standard SQL is the preferred query language for BigQuery.
• B) If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
• C) One difference between the two query languages is how you specify fully-qualified table names (i.e. table names that include their associated project name).
• D) You need to set a query language for each dataset and the default is Standard SQL.

---

Definitions:

Benzene

A colorless, volatile liquid hydrocarbon with a distinctive sweet smell, C6H6, used as a solvent and in the manufacture of various chemicals.

Hexane

A hydrocarbon with the chemical formula C6H14, used as a solvent in industrial applications, including the extraction of oils and fats.

Alkane Solvents

Organic solvents composed of alkanes, which are hydrocarbons containing only single bonds, making them non-polar and effective for dissolving similarly non-polar substances.

Electronegative

A measure of an atom's ability to attract and hold onto electrons when it forms bonds, affecting the polarity of chemical bonds.