Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                       Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories  >>  Software  >>  Databases  >>  SQL PLSQL        Suggest New Category      Question  Asked @ Answers Views     select   how to find the second highest salary from emp table? Wipro   40  16069 How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar  3  1194 scope of exception handling in plsql Wipro  3  1525 What is the usage of NVL? Infosys   6  2829 What is pragma exception and how, when, where us  4  2415 I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible  7  1207 how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00  2  1093 Differences between UNIQUE and DISTINCT in select statements Verinon-Technology-Solutions   16  19594 how will u find statistics of a database objects? iFlex   1  1841 if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen? iFlex  5  1525 if we give update table_name set column_name= default. what will happen? iFlex  3  1527 How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ? IBM  9  2602 Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!? eBay  3  2245 which will fire first ? Trigger or Constraint IBM   12  4412 if i perform any operation on views such as insert, delete etc will my base table get affected?????  3  1239 E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question   Prev    1   ... 4    8   [9]    10  ... 13   ... 16   ... 19   ... 22   ... 25   ... 28   ... 31    Next         Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions     MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions     DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions     SQL PLSQL Interview Questions     Databases AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   What action do you have to perform before retrieving data from the next result set of a stored procedure ? 178 Microsoft What are wait events. Describe the wait event tables. 12 CTS write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/ 601 iFlex after tell procedure whole code he asked can i write the same way in a function 136   how many tupples can insert in 1 second in sql 70   what is the bond code in materialized view? 161   If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000???? 237   what is indexing, searching and user interface? 96 HCL when MSQL8.0 is in market 124   oracle is compiler or interpretter,can any one tell me the answer? 1484 Satyam Authentication mechanisms in Sql Server ? 198 BirlaSoft How consistent is the view of the data between and within multiple sessions, transactions or statements ? 95   what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table... 100 Satyam What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name. 212 TCS Does it possible to pass object (or) table as an argument to a remote procedure? 504 TCS What are code pages ? 116 BirlaSoft I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u. 5   GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 229 Virtusa what is the boundary line in varrays? 119   C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September. 219   E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com