TestPassPort 1z0-051試験 Q&A(111)

100. View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the number of times the product has been sold: SQL>SELECT p.prod_name, i.item_cnt FROM (SELECT prod_id, COUNT(*) item_cnt FROM sales GROUP BY prod_id) i RIGHT OUTER JOIN products p ON i.prod_id = p.prod_id; What happens when […]

TestPassPort 1z0-051試験 Q&A(110)

99. Which three statements are true regarding subqueries? (Choose three.) A.Subqueries can contain GROUP BY and ORDER BY clauses. B.Main query and subquery can get data from different tables. C.Main query and subquery must get data from the same tables. D.Subqueries can contain ORDER BY but not the GROUP BY clause. E.Only one column or […]

TestPassPort 1z0-051試験 Q&A(109)

98. Where can subqueries be used? (Choose all that apply.) A.field names in the SELECT statement B.the FROM clause in the SELECT statement C.the HAVING clause in the SELECT statement D.the GROUP BY clause in the SELECT statement E.the WHERE clause in only the SELECT statement F.the WHERE clause in SELECT as well as all […]

TestPassPort 1z0-051試験 Q&A(108)

97. Which two statements are true regarding subqueries? (Choose two.) A.A subquery can retrieve zero or more rows. B.Only two subqueries can be placed at one level. C.A subquery can be used only in SQL query statements. D.A subquery can appear on either side of a comparison operator. E.There is no limit on the number […]

TestPassPort 1z0-051試験 Q&A(107)

96. View the Exhibits and examine the structures of the PROMOTIONS and SALES tables. Evaluate the following SQL statement: SQL>SELECT p.promo_id, p.promo_name, s.prod_id FROM sales s RIGHT OUTER JOIN promotions p ON (s.promo_id = p.promo_id); Which statement is true regarding the output of the above query? A.It gives the details of promos for which there […]