7.2.5 Database Management System Facts

What functionalities does Microsoft SQL Server support?

Transaction processing, business intelligence, disaster recovery, and analytic applications.

What is an advantage of using Access?

Easy setup and introduction to relational databases.

What does Oracle continually provide for its DBMS?

Software updates to maintain a high-quality product.

When was Oracle Database released?

1980.

When was Microsoft SQL Server released?

1989.

When was Microsoft Access released?

1992.

When was MySQL originally released?

1995.

What is Microsoft Access?

A DBMS developed by Microsoft.

What is Oracle Database?

A highly-scalable, robust, industry-standard DBMS.

What is Microsoft SQL Server?

A proprietary relational database management system developed by Microsoft.

What is MySQL?

An open-source DBMS.

What is the typical use case for Microsoft Access?

Creating and managing small relational databases with a few users.

Why do many people prefer to use MySQL for managing their own websites and databases?

It provides SQL database implementation that works well for small to medium websites.

What is Oracle Database commonly trusted for?

Managing and securing enterprise databases.

What factors can be used to evaluate and compare database management systems?

Number of concurrent users, scalability, speed of access, support for data types, programming language support.

Who developed Oracle Database?

Oracle Corporation.

How does Oracle DB compare to Microsoft SQL Server and MySQL in terms of programming language support?

Oracle DB supports more programming languages.

Who currently owns and maintains MySQL?

Oracle.

What is a Database Management System (DBMS)?

Software that allows users to define, manipulate, retrieve, and manage data stored in a database.

What are the four kinds of database objects in Access?

Tables, queries, forms, and reports.