1z0-071 Exam Question 26
You want to display 5 percent of the rows from the SALES table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?
Which query will provide the required result?
1z0-071 Exam Question 27
Examine this partial query:
SELECT ch.channel_type, t.month, co.country_code, SUM(s.amount_sold) SALES FROM sales s, times t, channels ch, countries co WHERE s.time_ id = t.time id AND s.country_ id = co. country id AND s. channel id = ch.channel id AND ch.channel type IN ('Direct Sales', 'Internet') AND t.month IN ('2000-09', '2000-10') AND co.country code IN ('GB', 'US') Examine this output:
Which GROUP BY clause must be added so the query returns the results shown?
SELECT ch.channel_type, t.month, co.country_code, SUM(s.amount_sold) SALES FROM sales s, times t, channels ch, countries co WHERE s.time_ id = t.time id AND s.country_ id = co. country id AND s. channel id = ch.channel id AND ch.channel type IN ('Direct Sales', 'Internet') AND t.month IN ('2000-09', '2000-10') AND co.country code IN ('GB', 'US') Examine this output:
Which GROUP BY clause must be added so the query returns the results shown?
1z0-071 Exam Question 28
Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)
1z0-071 Exam Question 29
Which two are true about the USING clause when joining tables?
1z0-071 Exam Question 30
You execute this command:
ALTER TABLE employees SET UNUSED (department_id);
Which two are true?
ALTER TABLE employees SET UNUSED (department_id);
Which two are true?