Skip to main content

Posts

Showing posts with the label OCA Quiz Part2

SQL QUIZ with Answer Part 2 #DOTC_Mdb

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