Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

iFlex SQL PLSQL Interview Questions
Questions Answers Views Company eMail

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*/

2 4854

what is global table

7 11138

what is difference between procedure and function, procedure and trigger?

8 25512

Give an example of any procedure.

5 12896

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 12824





what are the advantages of package?

7 35800

in materialized view the structure will create immediately or not?

2 7004

can we create index on index?

7 11791

diff b/w function and procedure?

9 11331

diff b/w sub query and co-relater query?

3 8575

if we give update table_name set column_name= default. what will happen?

4 7055

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 8356

how will u find statistics of a database objects?

2 6241

How can we overcome recursive triggers in SQL?

1 7963

..........refers to the disk mirroring

2 2806

Post New iFlex SQL PLSQL Interview Questions




iFlex SQL PLSQL Interview Questions


Un-Answered Questions

m creating a web project in struts. when i deploys war file through myeclipse 8.x to web server tomcat6.x. first time this war file is deploy successfully bt when we change somthng in my jsp or anywhere in my project ...thn we need to deploy again so tht m gettng this erro. plzzz tell me where i was wrong?? war file is diployed successfully.....i mentioned it by ******* . and after tht m getng error...Undeploying context [/gfwrd] May 23, 2010 7:40:23 PM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_03\bin;C:\Program Files\Apache Software Foundation\Tomcat 6.0\bin May 23, 2010 7:40:23 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-7070 May 23, 2010 7:40:23 PM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 2947 ms May 23, 2010 7:40:24 PM org.apache.catalina.core.StandardService start INFO: Starting service Catalina May 23, 2010 7:40:24 PM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.16 May 23, 2010 7:40:27 PM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on http-7070 May 23, 2010 7:40:27 PM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 May 23, 2010 7:40:27 PM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/109 config=null May 23, 2010 7:40:27 PM org.apache.catalina.startup.Catalina start INFO: Server startup in 3824 ms ************************************************************ ******************* May 23, 2010 7:51:28 PM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive gfwrd.war ************************************************************ ******************** May 23, 2010 7:54:10 PM org.apache.catalina.startup.HostConfig checkResources INFO: Undeploying context [/gfwrd] May 23, 2010 7:54:10 PM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive gfwrd.war

2033


What do you mean by passive circuit elements and why these are called passive?

286


Explain what are the applications of an inverting amplifier?

267


What is meant by naive bayes classifier?

23


how can implement dropdownlist in particular of dataset when try to update?

2008






What is the advantage and disadvantage of cloud computing?

61


Difference between logical and physical address space?

256


How many ways we can configure hibernate?

12


Explain difference between chart field and chart of accounts?

164


What are the types of sensors?

243


How to compare two text files in unix?

252


What is property type c?

226


Mention what is the maximum size of the message does kafka server can receive?

132


Do you know what is application?

210


How to calculate fibonacci numbers in javascript?

230