Oracle PLSql Interview Questions & Answers
Oracle PLSql Interview Online Test
1. To see current user name
Show Answer
2. Change SQL prompt name
Show Answer
3. Switch to DOS prompt
Show Answer
4. Oracle cursor : Implicit & Explicit cursors
Show Answer
5. Explicit Cursor attributes
Show Answer
6. To view installed Oracle version information
Show Answer
7. Which date function returns number value?
Show Answer
8. Any three PL/SQL Exceptions?
Show Answer
9. What are PL/SQL Cursor Exceptions?
Show Answer
10. What are the more common pseudo-columns?
Show Answer
11. What is the output of SIGN function?
Show Answer
12. What is the maximum number of triggers, can apply to a single table?
Show Answer
13. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Show Answer
14. What operator performs pattern matching?
Show Answer
15. What operator tests column for the absence of data?
Show Answer
16. Which command executes the contents of a specified file?
Show Answer
17. What is the parameter substitution symbol used with INSERT INTO command?
Show Answer
18. Which command displays the SQL command in the SQL buffer, and then executes it?
Show Answer
19. What are the wildcards used for pattern matching?
Show Answer
20. State true or false. EXISTS, SOME, ANY are operators in SQL
Show Answer
21. State true or false. !=, <>, ^= all denote the same operation.
Show Answer
22. What are the privileges that can be granted on a table by a user to others?
Show Answer
23. What command is used to get back the privileges offered by the GRANT command?
Show Answer
24. Which system tables contain information on privileges granted and privileges obtained?
Show Answer
25. Which system table contains information on constraints on all the tables created?
Show Answer
26. TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ?
Show Answer
27. What is the difference between TRUNCATE and DELETE commands?
Show Answer
28. What command is used to create a table by copying the structure of another table?
Show Answer
29. Which date function is used to find the difference between two dates?
Show Answer
30. Why does the following command give a compilation error?
Show Answer
31. What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
Show Answer
32. What is the use of the DROP option in the ALTER TABLE command?
Show Answer
33. What is the use of DESC in SQL?
Show Answer
34. What is the use of CASCADE CONSTRAINTS?
Show Answer
35. Which function is used to find the largest integer less than or equal to a specific value?
Show Answer