Oracle 1Z0-051 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-051
Exam Name/Title: Oracle Database: SQL Fundamentals I
Certification Provider: Oracle
Corresponding Certification: 11g

Exam Questions: 292
Updated On: Jul 09, 2026

Question #1

What is true about sequences?

A. Once created, a sequence is automatically available to all users.

B. Once created, a sequence belongs to a specific schema.

C. Once created, a sequence is linked to a specific table.

D. Only the DBA can control which sequence is used by a certain table.

E. Once created, a sequence is automatically used in all INSERT and UPDATE statements.

Discussion 0

Correct Answer: B Vote an answer

Question #2

Evaluate the following SQL query;

What would be the outcome?

A. 100

B. 16

C. 150

D. 160

E. 200

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #3

View the Exhibits and examine the structures of the CUSTOMERS, SALES, and COUNTRIES tables.
You need to generate a report that shows all country names, with corresponding customers (if any) and sales details (if any), for all customers.
Which FROM clause gives the required result?

A. FROM sales JOIN customers USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);

B. FROM customers LEFT OUTER JOIN sales USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);

C. FROM customers LEFT OUTER JOIN sales USING (cust_id) LEFT OUTER JOIN countries USING (country_id);

D. FROM sales JOIN customers USING (cust_id) FULL OUTER JOIN countries USING (country_id);

Discussion 0

Correct Answer: B Vote an answer

Question #4

SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10,40)
ORDER BY dept_name;
The statement fails when executed. Which change fixes the error?

A. replace the condition
"d.department_id NOT IN (10,40)"
in the WHERE clause with
"d.department_id <> 10 AND d.department_id <> 40"

B. remove the table alias from the SELECT clause

C. remove the table alias prefix from the WHERE clause

D. prefix the column in the ORDER BY clause with the table alias

E. remove the ORDER BY clause

F. prefix the column in the USING clause with the table alias

Discussion 0

Correct Answer: C Vote an answer

Question #5

Examine the description of the CUSTOMERS table:

The CUSTOMER_ID column is the primary key for the table.
Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

A. SELECT city_address, COUNT(*)
FROM customers
WHERE city_address IN ( 'Los Angeles', 'San Fransisco');

B. SELECT city_address, COUNT (*)
FROMcustomers
WHERE city address IN ( 'Los Angeles', 'San Fransisco')
GROUP BY city_address;

C. SELECT city_address, COUNT (customer_id)
FROM customers
GROUP BY city_address IN ( 'Los Angeles', 'San Fransisco');

D. SELECT city_address, COUNT(customer_id)
FROMcustomers
WHERE city_address IN ( 'Los Angeles', 'San Fransisco')
GROUP BYcity_address, customer_id;

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #6

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

A. &

B. ACCEPT

C. PROMPT

D. &&

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #7

See the structure of the PROGRAMS table:

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing') FROM programs;

B. SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs;

C. SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),'Ongoing') FROM programs;

D. SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #8

Which three statements are true regarding sub queries? (Choose three.)

A. Sub queries can contain GROUP BY and ORDER BY clauses

B. Sub queries can contain ORDER BY but not the GROUP BY clause

C. Main query and sub query can get data from different tables

D. Multiple columns or expressions can be compared between the main query and sub query

E. Main query and sub query must get data from the same tables

F. Only one column or expression can be compared between the main query and subqeury

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #9

View the Exhibits and examine the structures of the PRODUCTS SALES and CUSTOMERS tables.

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for all customers in Tokyo'. Which two queries give the required result? (Choose two.)

A. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
AND c.cust_city='Tokyo';

B. SELECT c.cust_last_name,p.prod_name, s.quantity_sold FROM sales s JOIN products p
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

C. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';

D. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold FROM
products p JOIN sales s
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

Discussion 0

Correct Answer: A,B Vote an answer

Question #10

Which statement is true regarding the INTERSECT operator?

A. The names of columns in all SELECT statements must be identical

B. The number of columns and data types must be identical for all SELECT statements in the query

C. It ignores NULL values

D. Reversing the order of the intersected tables the result

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Oracle 1Z0-051 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-051 exam.