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 2 of 3.

  1. Question 29: This statement will fail: create unique bitmap index on employees(department_id,hire_date); Why?
  2. Question 30: Which statement is true regarding transactions? (Choose all that apply.)
  3. Question 32: Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL; What would be the outcome?
  4. Question 34: The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Whic…
  5. Question 36: Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME - --------------------- Lex De Haan - Renske Ladwig - Jose Manuel Urman - Jason Mall…
  6. Question 37: Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 - START WITH 100 - INCREMENT BY 10 - MAXVALUE 200 - CYCLE - NOCACHE; The SEQ1 sequence h…
  7. Question 40: You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 1) The order ID will be unique and canno…
  8. Question 41: Evaluate these two SQL statements: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES…
  9. Question 43: Examine the structure and data of the CUSTJTRANS table: CUSTJRANS - Name Null? Type - CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO TRANSD…
  10. Question 44: You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Whi…