What is the name of the special internal database where the query optimizer finds information?

The relational catalog is the description of the data base and its subjects. Commonly, this information is stored in the data base or in another table - possibly with a reserved name and is not directly updated by user applications. An alternative word for relational catalog is "system catalog" or occasionally called "data dictionary". Examples of entities contain:

- Databases 

- Tables

- Logs

- Variables

- Columns

- Constraints

- Users

Huhuhubuhuhuhuhuhuh ya um

Solution: the categorization of functional and non-functional requirement are as follows: some of the more typical functional requirements include: • business rules• transaction corrections, adjustments and cancellations• administrative functions• authentication• authorization levels• audit tracking• external interfaces• certification requirements• reporting requirements• historical data• legal or regulatory requirementswhile,some typical non-functional requirements are: • performance – for example response time, throughput, utilization, static volumetric• scalability• capacity• availability• reliability• recoverability• maintainability• serviceability• security• regulatory• manageability• environmental• data integrity• usability• interoperability