Diksha IT Training Centre

SQL QUIZ with Answer Part 3. Hello Everyone, Today I will start SQL quiz part 3 , this is important for those guys who is preparing for OCA(Oracle certified Associate) certification. I suggest you to go through my previous Oracle SQL and PL/SQL blogs in Archive folder for your reference. Note: This Type of SQL and PL/SQL questions asked in Oracle Certification exams. Before part 3 please explore my below blogs SQL quiz Part1 and SQL quiz Part2. https://dheeraj60.blogspot.com/2020/07/sql-quiz-practice-for-oca-with-answer.html https://dheeraj60.blogspot.com/2020/07/sql-quiz-with-answer-part-2-dotcmdb.html Let’s start the quiz with Questions and Answers: 1.   You need to create a PL/SQL program to insert records into employee table. Which block of code successfully uses the insert command? A. DECLARE v_hiredate DATE:=SYSDATE: BEGIN INSERT INTO emp(empnp, ename, hiredate, deptno) VALUES(empno_sequence.nextval, 'and name',v_hirerdate and deptno) B. DECLARE v-hiredate D...