Some candidates read on a tablet; others prefer drilling in a simulator. 2Pass4sure's Oracle Database SQL package comes as a printable PDF, a Windows desktop test engine, and a browser-based online engine, so the 437 practice questions for the 1z0-071 exam fit the way you actually study.

Oracle 1z0-071 Exam Overview:

Oracle 1z0-071 Exam Syllabus Topics:

Oracle 1z0-071 Exam: Everything You Wanted to Ask

Oracle Database SQL Sample Questions:

Question 1

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A.

B.

C.

D.

E.

Question 2

View the Exhibit and examine the structure of the CUSTOMERS table.

You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10,000.
Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_credit_limit FROM customers
WHERE (UPPER(cust_last_name) LIKE 'A%' OR
UPPER (cust_last_name) LIKE 'B%' OR UPPER (cust_last_name) LIKE 'C%')
AND cust_credit_limit < 10000;
SQL>SELECT cust_last_name, cust_credit_limit FROM customers
WHERE UPPER (cust_last_name) BETWEEN 'A' AND 'C'
AND cust_credit_limit < 10000;
Which statement is true regarding the execution of the above queries?

A. Only the first query gives the correct result
B. Both execute successfully but do not give the required result
C. Only the second query gives the correct result
D. Both execute successfully and give the same result

Question 3

Which two statements are true about sequences created in a single instance database? (Choose two.)

A. The numbers generated by a sequence can be used only for one table
B. DELETE <sequencename> would remove a sequence from the database
C. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted
D. CURRVAL is used to refer to the last sequence number that has been generated
E. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement

Question 4

User HRhas CREATE SESSION, CREATE ANY TABLEand UNLIMITED TABLESPACE
privileges.
User SCOTThas CREATE SESSION, CREATE TABLEand UNLIMITED TABLESPACE
privileges.
HRsuccessfully executes this statement:

HRattempts to execute:
1. INSERT INTO scott.products VALUES (1, 'LAPTOP');
SCOTTattempts to execute:
2. SELECT * FROM products;
3. INSERT INTO scott.products VALUES (2, 'HDD');
4. CREATE SYNONYM prod FOR products;
Which will execute successfully?

A. 1, 2 and 3
B. 1 only
C. 2 and 3 only
D. 2, 3 and 4

Question 5

Which three statements are true about inner and outer joins? (Choose three.)

A. A full outer join returns matched and unmatched rows
B. Outer joins can be used when there are multiple join conditions on two tables
C. An inner join returns matched rows
D. A full outer join must use Oracle syntax
E. A left or right outer join returns only unmatched rows
F. Outer joins can only be used between two per query

Solutions: