Oracle Database 11g: SQL Fundamentals I Free Practice Exam Questions

9 real Oracle Database 11g: SQL Fundamentals I exam questions with answers and AI explanations. Oracle certification prep — page 1 of 1.

1. Question 1: Examine the structure and data in the PRICE_LIST table: Name Null Type - ---------------------- PROD_ID NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD…
2. Question 2: Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
3. Question 3: Which statement is true regarding transactions? (Choose all that apply.)
4. Question 4: Which two statements are true regarding constraints? (Choose two.)
5. Question 6: Which two statements about sub queries are true? (Choose two.)
6. Question 10: Which is a valid CREATE TABLE statement?
7. Question 12: Here is the structure and data of the CUST_TRANS table: Exhibit: CUST_TRANS - Name Null? Type -------------- ----------------- ------------------ CUSTNO NOT NU…
8. Question 14: Evaluate this SQL statement: SELECT e.emp_name, d.dept_name - FROM employees e - JOIN departments d - USING (department_id) WHERE d.department_id NOT IN (10,40…
9. Question 15: Which two statements are true regarding single row functions? (Choose two.)