Oracle Database SQL Free Practice Exam Questions

165 real Oracle Database SQL exam questions with answers and AI explanations. Oracle certification prep — page 14 of 17.

1. Question 214: Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
2. Question 215: Which three statements are true about defining relations between tables in a relational database? (Choose three.)
3. Question 216: Which two join conditions in a FROM clause are non-equijoins? (Choose two.)
4. Question 218: Which two statements are true about a self join? (Choose two.)
5. Question 219: 1. MANAGER is an existing role with no privileges or roles. 2. EMP is an existing role containing the CREATE TABLE privilege. 3. EMPLOYEES is an existing table…
6. Question 220: Which two statements are true about single row functions? (Choose two.)
7. Question 221: Examine this query: SELECT * FROM bricks, colors - Which two statements are true? (Choose two.)
8. Question 222: Which three are true about the CREATE TABLE command? (Choose three.)
9. Question 223: Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
10. Question 225: Which two are true about the USING clause when joining tables? (Choose two.)