| Other SQL PLSQL Interview Questions |
|| Asked @
|How to count the no of records of a table without using
|Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
|what is self join and how it works??
|If you want a column to be part of the result set, after
which SQL keyword does it belong?
4. GROUP BY
|what is the difference between trigger and storedprocedures
|What will happen after commit statement ?
|What is the difference between SQL Constraint and PL/SQL
constraint.Pls give all the constraint name.
|What is the Subquery?
|How can we Get the Updated Rows? ie, There is 100s of Rows i
updated the Rows who have salary 5000. then i want to select
the Updated Rows. How can we achieve it?
|What is a cursor for loop ?
|1 SELECT a.field1, b.field2, c.field3, d.field4
2 FROM atable a, atable b, ctable c, dtable d
4 ORDER BY 1
What is the minimum number of joins that must be specified
on line 3 in the sample code above to properly link the
tables? Notice that the table "atable" is aliased twice:
once as "a" and once as "b."
1. One join
2. Two joins
3. Three joins
4. Four joins
5. Five joins
|Fetch an entire row from the employees table for a specific
|For more SQL PLSQL Interview Questions Click Here |