Question

• Describe some of the differences between database management systems such as Oracle and Access. Provide specific examples of these differences.
• Create your first SQL Oracle statement after reviewing the resource link above; everyone's SQL query should be different. Provide the SQL code and describe what data is being retrieved and how you would use the information for decision purposes.
• Identify how you might come up with the same data using other SQL syntax.

Answer 1

1. ANSWER :

GIVENTHAT :

Differences between Oracle and Access are as follows :

• Oracle is the product of Oracle company and also sold by Oracle company whereas Access is the product of Microsoft and also sold by Microsoft.
• Oracle can support simultaneous users upto thousands whereas Access is only a single-user database supporting only 255 users at a time.

​​​​​​First SQL statement can be :

CREATE TABLE persson(
id NUMERIC(3),
personName VARCHAR(50),
age NUMERIC(2),
address VARCHAR(100)
);

SQL query :

SELECT * FROM persson;

This is the select query. This query is used to retrieve all the rows from the table.

This can be useful when someone wants to see the details of the entire table at once and in a structured format and make certain decisions according to the data available in the table.