QUESTION: 9

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?

SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES;
SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;
SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;
SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY;

Answer(s): A

Show Answer Next Question

QUESTION: 10

Examine the structure of the MEMBERS table:

You execute the SQL statement:
SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM members;

What is the outcome?

It fails because the alias name specified after the column names is invalid.
It fails because the space specified in single quotation marks after the first two column names is invalid.
It executes successfully and displays the column details in a single column with only the alias column heading.
It executes successfully and displays the column details in three separate columns and replaces only the last column heading with the alias.

Answer(s): D

Show Answer Next Question

QUESTION: 11

You issue the following command to drop the PRODUCTS table:
SQL > DROP TABLE products;

Which three statements are true about the implication of this command? (Choose three.)

All data along with the table structure is deleted.
A pending transaction in the session is committed.
All indexes on the table remain but they are invalidated.
All views and synonyms on the table remain but they are invalidated.
All data in the table is deleted but the table structure remains.

Answer(s): A,B,D

Show Answer Next Question

QUESTION: 12

You execute the following commands:

SQL > DEFINE hiredate = '01-APR-2011'

SQL >SELECT employee_id, first_name, salary
FROM employees
WHERE hire_date > '&hiredate'
AND manager_id > &mgr_id;

For which substitution variables are you prompted for the input?

none, because no input required
both the substitution variables ''hiredate' and 'mgr_id'.
only hiredate'
only 'mgr_id'

Answer(s): D

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 4)

QUESTION: 9

QUESTION: 10

QUESTION: 11

QUESTION: 12

1Z0-071 Exam Discussions & Posts