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 21140

What are the default Oracle triggers??

2 14213

What is the difference between DELETE and TRUNCATE?

15 15467

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

4 5939

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

2 5531





how do you count the duplicate records in a table

10 12715

how u can find the n row from a table?

19 17981

what is the difference between implicit and explicit trigger

2 16263

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

5 11338

What is mutating trigger?How to avoid it??

3 10090

what is the difference between cursor FETCH and FOR LOOP ?

3 20988

What is a mutating table

5 6812

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

2 7088

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 7830

Post New Tech Mahindra SQL PLSQL Interview Questions




Tech Mahindra SQL PLSQL Interview Questions





Un-Answered Questions

How do I insert a formula in visio?

3


What is Sqoop Import Mainframe Tool and its Purpose?

1


Explain react hooks?

9


Is there an ide for javascript?

16


Why does The speed of motor used in elevator remain constant irrespective of load??

1210






Is it necessary to register a controller command in cmdreg table?

33


Do black holes exist in reality?

18


What is query execution plan in sql?

14


Explain what is the significance of ctr and how do you calculate it?

13


What is the latest generation of circuit breakers called?

15183


how do you handle failures? Provide examples.

58


Explain reverse a linked list recursive java solution?

47


what are views in Hive?

57


How do you check if a file is corrupted windows 10?

11


Write the basic steps to execute linq query.

1