We want to select all employees from a table named EMPLOYEE for employees whose last name is not 'Adam'?
Please help me with Oracle 12
Question 18
We want to select all employees from a table named EMPLOYEE for employees whose last name is not 'Adam'?
Question 18 options:
|
SELECT FROM employee WHERE Last_Name NOT = 'Adam' ; |
|
|
SELECT * FROM employee WHERE Last_Name = 'Adam' ; |
|
|
SELECT * FROM employee WHERE Last_Name <> 'Adam' ; |
|
|
SELECT all FROM employee WHERE Last_Name NOT LIKE 'Adam' ; |
Question 19
SEQUENCE is automatically generates number in INSERT statement
Question 19 options:
|
with the usage of SEQUENCENAME.NEXT-VALUE |
|
|
with the usege of SEQUENCENAME.NEXTVAL |
|
|
with the usage of NEXT.VAL |
|
|
NONE OF ABOVE |
Question 20
Which of the following is a valid SQL statement?
Question 20 options:
|
SELECT SYSDATE; |
|
|
SELECT title FROM books; |
|
|
SELECT title and isbn FROM booksdual; |
|
|
none of the above |
Step by step
Solved in 3 steps
