What is CrazyEngico.com (CE)?

CrazyEngico (CE) is a one-stop solution for interview questions and answers, domain knowledge, e-learning, tutorials, articles and many more learning material.
e-learning - Intelligent e-learning tutorials and articles
Domain Knowledge Learn about various business domains/verticals such as Banking, Financial, Insurance, Healthcare and many more...
Interview Questions and Answers - Post your questions and answers. 1000+ database of ready questions and answers available to prepare for an interview.
Tutorials - 300+ video tutorials from beginner to expert level.
Articles - 300+ technical articles to understand concepts.
Forum - A technical forum to post your queries/responses.

Search Questions

Post Your Question
Interview Questions/Answers

Oracle Q & A

Total Oracle questions: 88

Q 1) What are the various types of queries?
Q 2) What is a transaction?
Q 3) What is implicit cursor and how is it used by Oracle?
Q 4) Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages?
Q 5) What is PL/SQL?
Q 6) Is there a PL/SQL Engine in SQL*Plus?
Q 7) Is there a limit on the size of a PL/SQL block?
Q 8) Can one read/write files from PL/SQL?
Q 9) How can I protect my PL/SQL source code?
Q 10) Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure? How?
Q 11) What are the various types of Exceptions?
Q 12) Can we define exceptions twice in same block?
Q 13) What is the difference between a procedure and a function?
Q 14) Can you have two functions with the same name in a PL/SQL block?
Q 15) Can you have two stored functions with the same name?
Q 16) Can you call a stored function in the constraint of a table?
Q 17) What are the various types of parameter modes in a procedure?
Q 18) What is Over Loading and what are its restrictions?
Q 19) Can functions be overloaded?
Q 20) Can 2 functions have same name & input parameters but differ only by return datatype?
Q 21) What are the constructs of a procedure, function or a package?
Q 22) Why Create or Replace and not Drop and recreate procedures?
Q 23) Can you pass parameters in packages? How?
Q 24) What are the parts of a database trigger?
Q 25) What are the various types of database triggers?
Q 26) What is the advantage of a stored procedure over a database trigger?
Q 27) What is the maximum no.of statements that can be specified in a trigger statement?
Q 28) Can views be specified in a trigger statement?
Q 29) What are the values of :new and :old in Insert/Delete/Update Triggers?
Q 30) What are cascading triggers? What is the maximum no of cascading triggers at a time?
Q 31) What are mutating triggers?
Q 32) What are constraining triggers?
Q 33) Describe Oracle database's physical and logical structure?
Q 34) Can you increase the size of a tablespace? How?
Q 35) Can you increase the size of datafiles? How?
Q 36) What is the use of Control files?
Q 37) What is the use of Data Dictionary?
Q 38) What are the advantages of clusters?
Q 39) What are the disadvantages of clusters?
Q 40) Can Long/Long RAW be clustered?
Q 41) Can null keys be entered in cluster index, normal index?
Q 42) Can Check constraint be used for self referential integrity? How?
Q 43) What are the min.extents allocated to a rollback extent?
Q 44) What are the states of a rollback segment? What is the difference between partly available and needs recovery?
Q 45) What is the difference between unique key and primary key?
Q 46) An insert statement followed by a create table statement followed by rollback? Will the rows be inserted?
Q 47) Can you define multiple savepoints?
Q 48) Can you Rollback to any savepoint?
Q 49) What is the maximum no.of columns a table can have?
Q 50) What is the significance of the & and && operators in PL SQL?
Q 51) Can you pass a parameter to a cursor?
Q 52) What are the various types of RollBack Segments?
Q 53) Can you use %RowCount as a parameter to a cursor?
Q 54) Which symbol preceeds the path to the table in the remote database?
Q 55) Are views automatically updated when base tables are updated?
Q 56) Can a trigger written for a view?
Q 57) If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record?
Q 58) A table has the following data : [[5, Null, 10]].What will the average function return?
Q 59) Is Sysdate a system variable or a system function?
Q 60) What is Multi Threaded Server (MTA)?
Q 61) Which are initial RDBMS, Hierarchical & N/w database?
Q 62) Difference between Oracle 6 and Oracle 7.
Q 63) What is Functional Dependency?
Q 64) What is Auditing?
Q 65) While designing in client/server what are the 2 imp.things to be considered?
Q 66) What are the disadvantages of SQL?
Q 67) When to create indexes?
Q 68) How can you avoid indexes?
Q 69) Can database trigger written on synonym of a table and if it can be then what would be the effect if original table is accessed.
Q 70) Can you alter synonym of view or view?
Q 71) Can you create index on view?
Q 72) What is the difference between a view and a synonym?
Q 73) What's the length of SQL integer?
Q 74) What is the difference between foreign key and reference key?
Q 75) Can dual table be deleted, dropped or altered or updated or inserted?
Q 76) If content of dual is updated to some value computation takes place or not?
Q 77) If any other table same as dual is created would it act similar to dual?
Q 78) For which relational operators in where clause, index is not used?
Q 79) Assume that there are multiple databases running on one machine. How can you switch from one to another?
Q 80) What are the advantages of Oracle?
Q 81) What is a forward declaration? What is its use?
Q 82) What are actual and formal parameters?
Q 83) What are the types of Notation?
Q 84) If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure?
Q 85) What are various types of joins?
Q 86) What is a package cursor?
Q 87) If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted?
Q 88) what is the query to display maximum value in a row?a table contains 3 columns a b c10 60 20the ans should b 60.

Post your question
By clicking on Submit button you agree to the Terms of Service agreement.

Display Name:  
Select Category:  
Post Your Question:  

Copyright © 2017 CrazyEngico.com. All rights reserved.
CrazyEngico.com is not responsible for the content and CrazyEngico.com does not evaluate or guarantee the accuracy of any CrazyEngico.com content.
Please read our terms of service agreement before using this site.