Install MySQL or Oracle server free version, read their getting started manuals,
ID: 3729316 • Letter: I
Question
Install MySQL or Oracle server free version, read their getting started manuals, and run the following queries in SQL (the queries are from MySQL 8.0 Reference Manual): Question 1 CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); Question 2 INSERT INTO pet VALUES ('Puffball', 'Diane', 'hamster, f, '1990-03-30, NULL); INSERT INTO pet VALUES ('Fluffy', 'Harold', 'cat', 'f', '1993-02-04', NULL); INSERT INTO pet VALUES ('Bowser', 'Diane', 'bird','f','1979-08-31','1985-07-29'); Question 3: SELECT FROM pet; Question 4: SELECT * FROM pet WHERE birth >= '1990-01-01'; Question 5: DELETE FROM pet WHERE birth>1990-01-01'; SELECT * FROM pet wHERE birth >= '1990-01-01';Explanation / Answer
Solution:
After executing above queries the result is:
1)
Table name: pet
A table with the following column is created.
2)
The above details will be entered into thew database through the given query.
3)
1985-07-29
The above table will be displayed upon executing the guven query.
4)
This table will be the output of the given query.
5)
Basically NULL will be the result becasue there is no tuple to satisfy the requirement of the query.
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)
name owner species sex birth death