Multiple choice general knowledge

Among the following oracle queries, identify the correct ones with correct format...

  1. INSERT INTO employee('sachin',1001,22,cse,476);

  2. SELECT * FROM employee WHERE id = 2;

  3. UPDATE employee SET last_name = 'Orange' WHERE id = 2;

  4. SELECT MONTHS_BETWEEN('25-MAY-2005', '15-JAN-2005') FROM dual;
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

Option A is incorrect - INSERT requires VALUES keyword and parentheses: INSERT INTO employee VALUES ('sachin',1001,22,cse,476) or INSERT INTO employee (col1,col2,...) VALUES (...). Options B, C, and D are correctly formatted Oracle SQL statements.

Keep practicing — related questions