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




Tech Mahindra SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the difference between trigger and storedprocedures

16 20612

What are the default Oracle triggers??

2 13860

What is the difference between DELETE and TRUNCATE?

15 14889

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 5772

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 5373





how do you count the duplicate records in a table

10 12181

how u can find the n row from a table?

19 17305

what is the difference between implicit and explicit trigger

2 15712

can we delete the trigger in a view? if yes why if not why?

5 11061

What is mutating trigger?How to avoid it??

3 9850

what is the difference between cursor FETCH and FOR LOOP ?

3 20533

What is a mutating table

4 6537

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 6937

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 7556

Post New Tech Mahindra SQL PLSQL Interview Questions




Tech Mahindra SQL PLSQL Interview Questions





Un-Answered Questions

What are events in C#?

14


what is span of shares

815


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1231


Can a view be mutating? If yes, then how?

1


What is one of the problems with project management software? A. The project manager manages the software instead of the project B. Project duration calculations are sometimes approximate. C. You cannot override the project management software decisions regarding schedules. D. It’s expensive and difficult to use.

9






Explain about RSA algorithm? How secure is this algorithm?

5


I am going to add images into a tag. How will it resize itself in adobe flex actionscript?

1


why not null is not allowed at table level

1660


If specific gravity of cement is less than 3.15 what is the cause?

1030


full form of flry b

2459


What is null queue?

1


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

948


Can we migrate code from Java to Kotlin?

3


How often DataNode send heartbeat to NameNode in Hadoop?

1


please send me previous year questions of jspl through which i could prepare myself for the test.

751