Multiple choice technology databases

Which three are valid ways to minimize dependency failure? (Choose three)

  1. Querying with the SELECT * notification.

  2. Declaring variables with the %TYPE attribute.

  3. Specifying schema names when referencing objects.

  4. Declaring records by using the %ROWTYPE attribute.

  5. Specifying package.procedure notation while executing procedures.
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

SELECT * with notifications (A) automatically captures schema changes. %TYPE attribute (B) anchors variables to column datatypes, reducing coupling. %ROWTYPE attribute (D) mirrors table structure for records, minimizing maintenance when tables change. Schema names (C) increase coupling by hardcoding references. Package.procedure notation (E) doesn't affect dependency failure - it's just execution syntax.

Keep practicing — related questions