Free Access Oracle.1z0-071.v2023-05-08.q154 Practice Test (Page 7)

Question 26

Which three statements are true regarding subqueries? (Choose three.)

A.Multiple columns or expressions can be compared between the main query and subquery.

B.Subqueries can contain ORDER BY but not the GROUP BY clause.

C.Main query and subquery can get data from different tables.

D.Subqueries can contain GROUP BY and ORDER BY clauses.

E.Main query and subquery must get data from the same tables.

F.Only one column or expression can be compared between the main query and subquery.

Question 27

Which two statements are true regarding the USINGand ONclauses in table joins?

A.Both USINGand ONclauses can be used for equijoins and nonequijoins.

B.A maximum of one pair of columns can be joined between two tables using the ONclause.

C.The ON clause can be used to join tables on columns that have different names but compatible data types.

D.The WHEREclause can be used to apply additional conditions in SELECTstatements containing the ON or the USINGclause.

Question 28

View the Exhibit and examine the data in the PROMOTIONStable.

PROMO_BEGIN_DATEis stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POSTcategory that were launched before January 1, 2000.
Which SQL statement would you use?
SELECT promo_name, promo_cost, promo_begin_date

A.FROM promotions
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
SELECT promo_name, promo_cost, promo_begin_date

B.FROM promotions
WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
SELECT promo_name, promo_cost, promo_begin_date

C.FROM promotions
WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
SELECT promo_name, promo_cost, promo_begin_date

D.FROM promotions
WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

Question 29

Examine the structure of the EMPLOYEES table. (Choose the best answer.) You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

A.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
(SELECT employee_id FROM employees WHERE employee_id = 100)UNION
ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date >
SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM
employeesWHERE salary > 10000);

B.(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;

C.SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id
100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE
hire_date > SYSDATE- 180;

D.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
(SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -
180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary >
10000;

Question 30

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable referencing the PRODUCTStable.
The CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERS and TIMEStables, respectively.
Examine this command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true?

A.The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

B.The NEW_SALEStable would get created and all the NOTNULLconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

C.The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.

D.The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.

Other Version: 2208Oracle.1z0-071.v2025-03-22.q314; 5995Oracle.1z0-071.v2024-10-24.q196; 2444Oracle.1z0-071.v2023-10-02.q276; 6174Oracle.1z0-071.v2022-09-21.q298; 4974Oracle.1z0-071.v2022-08-30.q239; 24728Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 144HRCI.aPHRi.v2025-12-22.q195; 107APICS.CSCP.v2025-12-22.q352; 107SAP.C_SIGPM_2403.v2025-12-22.q25; 114Nutanix.NCP-CI-Azure.v2025-12-22.q27; 106EMC.D-PEMX-DY-23.v2025-12-22.q45; 113SAP.C_S4CS_2502.v2025-12-22.q29; 115ISA.ISA-IEC-62443.v2025-12-22.q112; 175HashiCorp.HCVA0-003.v2025-12-20.q102; 127SAP.C_SAC_2501.v2025-12-20.q21; 112Snowflake.DAA-C01.v2025-12-20.q172

Question 26

Question 27

Question 28

Question 29

Question 30

Download PDF File