Select Statement  «Prev  Next»

Pseudocolumns Group Functions - Quiz

This quiz poses questions with respect to 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. 
SELECT PRODUCT_ID, (SYSDATE - LAST_UPDATE_DATE) 
FROM PRODUCT 
WHERE LAST_UPDATE_DATE > '01-NOV-99'
  B. 
SELECT PRODUCT_ID, LOG_DATETIME 
FROM PET_CARE_LOG 
WHERE CREATED_BY_USER = USER
  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