1Z0-071 Free Questions – Oracle Database 12c SQL V13.02

1Z0-071 Oracle Database 12c SQL is a popular Oracle exam, which covers four Oracle certifications:

  • Oracle Database 11g Administrator Certified Associate(Retires on 31, Dec 2019)
  • Oracle PL/SQL Developer Certified Associate
  • Oracle Database 12c Administrator Certified Associate
  • Oracle Database SQL Certified Associate

To be an Oracle Database certified, 1Z0-071 Oracle Database SQL exam can be good choice. We have 1Z0-071 exam questions to be your best preparation materials. The most accurate 1Z0-071 exam questions and answers are verified. With our online 1Z0-071 questions, you can pass Oracle Database 12c SQL exam smoothly. Here, you can read 1Z0-071 free questions for the final decision.

1Z0-071 Free Questions – Oracle Database 12c SQL V13.02

1. In which normal form is a table, if it has no multi-valued attributes and no partial dependencies?

 
 
 
 

2. Which three statements are true about multiple-row subqueries? (Choose three.)

 
 
 
 
 
 

3. The BOOKS_TRANSACTIONS table exists in your database.
SQL>SELECT * FROM books_transactions ORDER BY 3;
What is the outcome on execution?

 
 
 
 

4. Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true in this scenario? (Choose two.)

 
 
 
 
 

5. Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

 
 
 
 

6. 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.)

 
 
 
 
 

7. 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?

 
 
 
 

8. Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name “Last name”
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query. (Choose three.)

 
 
 
 
 

9. Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)

 
 
 
 
 

10. Which statement is true regarding external tables?

 
 
 
 

11. Which two statements are true about Data Manipulation Language (DML) statements? (Choose two.)

 
 
 
 
 
 

12. Which two statements are true regarding roles? (Choose two.)

 
 
 
 
 

13. Which two statements are true regarding constraints? (Choose two.)

 
 
 
 

14. Which three statements are true regarding subqueries? (Choose three.)

 
 
 
 
 
 

15. Evaluate the following SQL statements that are issued in the given order:
CREATE TABLE emp
(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,
ename VARCHAR2(15),
salary NUMBER (8,2),
mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no));
ALTER TABLE emp
DISABLE CONSTRAINT emp_emp_no_pk CASCADE;
ALTER TABLE emp
ENABLE CONSTRAINT emp_emp_no_pk;
What would be the status of the foreign key EMP_MGR_PK?

 
 
 
 

16. Which three statements are true regarding the data types? (Choose three.)

 
 
 
 
 

17. Which statement is true regarding the default behavior of the ORDER BY clause?

 
 
 
 

18. Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?

 
 
 
 

19. Which three statements are true about the ALTER TABLE….DROP COLUMN…. command? (Choose three.)

 
 
 
 
 

20. Evaluate the following SQL statement:
SELECT product_name || ‘it’s not available for order’
FROM product_information
WHERE product_status = ‘obsolete’;
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

 
 
 
 

21. In which three situations does a transaction complete? (Choose three.)

 
 
 
 
 

22. Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

 
 
 
 

23. Which task can be performed by using a single Data Manipulation Language (DML) statement?

 
 
 
 

24. The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?

 
 
 
 

25. Which statement is true about an inner join specified in a query’s WHERE clause?

 
 
 
 

1Z0-1046 Free Questions - Oracle Global Human Resources Cloud 2019 Implementation Essentials V8.02
1Z0-1023 Free Questions - Oracle Inventory Cloud 2018 Implementation Essentials V8.02

Leave a Reply

Your email address will not be published. Required fields are marked *