Oracle Database 12c: SQL Fundamentals Free Practice Exam Questions

25 real Oracle Database 12c: SQL Fundamentals exam questions with answers and AI explanations. Oracle certification prep — page 1 of 3.

  1. Question 6: Examine the create table statements for the stores and sales tables. SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name…
  2. Question 7: Examine the structure and data in the PRICE_LIST table: Name . Null . Type - ---------------------- PROD_ID . NOT NULL . NUMBER(3) PROD_PRICE . VARCHAR2(10) PR…
  3. Question 11: Where can sub queries be used? (Choose all that apply)
  4. Question 13: Which one is a system privilege?
  5. Question 16: Examine the structure and data in the PRIC E_LIST table: Name Null? Type ------------ ------------- ------------------- PROD_D NOT NULL NUMBER(3) PROD_PRICE VA…
  6. Question 19: Which two statements are true regarding views? (Choose two.)
  7. Question 21: Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers - WHERE country_id = 10 - UNION - SELECT cust_id CUST_NO,…
  8. Question 23: Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)
  9. Question 24: You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employ…
  10. Question 27: In which four clauses can a sub query be used? (Choose four.)