Oracle Database: SQL Fundamentals I - 1Z0-051 Free Exam Questions [2026]

QUESTION NO: 1
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(customer_id)
FROMcustomers
WHERE city_address IN ( 'Los Angeles', 'San Fransisco')
GROUP BYcity_address, customer_id;

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

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

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

Discussion 0

Correct Answer: C Vote an answer

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

QUESTION NO: 2
What does the FORCE option for creating a view do?

A. creates a view even if the underlying parent table has constraints

B. creates a view in another schema even if you don't have privileges

C. creates a view with constraints

D. creates a view regardless of whether or not the base tables exist

Discussion 0

Correct Answer: D Vote an answer

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

QUESTION NO: 3
You are currently located in Singapore and have connected to a remote database in
Chicago.
You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

A. Number of days since the promo started based on the current Chicago data and time

B. An error because the ROUND function specified is invalid

C. An error because the WHERE condition specified is invalid

D. Number of days since the promo started based on the current Singapore data and time.

Discussion 0

Correct Answer: A Vote an answer

QUESTION NO: 4
Which SQL statement returns a numeric value?

A. SELECT TO_NUMBER(hire_date + 7) FROM EMP;

B. SELECT ROUND(hire_date) FROM EMP;

C. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

D. SELECT sysdate-hire_date FROM EMP;

Discussion 0

Correct Answer: D Vote an answer

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

QUESTION NO: 5
Exhibit contains the structure of PRODUCTS table:

Evaluate the following query:

What would be the outcome of executing the above SQL statement?

A. It shows the names of products whose list price is the second highest in the table.

B. It produces an error

C. It shows the names of all products in the table

D. It shown the names of all products whose list price is less than the maximum list price

Discussion 0

Correct Answer: A Vote an answer

QUESTION NO: 6
What are two reasons to create synonyms? (Choose two.)

A. You want to use another schema's tables.

B. You want to work on your own tables.

C. Your tables have difficult names.

D. You have too many tables.

E. You have too many columns in your tables.

F. Your tables names are too long.

Discussion 0

Correct Answer: C,F Vote an answer

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

QUESTION NO: 7
The CUSTOMERS table has the following structure: Exhibit:

You need to write a query that does the following task:
*Display the first name and tax amount of the customers. Tax is 5% of their credit limit
*Only those customers whose income level has a value should be considered
*Customers whose tax amount is null should not be considered
Which statement accomplishes all the required tasks?

A. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND tax_amount IS NOT NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level <> NULL AND tax_amount <> NULL;

C. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

Discussion 0

Correct Answer: D Vote an answer

QUESTION NO: 8
See the Exhibit and examine the structure and data in the INVOICE table: Exhibit:

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

A. SELECT MAX(AVG(SYSDATE-inv_date)) FROM invoice;

B. SELECT AVG(inv_date) FROM invoice;

C. SELECT AVG(inv_date-SYSDATE),AVG(inv_amt) FROM invoice;

D. SELECT MAX(inv_date),MIN(cust_id) FROM invoice;

Discussion 0

Correct Answer: C,D Vote an answer

QUESTION NO: 9
What is true regarding sub queries?

A. The inner query must always return a value or the outer query will give an error

B. The inner query returns a value to the outer query

C. The outer query must return a value to the outer query

D. The inner query always sorts the results of the outer query

E. The outer query always sorts the results of the inner query

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 10
Evaluate this SQL statement:
SELECT ename, sal, 12*sal+100 FROM emp;
The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

A. SELECT ename, sal+100,*12 FROM emp;

B. SELECT ename, sal, 12*(sal+100) FROM emp;

C. SELECT ename, sal, (12*sal)+100 FROM emp;

D. No change is required to achieve the desired results.

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 11
Which two statements are true regarding indexes? (Choose two.)

A. You can create only one index by using the same columns.

B. You can create more than one index by using the same columns if you specify distinctly
different combinations of the columns.

C. They can be created on tables and simple views.

D. They can be created on tables and clusters.

Discussion 0

Correct Answer: B,D Vote an answer

QUESTION NO: 12
Which two statements are true about WHERE and HAVING clauses? (Choose two)

A. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

B. A HAVING clause CANNOT be used in sub queries.

C. A WHERE clause can be used to restrict both rows and groups.

D. A HAVING clause can be used to restrict both rows and groups.

E. A HAVING clause can be used to restrict groups only.

F. A WHERE clause can be used to restrict rows only.

Discussion 0

Correct Answer: E,F Vote an answer

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

QUESTION NO: 13
See the Exhibit and examine the structure of ORD table: Exhibit:

Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, '25-jan-2007,101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?

A. The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.

B. All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.

C. All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.

D. The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.

Discussion 0

Correct Answer: C Vote an answer

QUESTION NO: 14
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 cannot have null values.
2) The order date cannot have null values and the default should be the current date.
3) The order amount should not be less than 50.
4) The order status will have values either shipped or not shipped.
5) The order payment mode should be cheque, credit card, or cash on delivery (COD).
Which is the valid DDL statement for creating the ORD_DETAIL table?

A. CREATE TABLE ord_details
(ord_id NUMBER(2),
ord_date DATE NOT NULL DEFAULT SYSDATE,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount >= 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));

B. CREATE TABLE ord_details
(ord_id NUMBER(2) CONSTRAINT ord_id_pk PRIMARY KEY,
ord_date DATE DEFAULT SYSDATE NOT NULL,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount >= 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));

C. CREATE TABLE ord_details
(ord_id NUMBER(2) CONSTRAINT ord_id_nn NOT NULL,
ord_date DATE DEFAULT SYSDATE NOT NULL,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount > 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));

D. CREATE TABLE ord_details
(ord_id NUMBER(2) CONSTRAINT ord_id_uk UNIQUE NOT NULL,
ord_date DATE DEFAULT SYSDATE NOT NULL,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount > 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));

Discussion 0

Correct Answer: B Vote an answer

QUALITY AND VALUE

Tested and Approved

Easy to Pass

Try Before Buy

RECENT DISCUSSIONS

Useful Links

Contact Us