ORACLE SQL PL/SQL Interview Questions- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -What are the various types of queries ? Answer: The types of queries are: Normal Queries Sub Queries Co- related queries Nested queries Compound queries - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -What is a transaction ? Answer: A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements. SQL> select * from dba. OR Can you use a DDL in a procedure ? How ? Answer: From PL/SQL V2.
DBMS. How ? Answer: Yes. You can pass parameters to procedures or functions in a package. Before and After Triggers. Row and Statement Triggers. What is the maximum no of cascading triggers at a time? Answer: When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 3. 2. Logical : Tables, Views, Tablespaces, etc.
How ? Answer: Yes, by adding datafiles to it. How ? Answer: No (for Oracle 7.
Yes (for Oracle 7. Resize clause ) - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -What is the use of Control files ? Answer: Contains pointers to locations of various data files, redo log files, etc. How ? Answer: Yes.
Oracle PL-SQL Interview Questions And Answers in pdf.visit for more Oracle PL-SQL Interview Questions And Answers to download in pdf format. Description: This page contains free download of Oracle PL-SQL Interview Questions And Answers in pdf format.
In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity. What is the difference between partly available and needs recovery ? Answer: The various states of a rollback segment are : ONLINE OFFLINE PARTLY AVAILABLE NEEDS RECOVERY INVALID. Will the rows be inserted ?
Welcome, here is Oracle sql plsql interview questions and answers pdf Free SQL Complex Queries, Sql Interview Question, SQL Server Queries,Queries In. These questions cover basic and advanced topics on Oracle. You can meet us at various conferences and user group events, and discuss technical issues with us or challenge the OakTable network with a technical question. If we can’t answer your question within 24 hours, you get a T-shirt that says, “I challenged the. Welcome, here is Oracle sql plsql interview questions and answers pdf Free SQL DBA Interview Questions & Answers / Migration strategy For SQL Server. A PL/SQL table is one dimensional, indexed, unbounded sparsed collection of homogeneous Data. Java language Interview Question Springs Interview Questions Joomla interview questions? Oracle PL / SQL Interview Question ASP.Net Interview Questions.
Answer: No. Use an expression in the Where Clause of the SQL. Reference key is the primary key of table referred by another table. Market Presence : Oracle is by far the largest RDBMS vendor and spends more on R & D than most of its competitors earn in total revenue. This market clout means that you are unlikely to be left in the lurch by Oracle and there are always lots of third party interfaces available.
Backup and Recovery : Oracle provides industrial strength support for on- line backup and recovery and good software fault tolerence to disk failure. You can also do point- in- time recovery. Performance : Speed of a 'tuned' Oracle Database and application is quite good, even with large databases. Oracle can manage > 1.
Can anyone forward me all Oracle SQL and PL/SQL Interview questions and answers asap. I cannot imagine all the existing question about. Prepare for SQL Server Interview with our collection of articles, videos and online tests dedicated to Interview Questions and Answers. This page is a good starting poin to find out what we have for interview preparations: Interview Tips Webinar First I would. Latest Answer: Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse SQL StatementA SQL statement is parsed only.
GB databases. Multiple database support : Oracle has a superior ability to manage multiple databases within the same transaction using a two- phase commit protocol. What is its use ? Answer: PL/SQL requires that you declare an identifier before using it. Therefore, you must declare a subprogram before calling it. This declaration at the start of a subprogram is called forward declaration.
A forward declaration consists of a subprogram specification terminated by a semicolon. The initial SGA was around 4. MB when the server RAM was 3. MB and The new SGA was around 1.
MB when the server RAM was increased to 1.