RelationalDBDesign RelationalDBDesign


Select Statement  «Prev  Next»

Pseudocolumns Group Functions - Quiz

Evaluating queries that use pseudocolumns and group functions

Each question is worth 1 point. Select the best answer or answers for each question.
 

1. Which line of the following query contains a syntax error?
Please select the best answer.
  A. 1 SELECT FIRSTNAME, COUNT(SALES_ID)
  B. 2 FROM CUSTOMER C, CUSTOMER_SALE CS
  C. 3 WHERE C.CUST_ID = CS.CUST_ID
  D. 4 GROUP BY FIRSTNAME, COUNT(SALES_ID)
  E. 5 ORDER BY FIRSTNAME

2. Which query correctly incorporates a pseudocolumn in its criteria?
Please select the best answer.
  A. <pre> SELECT PRODUCT_ID, (SYSDATE - LAST_UPDATE_DATE) FROM PRODUCT WHERE LAST_UPDATE_DATE > '01-NOV-99' </pre>
  B. <pre> SELECT PRODUCT_ID, LOG_DATETIME FROM PET_CARE_LOG WHERE CREATED_BY_USER = USER </pre>
  C. SELECT ROWNUM, PACKAGE_ID, PRODUCT_NAME FROM PRODUCT WHERE PACKAGE_ID = NULL
  D. SELECT LEVEL, P.PACKAGE_ID, P.PRODUCT_NAME FROM PRODUCT P, SALE_ITEM S WHERE LEVEL > 2 AND P.PRODUCT_ID = S.PRODUCT_ID

3. 3. Which of the following phrases describe a pseudocolumn?
Please select all the correct answers.
  A. The date and time when a query is executed
  B. The person who is executing the query
  C. The amount of CPU time used by the query
  D. The place value of a column in the query