VIP Exclusive
Oracle SQL Certified Associate VIP Exam
Oracle SQL — This exam mirrors the Oracle Database SQL Certified Associate exam (1Z0-071), issued by Oracle University, which consists of 73 multiple-choice questions, a 120-minute time limit, and a 63% passing score, covering SQL fundamentals, DML/DDL/TCL, joins, subqueries, set operators, built-in functions, and schema objects.
54
Questions
120m
Time Limit
63.00%
To Pass
Question 1 of 54👑 VIP
You are working on a reporting query for a financial application. The TRANSACTIONS table has columns: TRANS_ID, ACCOUNT_ID, AMOUNT, TRANS_DATE, and STATUS. You need to retrieve all transactions where the AMOUNT is greater than 5000 OR the STATUS is 'PENDING', but you want to exclude any rows where ACCOUNT_ID is NULL. Which WHERE clause correctly implements this logic?
Questions 2–54 and full explanations are VIP-exclusive.