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

Question 141

Examine the data in the EMPLOYEES table:

Which statement will compute the total annual compensation for each employee?

A.SELECT last name,
(monthly salary*12) + (monthly_commission_pct * 12) AS
annual comp
FROM employees
;

B.SELECT last_ name (monthly_ salary+ monthly_ commission _ pct) *12 AS annual_ FROM employees ;

C.SELECT last name, (monthly_ salary *12) + (monthly_ salary * 12 * NVL (monthly commission pct,0) ) As annual _ comp FROM employees;

D.SELECT last_ name, monthly_ salary*12) + (monthly_ salary * 12 * Monthly commission _Pct) AS annual_ comp FROM employees;

Question 142

View the Exhibit and examine the structure of the ORDERS table.
The columns ORDER_MODE and ORDER TOTAL have the default values'direct "and respectively.
Which two INSERT statements are valid? (Choose two.)

A.INSERT INTO orders (order_id, order_date, order mode,customer_id, order_total) VALUES (1, TO_DATE (NULL),'online',101, NULL) ;

B.INSERT INTO orders (order id, order_date, order mode, order_total)VALUES (1'10-mar-2007','online', 1000)

C.INSERT INTO (SELECT order_id, order date, customer_id FROM orders) VALUES (1,
'09-mar-2007"101);

D.INSERT INTO orders VALUES (1, '09-mar-2007', 'online',' ',1000);

E.INSERT INTO orders VALUES('09-mar-2007'DEFAULT,101, DEFALLT);

Question 143

View the exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.
ORDERS_MASTER
ORDER_ID
ORDER_TOTAL
1
1000
2
2000
3
3000
4
MONTHLY_ORDERS
ORDER_ID
ORDER_TOTAL
2
2500
3
Evaluate the following MERGE statement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total)
What would be the outcome of the above statement?

A.The ORDERS_MASTER table would contain the ORDER_IDs 1, 2, 3 and 4.

B.The ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 4.

C.The ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 3.

D.The ORDERS_MASTER table would contain the ORDER_IDs 1 and 2.

Question 144

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMStable and the ORD_SEQsequence? (Choose two.)

A.Sequence ORD_SEQcycles back to 1 after every 5000 numbers and can cycle 20 times.

B.Any user inserting rows into table ORD_ITEMSmust have been granted access to sequence ORD_SEQ.

C.If sequence ORD_SEQis dropped then the default value for column ORD_NOwill be NULL for rows inserted into ORD_ITEMS.

D.Column ORD_NOgets the next number from sequence ORD_SEQwhenever a row is inserted into ORD_ITEMSand no explicit value is given for ORD_NO.

E.Sequence ORD_SEQis guaranteed not to generate duplicate numbers.

Question 145

Which three statements are true about GLOBAL TEMPORARY TABLES?

A.A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.

B.Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

C.A trigger can be created on a GLOBAL TEMPORARY TABLE.

D.A GLOBAL TEMPORARY TABLE can have only one index.

E.A GLOBAL TEMPORARY TABLE can have multiple indexes.

F.A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.

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

Latest Upload: 282PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 412Nokia.4A0-113.v2026-05-01.q69; 440EC-COUNCIL.312-49v11.v2026-04-30.q214; 403Microsoft.MB-820.v2026-04-30.q101; 274Salesforce.MC-202.v2026-04-30.q57; 322BICSI.INSTC_V8.v2026-04-29.q53; 457NMLS.MLO.v2026-04-28.q82; 299NCARB.Project-Management.v2026-04-28.q27; 546EMC.D-AV-DY-23.v2026-04-27.q184; 1388ServiceNow.CSA.v2026-04-27.q483

Question 141

Question 142

Question 143

Question 144

Question 145

Download PDF File