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 20910

What are the default Oracle triggers??

2 14048

What is the difference between DELETE and TRUNCATE?

15 15223

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

4 5870

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

2 5470





how do you count the duplicate records in a table

10 12508

how u can find the n row from a table?

19 17720

what is the difference between implicit and explicit trigger

2 16066

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

5 11206

What is mutating trigger?How to avoid it??

3 9979

what is the difference between cursor FETCH and FOR LOOP ?

3 20804

What is a mutating table

5 6734

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

2 7029

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 7734

Post New Tech Mahindra SQL PLSQL Interview Questions




Tech Mahindra SQL PLSQL Interview Questions





Un-Answered Questions

How to calculate WIP in "product cost by sales order scenario", where multiple production orders are raised against one sales order?

4315


What is Splunk?

5


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1189


If you were the successful candidate, how much notice would you require to give your current employer?

63


What is protected access modifier?

22






Do you have warehouses with stock of different plants?

7


What animals sleep the least?

1


what is the difference between nested subquery and correlated subquery?

20


What is the basic difference between pledge, hypothication and mortgage????

1177


Explain mdt?

9


hi frenz,its aswathy.i hve aplied for the hpcl test on feb,pls send the test patern & the placement papers as soon as possible. mail-id :kjaswathy@gmail.com

746


In Java coding we will write a public static void main()? Why won't we write as a static public void main()

1638


On what factors can you map the success of automation testing?

13


What all access modifiers are allowed for top class ?

46


Why teradata is used?

23