Oracle PLSQL technical interview questions and answers help candidates understand advanced database programming concepts used in enterprise applications. PL/SQL is Oracle’s procedural language extension that supports functions, stored procedures, packages, exceptions, loops, and triggers. Because PL/SQL developers play an important role in backend development, companies like TCS, Wipro, Infosys, Capgemini, Cognizant, and Accenture frequently ask PL/SQL interview questions during technical rounds and placement tests. This guide provides clear explanations of the most commonly asked PL/SQL queries and coding questions. Whether you are a fresher or an experienced developer, mastering PL/SQL helps you solve real-world problems during interviews. You can also download interview PDFs and practice mock tests to boost your confidence.
Showing 10 of 35 questions
21. State true or false. !=, <>, ^= all denote the same operation.
TRUE
22. What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all
23. What command is used to get back the privileges offered by the GRANT command?
REVOKE
24. Which system tables contain information on privileges granted and privileges obtained?
USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD
25. Which system table contains information on constraints on all the tables created?
USER_CONSTRAINTS
26. TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ?
Both will result in deleting all the rows in the table EMP.
27. What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence
DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back.
WHERE clause can be used with DELETE and not with TRUNCATE.
28. What command is used to create a table by copying the structure of another table?
CREATE TABLE .. AS SELECT command
29. Which date function is used to find the difference between two dates?
MONTHS_BETWEEN
30. Why does the following command give a compilation error?
DROP TABLE &TABLE_NAME;
Variable names should start with an alphabet. Here the table name starts with an
'&' symbol.