ALLInterview.com :: Home Page KalAajKal.com
 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  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what is the difrence between sql and pl/sql
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difrence between sql and pl/sql
Answer
# 1
In pl/sql there is three letter extra "pl/" but it was not
in sql
 
Is This Answer Correct ?    0 Yes 18 No
Karthik Krishnan
 
  Re: what is the difrence between sql and pl/sql
Answer
# 2
No.The above is not a correct one.
The appropriate answer is there is only 2 letters 
extra "pl" and one special charcter "/" extra.
 
Is This Answer Correct ?    1 Yes 17 No
Sudhakar Shanmugam
 
 
 
  Re: what is the difrence between sql and pl/sql
Answer
# 3
Usually we will used to mention pl/sql, so there are three
characters differing. And considering the special character
is mandatory.
 
Is This Answer Correct ?    1 Yes 10 No
Karthik Krishnan
 
  Re: what is the difrence between sql and pl/sql
Answer
# 4
Similarly i have many answers for the critical and vertical
questions.
Even you can reach me by mail-id.
karthik.krishnagiri@gmail.com
 
Is This Answer Correct ?    0 Yes 5 No
Karthik Krishnan
 
  Re: what is the difrence between sql and pl/sql
Answer
# 5
I donot know about the people posting answer here with 
correct sense or not. Beacuse many of candidate use this 
forum as reference. This kind of answers will mis guide 
them.
 
Is This Answer Correct ?    5 Yes 1 No
Rsr
 
  Re: what is the difrence between sql and pl/sql
Answer
# 6
Actually,

All those above answers are wrong..Because the question is 
itself wrong as it has a spelling mistake for "difference" 
and its displayed as "difrence".People like me only can 
find this error(Bug) as because i wear Specs.

For more exact answers please contact : aar.sundar@gmail.com
 
Is This Answer Correct ?    1 Yes 2 No
Rsr
 
  Re: what is the difrence between sql and pl/sql
Answer
# 7
Hello!!

If you people dont know the answer please atleast learn 
from my post. 

Ans : The main diffrence is ,SQL is only for team members 
but when the project lead uses it,then its named as 
ProjectLead SQL (shortly pl/sql)

So i think you people understood my technical knowledge, So 
for any answers contact me(Incoming free).
 
Is This Answer Correct ?    0 Yes 5 No
Mr.kiruba Sankar
 
  Re: what is the difrence between sql and pl/sql
Answer
# 8
Thanks for the reply and suggestions
But people Please dont talk jargunds.
Can someone comeup with an explanation understandable to a 
lay man.
Thanks in advance!!!
 
Is This Answer Correct ?    2 Yes 1 No
Sandhya
 
  Re: what is the difrence between sql and pl/sql
Answer
# 9
SQL is the strutctured query language but pl/sql is the
procedural language sql.difference is in pl/sql we can work
with data in the form by writing program which has
predefined structure. but sql does not have.
 
Is This Answer Correct ?    10 Yes 0 No
M.balarami Reddy
 
  Re: what is the difrence between sql and pl/sql
Answer
# 10
Differce B/W Pl/sql & sql is that pl/sql is used gor 
Logical databese Creation. it is used in backend . It is 
used for Programming.

sql is Used for front end & Used for Physical data base 
creation maintain tabes & rows.
 
Is This Answer Correct ?    1 Yes 3 No
Mayank Singh
 
  Re: what is the difrence between sql and pl/sql
Answer
# 11
Sql is structured query language and pl/sql is programing 
langugae that means you can use procedure ,function and 
other. in pl/sql you can store procedure and function in 
database and later these can be used.
 
Is This Answer Correct ?    1 Yes 1 No
Rahul
 
  Re: what is the difrence between sql and pl/sql
Answer
# 12
SQL is a data oriented language for selecting and
manipulating sets of data. PL/SQL is a procedural language
to create applications. You don't normally have a "SQL
application". You normally have an application that uses SQL
and a relational database on the back-end. PL/SQL can be the
application language just like Java or PHP can. SQL may be
the source of data for your screens, web pages and reports.
PL/SQL might be the language you use to build, format and
display those screens, web pages and reports.

Think of it like this: The code that makes your program
function is PL/SQL. The code that manipulates the data is
SQL DML. The code that creates stored database objects is
SQL DDL. DDL compiles the code that is written in PL/SQL.
PL/SQL may call SQL to perform data manipulation. The
commands that format the output of a tool are not related to
the SQL standard or to PL/SQL.
 
Is This Answer Correct ?    1 Yes 0 No
Antu
 
  Re: what is the difrence between sql and pl/sql
Answer
# 13
sql -> structure query language.
pl/sql -> procedure language in structure query language.
this is the main difference..
 
Is This Answer Correct ?    0 Yes 0 No
Anuj Maheshwari
 
  Re: what is the difrence between sql and pl/sql
Answer
# 14
SQL is a structured query language.
Actually SQL is a set of rules defined by mr.Codd.
Any database like oracle,derby or sybase has to follow 
these rules.We can say that database following maximum 
codd's rule(there are 12 rules) is better than other like 
oracle follows 11 rule so it is better than other.

there are different categories in SQL
MySql-->supports triggers and cursors
Pl/Sql-->supports procedures.
Tl/Sql-->supports transactions.
MSSql-->it is microsoft version of SQL.
 
Is This Answer Correct ?    1 Yes 0 No
Tushar Matere
 
  Re: what is the difrence between sql and pl/sql
Answer
# 15
SQL is structured query language which is used to retrive 
data from the database. Before 1974 it is known as Gupta 
SQL. In 1974 Relational solutions Inc(Now oracle 
corporation) taken it as a native lang to retrive data. 
Though it is structured quer language it is un structured 
its like simple english language. 

   Pl/Sql is an extension for Sql. It is a structured 4th 
generation language where one can execute more than one 
select statement with conditional constructs like if, then 
and else.
 
Is This Answer Correct ?    1 Yes 0 No
Kalyana Chakravarthy
 
  Re: what is the difrence between sql and pl/sql
Answer
# 16
SQL Enter, Edit, Store & Retrieve by single command or 
statement where as PL/SQL process all SQL statements one at 
a time. With PL/SQL, an entire block of statements process 
in a single command line. 

SQL in a strucutred query language; where pl/sql is 
procedures,function,variable,method all are present
 
Is This Answer Correct ?    0 Yes 0 No
Tonmoy Bhattacharya
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
Explain the difference between mysql and mysqli interfaces in PHP?  3
What is SERIAL data type in MySQL?  2
How can we change the name and data type of a column of a table?  3
Give the syntax of Grant and Revoke commands?  1
How many services is running in sql server? ACC3
What is the difference between GROUP BY and ORDER BY in Sql? Renault-Nissan2
How do you change a password for an existing user via mysqladmin?  1
What is the difference between mysql_fetch_array and mysql_fetch_object?  2
What?s the difference between query_cache_type 1 and 2?  1
Explain MySQL architecture?  1
How to load data from a text file into a table? Sasaa3
How can we change the name of a column of a table?  2
How do you convert to a different table type?  1
Explain federated tables?  2
How do you start MySQL on Linux?  3
How do you prevent MySQL from caching a query?  1
How can you do the fine tunning? ACC2
Can you save your connection settings to a conf file?  1
What happens if a table has one column defined as TIMESTAMP?  1
How do you index just the first four bytes of the column?  2
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com