Databases and Structured Query Language

Front

What is data analysis?

Back

The process of identifying, cleaning, transforming, and modeling data (structured or unstructured) to get useful insights to support the critical decision-making process.

Front

What is metadata?

Back

Metadata describes the relevant information about the data, such as author, size, date modified, etc. It is essentially data about data.

Front

What is a database?

Back

A logical repository or storage of data, typically created on a Database Management System (DBMS).

Front

What is a Database Management System (DBMS)?

Back

System software for creating and managing databases, allowing users to create, retrieve, update, and delete data.

Front

What is a database engine?

Back

The underlying software component that a DBMS uses to create, read, update, and delete data from a database.

Front

Name some examples of DBMS.

Back

IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle RDBMS, Quick Base, SAP Sybase ASE, Teradata, Postgre SQL.

Front

What is a non-relational database?

Back

A database that does not use the tabular schema of rows and columns found in traditional database systems, optimized for specific data requirements.

Front

What is a relational database?

Back

A database structured to recognize relations between stored items of data.

Front

What is a schema in a database?

Back

A collection of database objects associated with one particular database username.

Front

What is a session in database terms?

Back

A connection to the database, initiated by either a user or an application.