Oracle Advanced SQL and PL/SQL Developer Certification Questions and Answers (Dumps and Practice Questions)

Question : If a compound query contains both a MINUS and an INTERSECT operator, which will be applied first?


1. The INTERSECT, because INTERSECT has higher precedence than MINUS.
2. The MINUS, because MINUS has a higher precedence than INTERSECT.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It is not possible for a compound query to include both MINUS and INTERSECT.



Correct Answer : Get Lastest Questions and Answer :

Explanation: All set operators have equal precedence, so the precedence is determined by the sequence in which they occur









Question :Which of the following commands can not be rolled back?
A. COMMIT
B. DELETE
C. INSERT
D. MERGE
E. TRUNCATE
F. UPDATE



1. A,C
2. B,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. C,D
5. B,E

Correct Answer : Get Lastest Questions and Answer :


Explanation: B,C,D,F are the DML commands: they can all be rolled back.
A and E are incorrect. COMMIT terminates a transaction, which can then never be rolled back. TRUNCATE is a DDL command and includes a built-in COMMIT.






Question : How can you change the primary key value of a row?


1. You cannot change the primary key value.
2. Change it with a simple UPDATE statement.
3. Access Mostly Uused Products by 50000+ Subscribers
4. This is only possible if the row is first locked with a SELECT FOR UPDATE.


Correct Answer : Get Lastest Questions and Answer :

Assuming no constraint violations, the primary key can be updated like any other column.

Related Questions

---

Question : Which comparison operator cannot be used with multiple-row subqueries?
A. ALL
B. ANY
C. IN
D. NOT IN



1. A,B
2. B,C
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,C
5. A,B,C,D





Question : Which of these set operators will not sort the rows?

1. INTERSECT
2. MINUS
3. Access Mostly Uused Products by 50000+ Subscribers
4. UNION ALL




Question : Which of these operators will remove duplicate rows from the final result?



1. INTERSECT
2. MINUS
3. Access Mostly Uused Products by 50000+ Subscribers
4. UNION ALL
4. 1,2 and 3



Question : If a compound query contains both a MINUS and an INTERSECT operator, which will be applied first?


1. The INTERSECT, because INTERSECT has higher precedence than MINUS.
2. The MINUS, because MINUS has a higher precedence than INTERSECT.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It is not possible for a compound query to include both MINUS and INTERSECT.




Question :Which of the following commands can not be rolled back?
A. COMMIT
B. DELETE
C. INSERT
D. MERGE
E. TRUNCATE
F. UPDATE



1. A,C
2. B,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. C,D
5. B,E


Question : How can you change the primary key value of a row?


1. You cannot change the primary key value.
2. Change it with a simple UPDATE statement.
3. Access Mostly Uused Products by 50000+ Subscribers
4. This is only possible if the row is first locked with a SELECT FOR UPDATE.