Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 42)

Question 201

Which statement is true regarding external tables?

A.The CREATE TABLE AS SELECT statement can be used to upload data into regular table in the database from an external table.

B.The data and metadata for an external table are stored outside the database.

C.The default REJECT LIMIT for external tables is UNLIMITED.

D.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

Question 202

Examine the description of the PRODUCT_INFORMATION table:

Which query retrieves the number of products with a null list price?

A.SELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price IS NULL;

B.SELECT COUNT (list_price) FROM product_information WHERE list_price = NULL;

C.SELECT COUNT (list_price) FROM product_information WHERE list_price IS NULL;

D.SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

Question 203

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output?

A.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

B.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

C.SELECT TO_CHAR(SYSDATE, *DD-MON-YYYY*) - '01-JAN-2019' FROM DUAL;

D.SELECT SYSDATE - TO_DATE('01-JANUARY-2019*) FROM DUAL;

E.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY") - '01/JANUARY/2019" FROM DUAL;

Question 204

View the Exhibit and examine the structure in the EMPLOYEES tables.
Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=10;
What would be the outcome of the above SQL statement?

A.The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.

B.The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

C.The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.

D.The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.

Question 205

View the Exhibit and examine the structure of CUSTOMERS table.

Evaluate the following query:

Which statement is true regarding the above query?

A.It produces an error because the condition on the CUST_CITY column is not valid.

B.It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.

C.It produces an error because the condition on the CUST_FIRST_NAME column is not valid.

D.It executes successfully.

Other Version: 4126Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25885Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 124Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 212Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 201

Question 202

Question 203

Question 204

Question 205

Download PDF File