Free Access Oracle.1z0-071.v2022-09-21.q298 Practice Test (Page 32)

Question 151

Which three statements are true about GLOBAL TEMPORARY TABLES?

A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

B.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

C.A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

D.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

E.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

F.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

Question 152

Examine this description of the PRODUCTStable:

Rows exist in this table with data in all the columns. You put the PRODUCTStable in read-only mode.
Which three commands execute successfully on PRODUCTS? (Choose three.)
DROP TABLE products;

A.ALTER TABLE products DROP COLUMN expiry_date;

B.ALTER TABLE products SET UNUSED (expiry_date);

C.ALTER TABLE products DROP UNUSED COLUMNS;

D.CREATE INDEX price_idx ON products (price);

E.TRUNCATE TABLE products;

Question 153

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.
The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table.
The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Examine this command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true?

A.The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

B.The NEW_SALES table would get created and all the NOT NULL constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

C.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

D.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

Question 154

Which three statements are true about Data Manipulation Language (DML)? (Choose three.)

A.DML statements require a primary key be defined on a table.

B.UPDATE statements can have different subqueries to specify the values for each updated column.

C.INSERT INTO...SELECT...FROMstatements automatically commit.

D.INSERTstatements can insert NULLS explicitly into a column.

E.DELETEstatements can remove multiple rows based on multiple conditions.

Question 155

The CUSTOMERStable has a CUST_CREDIT_LIMITcolumn of data type NUMBER.
Which two queries execute successfully? (Choose two.)

A.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;

B.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not

C.SLECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

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

E.Available') FROM customers;
SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;

Other Version: 3265Oracle.1z0-071.v2025-03-22.q314; 6792Oracle.1z0-071.v2024-10-24.q196; 3201Oracle.1z0-071.v2023-10-02.q276; 2689Oracle.1z0-071.v2023-05-08.q154; 5640Oracle.1z0-071.v2022-08-30.q239; 25382Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 286PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 414Nokia.4A0-113.v2026-05-01.q69; 447EC-COUNCIL.312-49v11.v2026-04-30.q214; 412Microsoft.MB-820.v2026-04-30.q101; 283Salesforce.MC-202.v2026-04-30.q57; 327BICSI.INSTC_V8.v2026-04-29.q53; 462NMLS.MLO.v2026-04-28.q82; 303NCARB.Project-Management.v2026-04-28.q27; 554EMC.D-AV-DY-23.v2026-04-27.q184; 1401ServiceNow.CSA.v2026-04-27.q483

Question 151

Question 152

Question 153

Question 154

Question 155

Download PDF File