Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 13)

Question 56

You execute this command:
ALTER TABLE employees SET UNUSED (department_id);
Which two are true?

A.The DEPARTMENT_ID column is set to null for all tows in the table

B.A query can display data from the DEPARTMENT_ID column.

C.No updates can be made to the data in the DEPARTMENT_ID column.

D.The DEPARTMENT_ID column can be recovered from the recycle bin

E.A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.

F.The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.

Question 57

You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

A.In generates an error because TO_CHARshould be replaced with TO_DATE.

B.In generates an error because rrrrshould be replaced by rrin the format string.

C.It executes successfully and returns the correct result.

D.In generates an error because fmand double quotation marks should not be used in the format string.

E.It executes successfully but does not return the correct result.

Question 58

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

A.SELECT product_id, UPPER(product_name)
FROM product_information
WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;

B.SELECT product_id
FROM product_information
WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');

C.SELECT UPPER(product_name)
FROM product_information
WHERE product_id = 2254;

D.SELECT UPPER(product_name)
FROM product_information;

Question 59

View the exhibit and examine the structure of the STORES table.

You must display the NAME of stores along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATE in the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?

A.SELECT name, concat(address||', '||city||', ',country) AS full_address, start_date, property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN(start_date,'01-JAN-2000') <=36;

B.SELECT name, address||', '||city||', '||country AS full_address, start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN(start_date,TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

C.SELECT name, concat(address||', '||city||', ',country) AS full_address, start_date,property_price, property_price*115/100FROM storesWHERE TO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

D.SELECT name, concat(address||', '||city||', ', country) AS full_address, start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN(start_date,TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

Question 60

View the Exhibit and examine the structure of the SALES table.

The following query is written to retrieve all those product IDs from the SALEStable that have more than
55000 sold and have been ordered more than 10 items.

Which statement is true regarding this SQL statement?

A.It produces an error because COUNT (*)should be specified in the SELECTclause also.

B.It executes successfully but produces no result because COUNT(prod_id)should be used instead of COUNT(*).

C.It produces an error because COUNT (*)should be only in the HAVING clause and not in the WHERE clause.

D.It executes successfully and generates the required result.

Other Version: 1039Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 56

Question 57

Question 58

Question 59

Question 60

Download PDF File