Australian National University COMP 6240 Quiz 2-ALL ANSWERS CORRECT

DELETE statement can delete tuples in a relation but does not remove the relation schema.
Select one:
True


False


Feedback
DELETE statement can delete tuples in a relation and DROP TABLE statement can remove
the relation schema.
The correct answer is 'True'.

Question 2
Correct
Mark 0.10 out of 0.10




m
er as
Flag question




co
eH w
o.
rs e
ou urc
Question text
o

"SELECT age < 30 AND salary > 60000 FROM Employee;" is a correct SQL statement to
aC s


select all the employees from "Employee" table where the value of column "age" is below 30
v i y re



and the value of column "salary" is above 60000.
Select one:
True
ed d




False
ar stu
sh is




Feedback
Th




The correct one should be ``SELECT * FROM Employee WHERE age < 30 AND salary >
60000;"
The correct answer is 'False'.

Question 3
Correct
Mark 0.10 out of 0.10




This study source was downloaded by 100000827039679 from CourseHero.com on 08-12-2021 01:25:30 GMT -05:00


https://www.coursehero.com/file/35221734/Quiz2docx/