Multiple choice technology platforms and products

  1. The criteria that you specify in a PeopleSoft Query are equivalent to which clause in SQL?

  1. a. FROM

  2. b. WHERE

  3. c. GET

  4. d. SELECT

  5. e. IMPORT
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL, the WHERE clause specifies filtering criteria to restrict which rows are returned. In PeopleSoft Query, when you add criteria/conditions to filter data, these translate directly to WHERE clause conditions in the generated SQL. SELECT specifies columns, FROM specifies tables, GET and IMPORT are not SQL clauses.

Keep practicing — related questions