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

Question 46

Which two statements are true about views?

A.Tables in the defining query of a view must always exist in order to create the view.

B.Views can be updated without the need to re-grant privileges on the view.

C.The with check clause prevents certain rows from being displayed when querying the view.

D.The with check clause prevents certain rows from being updated or inserted in the underlying table through the view.

E.Views can be indexed.

Question 47

Examine the structure of the MARKS table:

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

A.SELECT student_name,SUM(subject1)FROM marksWHERE student_name LIKE 'R%';

B.SELECT SUM(subject1+subject2+subject3)FROM marksWHERE student_name IS NULL;

C.SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)FROM marksWHERE subject1 > subject2;

D.SELECT student_name subject1FROM marksWHERE subject1 > AVG(subject1);

Question 48

View the Exhibit and examine the data in the PRODUCTS table. (Choose the best answer.)

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:
SQL > SELECT prod_name, prod_category, prod_min_price FROM products
Where prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> ' '; Which statement is true?

A.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

B.It executes successfully and returns the required result.

C.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

D.It executes successfully but returns no result.

Question 49

See the Exhibit and examine the structure of the PROMOTIONS table:

Using the PROMOTIONStable, you need to find out the average cost for all promos in the range $0-2000 and
$2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

A.It generates an error because multiple conditions cannot be specified for the WHENclause.

B.It executes successfully and gives the required result.

C.It generates an error because CASEcannot be used with group functions.

D.It generates an error because NULLcannot be specified as a return value.

Question 50

You must display details of all users whose username contains the string 'ch_'. (Choose the best answer.) Which query generates the required output?

A.SELECT * FROM users Where user_name LIKE '%ch\_%' ESCAPE '\';

B.SELECT * FROM users Where user_name LIKE '%ch_';

C.SELECT * FROM users Where user_name LIKE 'ch\_%' ESCAPE '_';

D.SELECT * FROM usersWhere user_name LIKE '%ch_%'ESCAPE'%';

Other Version: 3120Oracle.1z0-071.v2025-03-22.q314; 6660Oracle.1z0-071.v2024-10-24.q196; 3001Oracle.1z0-071.v2023-10-02.q276; 6663Oracle.1z0-071.v2022-09-21.q298; 5487Oracle.1z0-071.v2022-08-30.q239; 25230Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 299Nokia.4A0-113.v2026-05-01.q69; 258EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 211Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 335NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 465EMC.D-AV-DY-23.v2026-04-27.q184; 1120ServiceNow.CSA.v2026-04-27.q483

Question 46

Question 47

Question 48

Question 49

Question 50

Download PDF File