Sunday, August 21, 2016
VirtusaPolaris - Oracle SQL and PLSQL interview questions
VirtusaPolaris - 2nd Round Oracle SQL and PLSQL interview questions
I have 100000 rows to be inserted into a table using insert script. At 900th row the record insertion failed. How will you handle this or make sure the entire script is not failed.
What is dml error logging.
I have two tables joined using joins. one of the table is accessed over the dblink. The query is deadly slow. What are the possible issues and How will you improve the performace.
I have a table with columns a,b,c . I need to derive value of the column c from a,b while insert and insert the rows into table without using triggers.
what are indexes. Types of indexes.
what are the advantages of partitioned tables. explain partitioned indexs
i have a report which is running very slow today, but was fine yersterday. What is your approach. what is the first thing that you will check.
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.
