4. What is metadata and how do DBAs determine the structure of tables in a database?
Metadata is data about data, which means the internal structure of the database, such as the names of the tables, the columns in each table, the data types, and queries. If all vendors implemented the INFORMATION_SCHEMA views, life would be easier. For now, you need to learn the proprietary views used by each vendor.