IBM SQL PLSQL Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

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

IBM SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 3647

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 19620

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 11245

what is the Default Libraries for Oracle Report 6i

2230

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 8719

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 12583

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 10300

what is Difference between Having and Where clause?

5 10790

select top 3 sal from each dept?

17 27086

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 9928

What are Global Temporary tables

3 10854

What are Anti joins

1 10261

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 10175

How to call the function and Procedure in trigger?

3 11443

What is the difference between SQL and PLSQL

7 10940

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

What is jmeter?

591

Who governs RRBs?

1043

I am using 11.5.10.2 vision database for practicing HRMS modules , can you tell me for payroll processing what patches are required to run the payroll and what patches are required to open the external site visitor page in iRecruitment? Thanks in advance

3018

what is the difference between truncate and delete statement? : Transact sql

1027

What is Hcm Master Data In Sap?

998

What is the difference between constitutional dictatorship and democracy?

What is the ask_pass module in ansible?

pls send me the syllabus questions on rrb section engineer (telecom)

2470

What is a conditional formula?

539

what are the differences of software life cycle models

2540

What is difference between windows server and windows os?

341

Why do we need custom directives in angular?

709

What are the different views of slides in ms powerpoint?

461

What are the oracle built-in data types?

1024

What is a minimum spanning tree?

1012