Describe the Index, Types of index, At what situation we have used? Which one s better than others?1 1967
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 7511 11370
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 8152
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?2 6486
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 9280
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 7350
what is Difference between Having and Where clause?5 7544
select top 3 sal from each dept?17 17853
What are Nested Tables? How will u delete 5 rows from Nested Tables3 7160
What are Global Temporary tables3 7938
What are Anti joins1 7964
why we go for package? what are the advantages of using instead of seperate procuderes or functions3 7308
How to call the function and Procedure in trigger?3 8921
What is the difference between SQL and PLSQL4 7089
Explain Higher-Order Functions?
What are the tools for process improvement?
Is this artificial intelligence lives over the other software programs and their flexibility?
What do you know about Log Viewer?
What are different types of cable?
What is cakephp tutorial?
Why dint delete the index.bat file in system?
Does spark require hdfs?
Consider a fixed subnet partition of a class B network number that will accommodate at least 76 networks. How many hosts can be on each network? Also mention how you calculated that.
What functions can a view be used to performed?
Explain with the help of an example the usage of a parent-child selector.
How can you bypass sanitation in angular and why would you do so?
What is blob and clob?
Explain about rpa testing?
How do you define social class?