Oracle Database SQL Free Practice Exam Questions

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

1. Question 138: You create a table by using this command: CREATE TABLE rate_list (rate NUMBER(6,2)); Which two are true about executing statements? (Choose two.)
2. Question 142: Which two statements are true about the ORDER BY clause? (Choose two.)
3. Question 143: You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1) Be stored in a format supporting date ari…
4. Question 145: Which two queries execute successfully? (Choose two.)
5. Question 146: Which two statements are true about INTERVAL data types?
6. Question 147: Which two are true about multitable INSERT statements?
7. Question 150: Which two statements are true about Entity Relationships? (Choose two.)
8. Question 152: Which is true about the & and && prefixes with substitution variables? (Choose all that apply.)
9. Question 154: Which three are true about subqueries? (Choose three.)
10. Question 156: Which three statements are true about Structured Query Language (SQL)? (Choose three.)