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

Question 86

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)

A.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.

B.The CUST_STATUS column would give an error.

C.The TRANS_VALIDITY column would have a maximum size of one character.

D.The TRANS_VALIDITY column would give an error.

E.The CUST_STATUS column would store exactly one character.

F.The CUST_CREDIT_LIMIT column would be able to store decimal values.

Question 87

Evaluate the following CRTEATE TABLE commands:
CREATE_TABLE orders
(ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER (4) );
CREATE TABLE ord_items
(ord _no NUMBER (2),
item_no NUMBER(3),
qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200),
expiry_date date CHECK (expiry_date> SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no),
CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) );
The above command fails when executed. What could be the reason?

A.SYSDATE cannot be used with the CHECK constraint.

B.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.

C.The CHECK constraint cannot be placed on columns having the DATE data type.

D.The BETWEEN clause cannot be used for the CHECK constraint.

Question 88

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

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

B.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.

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

D.Delete statements can always be done on a table through a 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.The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

Question 89

Evaluate the following CREATE TABLEcommand:

Which statement is true regarding the above SQL statement?

A.It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command.

B.It would give an error because the USING INDEX clause cannot be used on a composite primary.

C.It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID PK would be created.

D.It would execute successfully and only ORD_ITM_IDX index would be created.

Question 90

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

A.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c.department_id);

B.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d.department_id);

C.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d.department_id);

D.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c.department_id);

Other Version: 1041Oracle.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; 151Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 165TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 169PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 150Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File