Diksha IT Training Centre

SQL QUIZ with Answer Part 4.   Hello Everyone, Today I will start SQL Quiz part 4, 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 as well as good for you to check your SQL and PL/SQL skills. Also Good for Candidate who is preparing for interview. Before part 3 please explore my below blogs SQL Quiz Part1 SQL Quiz Part2 , SQL Quiz Part3. https://dheeraj60.blogspot.com/2020/07/sql-quiz-with-answer-part-3-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/sql-quiz-with-answer-part-2-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/sql-quiz-practice-for-oca-with-answer.html   Let’s start the quiz with Questions and Answers: 1.   Which statement is true a drop table command is executed on a table? A. Only a DBA can execute the drop table c

OCA Certification Benefits. First step for Oracle Certification is OCA known as Oracle Certified associate and then OCP known as Oracle Certified Professional. After completing first Step you have option whether you want to move in Development or in Administrative it’s up to your interest.   I almost cover all the SQL and PL/SQL topics in blog and started quiz for preparing Oracle certification so please go through all my previous blogs where you will able to find topics in archive folders. dheeraj60.blogspot.com Let’s understand the benefits of earning OCA and OCP certification as below:   Benefits of an Oracle Certification. 1. Get Job easily in IT Sector as Database developer or DBA. 2. Improves your job satisfaction 3. Improves your Job performance 4. Increase the productivity level 5. Increases the credibility with customers 6. Improve your potential earning power to command a higher salary. 7. Expand your knowledge base and validate your skills to appeal to potential e

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

SQL QUIZ with Answer Part 2. Hello Everyone, Today I will start SQL quiz part 2 , 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 2 please explore my below blog SQL quiz Part1. https://dheeraj60.blogspot.com/2020/07/sql-quiz-practice-for-oca-with-answer.html Let’s Start the quiz : 1. Which statement about implicit cursors is true? A. Implicit cursors are declared implicitly only for DML statements. B. Implicit cursors are declared implicitly for all the DML and SELECT statements. C. Programmers need to close all the implicit cursors before the end of the PL/SQL program. D. Programmers can declare implicit cursors by using the cursor type in the declaration section. Answer: B Explanation: Answer B is correct because implic

SQL QUIZ with Answer Part 1. Hello Everyone, Today I will start SQL quiz part 1 , 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 blogs from archive folder May and June for your reference. Dheeraj60.blogspot.com Let’s start with Quiz: 1. The employee table contains these columns: Last_name Varchar (25) First_name Varchar (25) Salary INT You need to display the names of employees on more than an average salary of all employees. Evaluate the SQL statement. SELECT, LAST_NAME, FIRST_NAME from employee where salary< avg(salary);   Which change should you make to achieve the desired results? A. Change the function in the Where clause. B. Move the function to the select clause and add a group clause. C. Use a sub query in the where clause to compare the average salary value. D. Move the function to the select clause and add a group by clause and a having clause.   Ans