1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

 5 10218

Delete the emps whose salaries are lowest sals of their own dept.

 5 8832

Delete duplicate records in the emp table.

Oracle,

6 12989

What is magic table?

 6 22546

how to check the 3rd max salary from an employee table?

IBM,

23 29679

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

Oracle,

12 16144

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

iFlex,

8 27565

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 14881

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

iFlex,

8 14573

what are the advantages of package?

iFlex,

7 37722

in materialized view the structure will create immediately or not?

iFlex,

2 7951

How will we see framework of a table?

Accenture,

2 10497

write a query to delete similar records in same table

TCS,

13 21279

write a query to delete similar records in different tables with same structure

 4 7901

write a query to delete similar records in particular fields(columns) in different tables

TCS,

6 11824

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how to dump a table to a file with 'mysqldump'? : Sql dba

543

What are different methods to trace the pl/sql code?

532

Is grant a ddl statement?

449

How many types of literals are available in pl sql?

508

Are left and right joins the same?

525




Which normal form is best?

511

What is difference between sql and oracle?

554

what is a tablespace? : Sql dba

558

What is compute?

553

What is left join in sql?

573

What is a native sql query?

488

What is the use of sqldataadapter?

529

Is truncate ddl or dml?

538

Write a query to display the current date in sql?

505

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

609

For More Un-Answered { SQL PLSQL } Questions Click Here