Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 41)

Question 196

Which three actions can you perform only with system privileges? (Choose three.)

A.Execute a procedure in another schema.

B.Use the WITH GRANT OPTIONclause.

C.Query any table in a database.

D.Access flat files via a database, which are stored in an operating system directory.

E.Log in to a database.

F.Truncate a table in another schema.

Question 197

Which two statements are true about single-row functions? (Choose two.)

A.CEIL: can be used for positive and negative numbers

B.FLOOR: returns the smallest integer greater than or equal to a specified number

C.TRUNC: can be used with NUMBER and DATE values

D.CONCAT: can be used to combine any number of values

E.MOD: returns the quotient of a division operation

Question 198

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

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

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

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

D.Delete statements can always be done on a table tough a view.

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

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

Question 199

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:

You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?

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

B.SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN department_details d ON (c.department_id<>d. department_id)

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

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

Question 200

Which three are true about subqueries?

A.A subquery cannot be used in a FROM clause.

B.<ANY returns true if the argument is less than the highest value returned by the subquery.

C.=ANY can only evaluate the argument against a subcjuery if it returns two or more values.

D.A subquery cannot be used in the select list.

E.A subquery can be used in a WHERE clause.

F.A subquery can be used in a HAVING clause.

G.< any returns true if the argument is less than the lowest value returned by the subquery.

Other Version: 4124Oracle.1z0-071.v2025-03-22.q314; 7454Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25883Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 122Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 208Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 196

Question 197

Question 198

Question 199

Question 200

Download PDF File