Showing posts with label Birlasoft. Show all posts
Showing posts with label Birlasoft. Show all posts
Sunday, September 25, 2016
Birlasoft Oracle SQL PL/SQL Interview Questions
What is the use of package
What is module overloading?
What are composite data types.
What is the use of record. Why we use record.
What is the difference b/w pl/sql record and pl/sql table.
What is collection?
Difference b/w nested tables and varrays.
What is isolation table?
What are dead locks.
What are shared locks and implicit locks.
How many types of cursors we use.
What is the ref cursor and how to send unlimited data to front end.
Syntax of sql *loader.
How to get the data from database to unix environment
How to control module over loading.
Subscribe to:
Posts (Atom)
Popular Posts
-
Experience Level - 3- 5 Years SQL Questions: Brief about your experience, skills and projects you worked on. 1.Differenfe betw...
-
Data Dictionary tables/Views contain information about the database and its objects. These are automatically created and maintained by oracl... -
E 1st round Queries on joins, group by , not in, rank , dense rank, decode, case. (for half an hour to write queries ,given different ta...
-
Select * from a where hiredate+60 < sysdate; (here hiredate is non-unique index, so query scanning index range or full table scanning. ...
-
Generate Sequence of Numbers from 1 to N using SQL Query SELECT LEVEL AS ID FROM DUAL CONNECT BY LEVEL <= 20; ... -
Stages of Processing SQL Statement: SQL statements pass through several stages during their processing: Parsing Binding Executing O...
-
Introduction Both LAG and LEAD functions have the same usage, as shown below. LAG (value_expression [,offset] [,default]) OVER ([quer... -
About Temporary Tables : Temporary tables are database tables that hold session specific data Each session can only see and modify its o... -
Parameter Modes in PLSQL procedures and functions are IN , OUT, IN OUT. The differences are as follows.
