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

Question 231

You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

A.CREATE TABLE Sales
(SALESID NUMBER (4),
STOREID NUMBER (4),
ITEMID NUMBER (4),
QTY NUMBER DEFAULT = 1,
SLSDATE DATE DEFAULT 'SYSDATE',
PAYMENT VARCHAR2(30) DEFAULT CASH);

B.Create Table sales
(salesid NUMBER (4),
Storeid NUMBER (4),
Itemid NUMBER (4),
QTY NUMBER DEFAULT 1,
Slsdate DATE DEFAULT SYSDATE,
payment VARCHAR2(30) DEFAULT 'CASH');

C.CREATE TABLE Sales
(SALESID NUMBER (4),
STOREID NUMBER (4),
ITEMID NUMBER (4),
QTY NUMBER DEFAULT = 1,
SLSDATE DATE DEFAULT SYSDATE,
PAYMENT VAR
CHAR2(30) DEFAULT = "CASH");

D.CREATE TABLE Sales
(SALESID NUMBER (4),
STOREID
NUMBER (4),
ITEMID NUMBER (4),
qty NUMBER DEFAULT = 1,
SLSDATE DATE DEFAULT SYSDATE,
PAYMENT VARCHAR2(30) DEFAULT = "CASH");

Question 232

Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined?

A.The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

B.Delete statements can always be done on a table through a view.

C.Views cannot be used to add or modify rows in an underlying table If the defining query of the view contains the DISTINCT keyword.

D.Views cannot be used to add rows to an underlying table If the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

E.Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the primary key columns are not referenced in the defining query of the view.

F.Insert statements can always be done on a table through a view.

Question 233

Which three statements are true about GLOBAL TEMPORARY TABLES?

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

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

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

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

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

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

Question 234

You issued this command:

Which three statements are true? (Choose three.)

A.Views referencing HR.EMPLOYEESare dropped.

B.All constraints defined on HR.EMPLOYEESare dropped.

C.Sequences used to populate columns in the HR.EMPLOYEEStable are dropped.

D.The HR.EMPLOYEEStable may be moved to the recycle bin.

E.All indexes defined on HR.EMPLOYEESare dropped.

F.Synonyms for HR.EMPLOYEESare dropped.

Question 235

Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?

A.SELECT e.last_name, m.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.employee_id = m.manager_id)
WHERE e.employee_id = 123;

B.SELECT e.last_name, m.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.manager_id = m.employee_id)
AND e.employee_id = 123;

C.SELECT m.last_name, e.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.manager_id = m.manager_id)
WHERE e.employee_id = 123;

D.SELECT e.last_name, e.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.employee_id = m.employee_id)
WHERE e.employee_id = 123;

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

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 299Nokia.4A0-113.v2026-05-01.q69; 255EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 211Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 335NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 463EMC.D-AV-DY-23.v2026-04-27.q184; 1117ServiceNow.CSA.v2026-04-27.q483

Question 231

Question 232

Question 233

Question 234

Question 235

Download PDF File