[2024-06-24更新,250問] 無料Oracle 1z0-071試験問題集、1z0-071予想試験(ページ 29)

1z0-071 試験問題 136

Which statement adds a column called SALARYto the EMPLOYEEStable having 100 rows, which cannot contain null?

A. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;

B. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT 0 NOT NULL;

C. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) NOT NULL;

D. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT NOT NULL;

1z0-071 試験問題 137

Which three are true about the MERGE statement?

A. It can update the same row of the target table multiple times.

B. It can merge rows only from tables.

C. It can use subqueries to produce source rows.

D. It can update, insert, or delete rows conditionally in multiple tables.

E. It can combine rows from multiple tables conditionally to insert into a single table.

F. It can use views to produce source rows.

1z0-071 試験問題 138

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

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?
SELECT order_id

A. FROM order_items
WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)
FROM order_items
GROUP BY order_id)

B. FROM order_items
GROUP BY order_id
HAVING SUM(unit_price*quantity) = (SELECT MAX(SUM(unit_price*quantity)) FROM order_items GROUP BY order_id); SELECT order_id

C. FROM order_items
WHERE(unit_price*quantity) = MAX(unit_price*quantity)
GROUP BY order_id;
SELECT order_id

D. FROM order_items
WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity)
FROM order_items)
GROUP BY order_id;
SELECT order_id

1z0-071 試験問題 139

Examine the description of the CUSTOMERStable:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A. SELECT * FROM customers WHERE city LIKE 'D_';

B. SELECT * FROM customers WHERE city = '%D_';

C. SELECT * FROM customers WHERE city = 'D_%';

D. SELECT * FROM customers WHERE city LIKE 'D_%';

1z0-071 試験問題 140

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Which three statements are true?

A. The SALES table has five foreign keys.

B. The statement will fail because a subquery may not be contained in a VALUES clause.

C. A customer can exist in many countries.

D. A product can have a different unit price at different times.

E. The statement will fail if a row already exists in the SALES table for product 23.

F. The statement will execute successfully and a new row will be inserted into the SALES table.

他のバージョン: 334Oracle.1z0-071.v2026-02-09.q105; 1035Oracle.1z0-071.v2025-04-23.q282; 1321Oracle.1z0-071.v2024-01-24.q245; 1628Oracle.1z0-071.v2023-11-10.q292; 1510Oracle.1z0-071.v2023-06-29.q199; 3209Oracle.1z0-071.v2022-08-26.q318

最新アップロード: 146Salesforce.Mule-Arch-201.v2026-06-13.q56; 132Fortinet.NSE7_SOC_AR-7.6.v2026-06-13.q26; 139HP.HPE0-G04.v2026-06-13.q33; 160CrowdStrike.CCFA-200b.v2026-06-13.q88; 165Salesforce.Mule-Dev-201.v2026-06-12.q88; 178WGU.Information-Technology-Management.v2026-06-12.q113; 294CuramSoftware.CS0-003.v2026-06-12.q520; 203Salesforce.NP-Con-101.v2026-06-11.q92; 191RealEstate.Maryland-Real-Estate-Salesperson.v2026-06-11.q107; 249Microsoft.AZ-204.v2026-06-11.q260

1z0-071 試験問題 136

1z0-071 試験問題 137

1z0-071 試験問題 138

1z0-071 試験問題 139

1z0-071 試験問題 140

PDFファイルをダウンロード