Author Question: With Oracle Database, data must be entered using SQL INSERT statements. Indicate whether the ... (Read 39 times)

asd123 · **on:** Jul 7, 2018

With Oracle Database, data must be entered using SQL INSERT statements.

Indicate whether the statement is true or false

Question 2

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter S using standard SQL?

A) SELECT
FROM EMPLOYEE
WHERE Name IN 'S';
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C) SELECT
FROM Name
WHERE EMPLOYEE LIKE 'S';
D) SELECT
FROM EMPLOYEE
WHERE Name LIKE 'S';