Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

1z0-071 Oracle Database 12c SQL Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Oracle 1z0-071 Oracle Database 12c SQL certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Oracle 1z0-071 Premium Access     Download Demo    
Page: 5 / 5
Total 326 questions

Which two are true about the precedence of opertors and condtions

A.

+ (addition) has a higher order of precedence than * (mliplpition)

B.

NOT has a higher order of precedence than AND and OR in a condition.

C.

AND and OR have the same order of precedence in a condition

D.

Operators are evaluated before conditions.

E.

|| has a higher order of precedence than +(addition)

Examine the description of the transactions table:

Which two SQL statements execute successfully?

A.

SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

B.

SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

C.

SELECT customer_id CUSTID, transaction_date TRANS_DATE，amount+100 DUES FROM transactions;

D.

SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

E.

SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

Which three are true about the CREATE TABLE command?

A.

It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

B.

The owner of the table should have space quota available on the tablespace where the table is defined.

C.

It implicitly executes a commit.

D.

It implicitly rolls back any pending transactions.

E.

A user must have the CREATE ANY TABLE privilege to create tables.

F.

The owner of the table must have the UNLIMITED TABLESPACE system privilege.

Examine this partial query:

SELECT ch.channel_type, t.month, co.country_code, SUM(s.amount_sold) SALES

FROM sales s, times t, channels ch, countries co

WHERE s.time_ id = t.time id

AND s.country_ id = co. country id

AND s. channel id = ch.channel id

AND ch.channel type IN ('Direct Sales', 'Internet')

AND t.month IN ('2000-09', '2000-10')

AND co.country code IN ('GB', 'US')

Examine this output:

Which GROUP BY clause must be added so the query returns the results shown?

A.

GROUP BY ch.channel_type, t.month, co.country code;

B.

GROUP BY ch.channel_type,ROLLUP (t month, co. country_ code) ;

C.

GROUP BY CUBE (ch. channel_ type, t .month, co. country code);

D.

GROUP BYch. channel_ type, t.month,ROLIUP (co. country_ code) ;

Examine the description of the EMPLOYEES table:

NLS_DATE_FORMAT is set to DD-MON-YY.

Which query requires explicit data type conversion?

A.

SELECT salary + 120.50 FROM employees;

B.

SELECT SUBSTR(join date, 1, 2)- 10 FROM employees;

C.

SELECT join date 11.’11 salary FROM employees;

D.

SELECT join date FROM employees where join date > *10-02-2018*;

E.

SELECT join date + 20 FROM employees;

Which two statements will return the names of the three employees with the lowest salaries?

A.

SELECT last_name, salary

FROM employees

WHERE ROWNUM<=3

B.

SELECT last_name,salary

FROM employees

ORDER BY salary

FETCH FIRST 3 ROWS ONLY;

C.

SELECT last_name,salary

FROM employees

WHERE ROWNUM<=3

ORDER BY (SELECT salary FROM employees);

D.

SELECT last_name,salary

FROM (SELECT * FROM employees ORDER BY salary)

E.

SELECT last_name,salary

FROM employees

FETCH FIRST 3 ROWS ONLY

ORDER BY salary;

Which three statements are true?

A.

A customer can exist in many countries.

B.

The statement will fail if a row already exists in the SALES table for product 23.

C.

The statement will fail because subquery may not be I contained in a values clause.

D.

The SALES table has five foreign keys.

E.

The statement will execute successfully and a new row will be inserted into the SALES table.

F.

A product can have a different unit price at different times.

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:

SELECT DISTINCT quantity * unit_price total_paid FROM order_items ORDER BY ;

Which two can replace so the query completes successfully?

A.

quantity

B.

quantity, unit_price

C.

total_paid

D.

product_id

E.

quantity * unit_price

Examine the description of the EMPLOYEES table:

The session time zone is the same as the database server

Which two statements will list only the employees who have been working with the company for more than five years?

A.

SELECT employee_ name FROM employees WHERE (SYSDATE – hire_ data) / 365>5

B.

SELECT employee_ name FROM employees WHERE (SYSTIMESTAMP – hire_ data) / 365>

C.

SELECT employee_ name FROM employees WHERE (CUARENT_ DATE – hire_ data / 365>5

D.

SELECT employee_ name FROM employees WHERE (SYSNAYW – hire_ data / 12> 3

E.

SELECT employee_ name FROM employees WHERE (SYSNAYW – hire_ data / 12> 3

F.

SELECT employee_ name FROM employees WHERE (CUNACV_ DATE – hire_ data / 12> 3

Which two are true about the WITH GRANT OPTION clause?

A.

The grantee can grant the object privilege to any user in the database, with of without including this option.

B.

The grantee must have the GRANT ANY OBJECT PRIVILEGE system prvilege to use this option.

C.

It can be used when granting privileges to roles.

D.

It can be used for system and object privileges.

E.

It cannot be used to pass on privileges to PUBLIC by the grantee.

F.

It can be used to pass on privileges to other users by the grantee.

Which three statements are true regarding single row subqueries?

A.

They must be placed on the left side of the comparison operator or condition.

B.

They must return a row to prevent errors in the SQL statement.

C.

A SQL statement may have multiple single row subquery blocks.

D.

They can be used in the HAVING clause.

E.

They must be placed on the right side of the comparison operator or condition.

F.

They can be used in the clause.

Which two are true about scalar subquery expressions?

A.

You cannot correlate them with a table in the parent statement

B.

You can use them as a default value for a column.

C.

.You must enclose them in parentheses.

D.

They can return at most one row.

E.

They can return two columns.

Which two statements will return the names of the three employees with the lowest salaries?

A.

SELECT last_ name, salary

FROM employees

FETCH FIRST 3 ROWS ONLY

ORDER BY salary;

B.

SELECT last name, salary

FROM employees

ORDER BY salary

FETCE FIRST 3 RONS ONLY;

C.

SELECT last_ name, salary

FBOM employees

WEERE

ORDER BY SELECT

ROINUM <= 3

salary FROM

employees);

D.

SELECT last_ name, salary

FROM

(SELECT” FROM employees ORDER BY salary)

WHERE ROWNUM <=3

E.

SELECT last_ name, salary

FROM employees

WHERE ROWNUM <=3

ORDER BY salary

SELECT *

FROM bricks,colors;

Which two statements are true?

A.

You can add an ON clause with a join condition.

B.

You can add a WHERE clause with filtering criteria.

C.

It returns the number of rows in BRICKS plus the number of rows in COLORS.

D.

You can add a USING clause with a join condition.

E.

It returnsthe same rows as SELECT * FROM bricks CROSS JOIN colors.

Which two statements are true about external tables?

A.

Indexes can be created on them.

B.

You can populate them from existing data in the database by using the CREATE TABLE AS SELECT command.

C.

DML statements cannot be used on them.

D.

Their data can be retrieved by using only SQL or PL/SQL.

E.

Their metadata and actual data are both stored outside the database.

Which three statements are true about dropping and unused columns in an Oracle database?

A.

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

B.

A DROP COLUMN command can be rolled back.

C.

An UNUSED column's space is remained automatically when the block containing that column is next queried.

D.

An UNUSED column's space is remained automatically when the row containing that column is next queried.

E.

Partition key columns cannot be dropped.

F.

A column that is set to NNUSED still counts towards the limit of 1000 columns per table.

Examine this statement:

SELECT last name

FROM employees

ORDER BY CASE WHEN salary = (SELECT MAX(salary) FROM employees)

THEN ‘A’

ELSE last_ name

END ,last_name DESC;

Which two statements are true?

A.

The names of employees earning the maximum salary will appear first in descending order.

B.

The names of employees earning the maximum salary will appear first In ascending order.

C.

All remaining employee names will appear in ascending order.

D.

All remaining employee names will appear in an unspecified order.

E.

All remaining employee names will appear in descending order.

F.

The names of employees earning the maximum salary will appear first in an unspecified order.

Oracle 1z0-071 Premium Access     Download Demo    
Page: 5 / 5
Total 326 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved