3 days ago 1) What is PL SQL? PL SQL is a procedural language which has interactive SQL, as well as procedural programming language constructs like. Dear readers, these PL/SQL Interview Questions have been designed specially to get you they continue based on further discussion and what you answer. Oracle Interview Questions on PL/SQL - Table of Contents. Oracle PL/SQL Interview Questions. Oracle PL/SQL Interview Questions & Answers - 1 to Oracle.
|Language:||English, Spanish, Indonesian|
|Genre:||Academic & Education|
|Distribution:||Free* [*Registration needed]|
This article will discuss the top-most PL/SQL Interview Questions and answers. It helps the user to develop complex database applications. Frequently asked PL SQL Interview Questions with detailed answers and examples. Tips and Tricks for cracking PL SQL interview. Happy pl sql job hunting. Oracle Pl SQL Interview Questions and mtn-i.info - Free download as Word Doc .doc /.docx), PDF File .pdf), Text File .txt) or read online for free.
It is the reason, we are employing each row clause and internally stored DML transaction in trigger specification, these qualifiers :old, :new, are also called as records type variables. What is Mutating Trigger? Ans: Into a row level trigger based on a table trigger body cannot read data from same table and also we cannot perform DML operation on same table.
If we are trying this oracle server returns mutating error oracle table is mutating.
This error is called mutating error, and this trigger is called mutating trigger, and table is called mutating table. Mutating errors are not occurred in statement level trigger because through these statement level trigger when we are performing DML operations automatically data committed into the database, whereas in row level trigger when we are performing transaction data is not committed and also again we are reading this data from the same table then only mutating errors is occurred.
These are inserting, updating, deleting clauses.
These clauses are used in statement, row-level trigger. These triggers are also called as trigger predicate clauses. All locks acquired by transaction are released. It undoes all the work done by the user in a transaction. A cursor is implicit by default. The user cannot control or process the information in this cursor.
If a query returns multiple rows of data, the program defines an explicit cursor. This allows the application to process each row sequentially as the cursor returns it.
It occurs when a trigger tries to update a row that it is currently using. It is fixed by using views or temporary tables, so database selects one and updates the other. If it is used, it must come first in a stand alone file. A maximum of 12 triggers can be applied to one table. It is much more efficient as each statement is not individually stripped off. A triggering statement or event. A restriction An action 26 What are character functions?
Group functions give results based on groups of rows, as opposed to individual rows.
The number of rows that are updated, deleted or fetched. Checks if the cursor has fetched any row. It is True if rows are not fetched. Intersect is the product of two tables and it lists only matching rows. Sequences are used to generate sequence numbers without an overhead of locking.
Its drawback is that the sequence number is lost if the transaction is rolled back. Using the keyword "new. By using the keyword "old. It is a pseudo column.
USER is also a pseudo column but refers to current user logged onto the session. They are used to monitor changes happening in the table.
ROWID is the logical address of a row, it is not a physical column. It composes of data block number, file number and row number in the data block. Database links are created in order to form communication between various databases, or different environments like test, development and production. The database links are read-only to access other information as well. Fetching a cursor reads Result Set row by row. It is a binary file. ALIAS name can be given to any table or a column. For example- Select emp.
Result from employee emp, department as dept where emp. What are aggregate and scalar functions? Aggregate functions are used to evaluate mathematical calculation and returns a single value. These calculations are done from the columns in a table.
For example- max ,count are calculated with respect to numeric. Scalar functions return a single value based on the input value.
How can you fetch alternate records from a table? You can fetch alternate records i.
Name the operator which is used in the query for pattern matching? LIKE operator is used for pattern matching, and it can be used as -. How can you select unique records from a table?
How can you fetch first 5 characters of the string?