PLSQL Set 3

SELECT TRIGGER_NAME FROM USER_TRIGGERS; ✘ CREATE OR REPLACE TRIGGER my_trigger_name; ✘ ALTER TRIGGER trigger_name COMPILE; ✘ DROP trigger trigger_name; ✔

It specifies that only the rows that would be retrieved by the sub query can be inserted ✘ It specifies that only the rows that would be retrieved by the sub query can be updated ✘ It specifies that only the rows that would be retrieved by the sub query can be deleted ✘ It specifies that only the rows that would be retrieved by the sub query can be inserted, updated, or deleted ✔

NOCACHE ✘ ORDER ✘ NOORDER ✘ NOCYCLE ✔

Inter ✘ Intersect ✘ Union ✘ All of these ✔

It returns the coefficient of determination or the R-squared of the regression line. ✘ It returns the intercept on the y-axis of the regression line. ✘ It returns the slope of the regression line. ✘ It returns the intercept on the x-axis of the regression line. ✔

^

✘

#

✘ ? ✘

*

✔

Self ✘ Inner self ✘ Self join on a table ✘ Outer self ✔

SELECT (salary)VARIANCE FROM employee; ✘ SELECT VARIANCE(salary) FROM employee; ✘ SELECT salary (VARIANCE) FROM employee; ✘ None of these ✔

UNION ✘ UNION ALL ✘ INTERSECT ✘ None of these ✔

It occurs because a view was attempted to be retrieved for execution and was found to be invalid. ✘ It occurs because a trigger was attempted to be retrieved for execution and was found to be invalid. ✘ It occurs because a procedure was attempted to be retrieved for execution and was found to be invalid. ✘ None of these ✔