File Info
| Exam | Oracle Datbase 12c SQL |
| Number | 1z0-071 |
| File Name | Oracle.1z0-071.ActualTests.2018-09-21.95q.tqb |
| Size | 7 MB |
| Posted | Sep 21, 2018 |
| Download | Oracle.1z0-071.ActualTests.2018-09-21.95q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Evaluate the following two queries:
Which statement is true regarding the above two queries?
- Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
- There would be no change in performance.
- Performance would degrade in query 2.
- Performance would improve in query 2.
Correct answer: B
Question 2
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.)
- The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.
- The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships.
- STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
- PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
- An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.
Correct answer: BE
Explanation:
References:http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html References:
http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html
Question 3
View the Exhibit and examine the details of PRODUCT_INFORMATION table.
You have the requirement to display PRODUCT_NAME from the table where the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;
Which statement is true regarding the execution of the query?
- It would not execute because the same column has been used in both sides of the AND logical operator to form the condition.
- It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.
- It would execute and the output would display the desired result.
- It would execute but the output would return no rows.
Correct answer: D
