Oracle Database 11g SQL Fundamentals I

Here you have the best Oracle 1z0-051 practice exam questions

You have 290 total questions to study from
Each page has 5 questions, making a total of 58 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 26, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 290

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)

A.

It releases the storage space used by the table.

B.

It does not release the storage space used by the table.

C.

You can roll back the deletion of rows after the statement executes.

D.

You can NOT roll back the deletion of rows after the statement executes.

E.

An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

F.

You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

Correct Answer: A, D, F

Question 2 of 290

Here is the structure and data of the CUST_TRANS table:
Exhibit:

CUST_TRANS -
Name Null? Type
-------------- ----------------- ------------------
CUSTNO NOT NULL CHAR (2)
TRANSDATE DATE
TRANSAMT NUMBER (6, 2)
CUSTNO TRANSDATE TRANSAMT
------------- ----------------------- -----------------------
11 01-JAN-07 1000
22 01-FEB-07 2000
33 01-MAR-07 3000
Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table.
Which three SQL statements would execute successfully? (Choose three.)

A.

SELECT transdate + '10' FROM cust_trans;

B.

SELECT * FROM cust_trans WHERE transdate = '01-01-07';

C.

SELECT transamt FROM cust_trans WHERE custno > '11';

D.

SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';

E.

SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;

Correct Answer: A, C, D

Question 3 of 290

View the Exhibit and examine the structure of the CUSTOMERS table:
Exam 1z0-051: Question 3 - Image 1

Using the CUSTOMERS table, you need to generate a report that shows the average credit limit for customers in WASHINGTON and NEW YORK.
Which SQL statement would produce the required result?

A.

SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_credit_limit, cust_city;

B.

SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city,cust_credit_limit;

C.

SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city;

D.

SELECT cust_city, AVG(NVL(cust_credit_limit,0)) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK');

Correct Answer: C

Question 4 of 290

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 ORDER BY 2 DESC;
What is true about them?

A.

The two statements produce identical results.

B.

The second statement returns a syntax error.

C.

There is no need to specify DESC because the results are sorted in descending order by default.

D.

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

Correct Answer: A

Question 5 of 290

Where can sub queries be used? (Choose all that apply)

A.

field names in the SELECT statement

B.

the FROM clause in the SELECT statement

C.

the HAVING clause in the SELECT statement

D.

the GROUP BY clause in the SELECT statement

E.

the WHERE clause in only the SELECT statement

F.

the WHERE clause in SELECT as well as all DML statements

Correct Answer: A, B, C, F