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 21352

What are the default Oracle triggers??

2 14300

What is the difference between DELETE and TRUNCATE?

15 15694

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

4 6005

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

2 5586





how do you count the duplicate records in a table

10 12941

how u can find the n row from a table?

19 18242

what is the difference between implicit and explicit trigger

2 16499

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

5 11443

What is mutating trigger?How to avoid it??

3 10198

what is the difference between cursor FETCH and FOR LOOP ?

3 21168

What is a mutating table

5 6913

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

2 7138

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 8000

Post New Tech Mahindra SQL PLSQL Interview Questions




Tech Mahindra SQL PLSQL Interview Questions





Un-Answered Questions

Do you have experience using a customer relationship management program? : insurance sales

35


I know that in version ECC6 exists the functionality of document splitting like this: If an Invoice is for 11,000/-.Then we write the GL as : vendor A/C Dr XXXX to Purchase 1 XXX to Purchase 2 XXX to Tax XX But through Document Splitting we can write it based on the %age of sharing as 80 : 20%.. Vendor A/c 8,800(DR) Purchase A/C 8,000(Cr) Tax 800 (Cr) Vendor A/C 2,200 (Dr) Purchase 2000(Cr) Tax 200(Cr) This is called Document Splitting But when you talk about tax, you mean a line item created manually like tax or a document where you complete the tax code and the line is created automatically? Thanks a lot in advance. REgards,Lorena

1137


What is Sqoop?

1


Assuming that you are selected, what will be your strategy for next 60 days

131


What is empty tag?

80






What is conditional formatting excel?

1


How do I view a jsp file?

34


What are filtered views?

3


How to Execute a Package in PL/SQL.?

99


What is difference between web api and web services?

73


What do you mean by context initialization parameters?

67


Can you use Spark to access and analyse data stored in Cassandra databases?

27


Where is autoshape in word?

12


Explain briefly different instance modes in wcf?

47


How do I combine multiple workbooks into one?

13