|Hypertext Markup LanguageCascading Style SheetsExtensible Markup LanguageJava ScriptjQueryAngularJSOracle SQLOracle PL/SQLOracle D2K FormsOracle D2K ReportsOracle DatabaseJavaJava Database ConnectivityJava ServletJava Server PagesHibernateApache TomcatCC++PHPMy-SqlUnix/LinuxMS-DOSHR Interviews|
|What is a package spec and package body? Why the separation?|
Spec declares public constructs. Body defines public constructs, additionally declares and defines Private constructs.
|What is the difference between anonymous blocks and stored procedures?|
Anonymous block is PL/SQL code and compiled only when called.
|Can you use COMMIT in a trigger?|
|Yes but by defining an autonomous transaction.|
|What is an autonomous transaction?|
|An autonomous transaction is an independent transaction that is initiated by another transaction (the parent transaction). An autonomous transaction can modify data and commit or rollback independent of the state of the parent transaction.|
|What is the difference between implicit and explicit cursors?|
|An explicit cursor is declared opened and fetched from in the program block where as an implicit cursor is automatically generated for SQL statements.|
|What are the cursor attributes used in PL/SQL?|
% ISOPEN – Used to check whether a cursor is open or not.
|What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?|
% TYPE provides the data type of a variable or a database column to that variable.
|What are the datatypes a available in PL/SQL?|
|Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.|
|What are the components of a PL/SQL Block?|
|What is a stored procedure ?|
|A stored procedure is a sequence of statements that perform specific task. A stored procedure is a named pl/sql block which performs an action.It is stored in the database as a schema object and can be repeatedly executed.It can be invoked, parameterised and nested.|
|What is a cursor ? Why Cursor is required?|
|Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.|
|What are advantages of Stored Procedures?|
Extensibility,Modularity, Reusability, Maintainability and one time compilation.
|How can a function retun more than one value in oracle with proper example?|
|Basically as per property of function it has to return one value. So the other values can be returned from the out parameter of the function. But its advised if you want more that one return value go for procedure however function will also yield the same result.|
|What is a cursor for loop ?|
Cursor for loop implicitly declares %ROWTYPE as loop index,opens a cursor, fetches rows of values from active set into fields in the record and closes when all the records have been processed.
FOR emp_rec IN C1 LOOP salary_total := salary_total +emp_rec sal; END LOOP;
|Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?|
|It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing. yes WE can use COMMIT and ROLLBACK triggers, but by using PRAGAMA AUTONAMOUS_TRANSATIONS. Now the transation treated as a autonomous tansation.|
|What is a database trigger ? Name some usages of database trigger ?|
Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.
|General Knowledge of India|
How many coastal state are in India?
A person is to count 4500 currency notes. Let an denote the number of notes he counts in the nth minute. If a1 = a2 = .... = a10 = 150 and a10 , a11 ,... are in an AP with common difference – 2, then the time taken by him to count all notes is ?
The value of product 6 1/2 * 6 1/4 * 6 1/8 * 6 1/16 * -----∞ upto infinite terms?
What is nohup command in unix?
How do display the 10th, 11th and 12th line of a file in Unix?
The mean of 100 students marks was found to be 40. it was found later that a mark 53 was read as 83. the correct mean is?
The geometric mean of three observations 40, 50 and X is 10, then the value of X is ?
Who appoints the members of National human rights commission?
The President of India can resign by writing under his hand addressed to?
Under which article of the constitution of India can the President of India refer a matter to the Supreme Court for its opinion?
|General Computer Knowledge|
The term VPN stands for ?
The transmission control protocol(TCP) is a............ layer protocol ?
What is the difference between Procedure and Function?
Define exception and How will you raise an exception in PL/SQL procedure?
What is the advantage of using packages for storing PL/SQL objects?
|Fill in the blank|
I ________ station before the train arrived.
If I ______ a king, I would help everyone.
Radha___________her daughter for an hour.
Institute of Banking Personnel Selection (IBPS) - CRP SPL-IX - 1163 Posts - 26/11/2019 Last date
Reserve Bank of India (RBI) - 199 Posts - 11/10/2019 Last date
Life Insurance Corporation of India (LIC) - 7942 Posts - 01/10/2019 Last date
State Bank of India (SBI) - CRPD/APPR - 700 Posts - 06/10/2019 Last date
|Jobs in Jharkhand|
Jharkhand Staff Selection Commission (JSSC) -JANMCE - 1985 Posts - 04/10/2019 Last date
|Jobs in Madhya Pradesh|
National Health Mission (NHM) - 1392 Posts - 05/10/2019 Last date
|Jobs in Bihar|
Bihar Vidhan Parishad - 136 Posts - 11/10/2019 Last date
NABARD - 91 Posts - 02/10/2019 Last date
Institute of Banking Personnel Selection (IBPS) - CRP Clerks-IX - 12075 Posts - 09/10/2019 Last date
Haryana State Cooperative Apex Bank Ltd - 978 Posts - 31/08/2019 Last date