Multiple choice technology

Derived Table has the following features

  1. You can not include complex calculations and functions in a derived table.

  2. Reduced maintenance of database summary tables

  3. Derived table provides real time data analysis

  4. None
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Derived tables reduce maintenance overhead because they eliminate the need to manually create and update physical database summary tables. They provide real-time data analysis by executing queries against current data rather than potentially stale pre-aggregated tables. Option A is incorrect because derived tables can include complex calculations and functions.

Keep practicing — related questions