Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 42)

Question 201

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?

A.Display products whose prod_min_PRICE is more than the average PROD_LIST_PRlCE of all products, and whose status is orderable.

B.Display suppliers whose PR0D_LIST_PRICE is less than 1000.

C.Display the minimum prod_list_price for each product status.

D.Display the total number of products supplied by supplier 102 which have a product status of obsolete.

E.Display the number of products whose PROD_LIST_PRlCE is more than the average prod_list_price.

Question 202

View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

A.SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"FROM customers;

B.SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

C.SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

D.SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

Question 203

Which two are the minimal requirements for a self-join? (Choose two.)

A.There must be a condition on which the self-join is performed.

B.Only equijoin conditions may be used in the query.

C.No other condition except the self-join may be specified.

D.Outer joins must not be used in the query.

E.The table used for the self-join must have two different alias names in the query.

Question 204

Examine the SQL statement used to create the TRANSACTION table. (Choose the best answer.) SQL > CREATE TABLE transaction (trn_id char(2) primary key, Start_date date DEFAULT SYSDATE, End_date date NOT NULL); The value 'A1' does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

A.INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')

B.INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')

C.INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))

D.INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))

Question 205

Examine the data in the ORD_ITEMS table:

Evaluate this query:

Which statement is true regarding the result?

A.It returns an error because all the aggregate functions used in the HAVINGclause must be specified in the SELECT list.

B.It returns an error because the HAVINGclause should be specified after the GROUP BYclause.

C.It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

D.It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

Other Version: 4623Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 252PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 362Nokia.4A0-113.v2026-05-01.q69; 397EC-COUNCIL.312-49v11.v2026-04-30.q214; 312Microsoft.MB-820.v2026-04-30.q101; 248Salesforce.MC-202.v2026-04-30.q57; 276BICSI.INSTC_V8.v2026-04-29.q53; 411NMLS.MLO.v2026-04-28.q82; 277NCARB.Project-Management.v2026-04-28.q27; 494EMC.D-AV-DY-23.v2026-04-27.q184; 1304ServiceNow.CSA.v2026-04-27.q483

Question 201

Question 202

Question 203

Question 204

Question 205

Download PDF File