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 2960

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 15064

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 9975

what is the Default Libraries for Oracle Report 6i

1833

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

2 7807

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 11134

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 9137

what is Difference between Having and Where clause?

5 9255

select top 3 sal from each dept?

17 22829

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

3 8598

What are Global Temporary tables

3 9601

What are Anti joins

1 9020

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

3 8995

How to call the function and Procedure in trigger?

3 10294

What is the difference between SQL and PLSQL

4 8591

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1713


What is a hash on the blockchain?

1


Explain the importance of species of the molds Ustilago and Claviceps in medicine.

1505


How can we create tensors from python objects?

5


Explain dialog work processes.

303






Looking for good Oracle Fusion HCM training institute in HYDERABAD.. classroom training not online training

2083


explain about yourself with your streangth and weakness. and also tell me why do you want to do mba?

1543


How to fight Inflation and what is the current Indian scenario about Inflation?

623


How to declare an initialization block in kotlin class?

195


How do I reinstall wordpress?

90


How to apply css to iframe?

268


How many co.codes can you assign to a personnel area? How many pers. Areas can be assigned to a company code? Explain.

537


How do I make a frame with a vertical scrollbar but without a horizontal scrollbar?

445


How do I install sql?

517


What is 'i-net'?

685