Free 1Z1-051 Questions for Oracle Database: SQL Fundamentals I 1Z1-051 Exam as PDF & Practice Test Engine

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

Exam Questions: 254
Updated On: Jun 01, 2026

Question #1

Which statement is true regarding synonyms?

A. Synonyms can be created only for a table

B. Synonyms are used to reference only those tables that are owned by another user

C. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid

D. A public synonym and a private synonym can exist with the same name for the same table

Discussion 0

Correct Answer: D Vote an answer

Question #2

Which is a valid CREATE TABLE statement?

A. CREATE TABLE EMP*123 AS (empid number(2));

B. CREATE TABLE EMP9$# AS (empid number(2));

C. CREATE TABLE 1EMP_TEST AS (empid number(2));

D. CREATE TABLE PACKAGE AS (packid number(2));

Discussion 0

Correct Answer: B Vote an answer

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

Question #3

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

A. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.

B. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

C. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

D. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

Discussion 0

Correct Answer: B,C Vote an answer

Question #4

Which four are types of functions available in SQL? (Choose 4)

A. character

B. numeric

C. translation

D. calendar

E. string

F. date

G. conversion

H. integer

Discussion 0

Correct Answer: A,B,F,G Vote an answer

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

Question #5

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

A. DELETE FROM employeesWHERE employee_id IN (SELECT employee_idFROM new_employeesWHERE name = 'Carrey');

B. DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM employees);

C. DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM new_employees);

D. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_idFROM new_employeesWHERE name = 'Carrey');

Discussion 0

Correct Answer: A Vote an answer

Question #6

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. There is no need to specify DESC because the results are sorted in descending order by default.

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

D. The second statement returns a syntax error.

Discussion 0

Correct Answer: A Vote an answer

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

Question #7

Which is an iSQL*Plus command?

A. RENAME

B. DELETE

C. INSERT

D. DESCRIBE

E. UPDATE

F. SELECT

Discussion 0

Correct Answer: D Vote an answer

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

Question #8

What is true about sequences?

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

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

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

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

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

Discussion 0

Correct Answer: C Vote an answer

Question #9

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.
Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code"
FROM promotions
ORDER BY code;
SQL>SELECT DISTINCT promo_category promo_cost "code"
FROM promotions
ORDER BY 1;
Which statement is true regarding the execution of the above queries?

A. Both queries execute successfully but give different results.

B. Both queries execute successfully and give the same result.

C. Only the second query executes successfully.

D. Only the first query executes successfully.

Discussion 0

Correct Answer: C Vote an answer

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

Question #10

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

A. the GROUP BY clause in the SELECT statement

B. field names in the SELECT statement

C. the WHERE clause in SELECT as well as all DML statements

D. the HAVING clause in the SELECT statement

E. the FROM clause in the SELECT statement

F. the WHERE clause in only the SELECT statement

Discussion 0

Correct Answer: B,C,D,E Vote an answer

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

Free 1Z1-051 Questions for Oracle Database: SQL Fundamentals I 1Z1-051 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z1-051 Demo