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 aptitute test questions (17)
  • Tech Mahindra interview questions (468)
  • Tech Mahindra placement papers (14)
  • Tech Mahindra technical test questions (33)



Tech Mahindra SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the difference between trigger and storedprocedures

16 18793

What are the default Oracle triggers??

2 12304

What is the difference between DELETE and TRUNCATE?

15 13242

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

4 5007

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

2 4694

how do you count the duplicate records in a table

9 10604

how u can find the n row from a table?

19 15583

what is the difference between implicit and explicit trigger

2 13439

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

5 9796

What is mutating trigger?How to avoid it??

3 8990

what is the difference between cursor FETCH and FOR LOOP ?

3 17920

What is a mutating table

4 5699

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

2 6017

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 6056

Post New Tech Mahindra SQL PLSQL Interview Questions




Un-Answered Questions

What is Alpha & Beta fctors related to Orifice Plate & its relation with flow?

1975


what happens in the short circuited secondary transformer,if the resistance of the short circuit is increased gradually?

967


Please any one help me I preparing for the post of charge man in Indian ordinance factory please give me some guide line & book for this exam.my email. anoopkpandey16@gmail.com

1935


WHERE WE CAN USE VAT 5%,14.5%

1173


Why do you want to join Virtual Command Centre (Work Force Management)

2133


Someone wants to send a small quantity, say about 500 Kgs., of green coffee beans from Koraput Orissa to Bangalore for Roasting and Packaging of the same there. There will be a loss in weight of about 20% during the processing the green coffee beans into coffee powder, which will then be fit for human consumption. Now, after processing the green coffee beans at Bangalore, the person wants to sell simultaneously a part of the Roasted Coffee Powder to four persons; one of them is in Chandigarh (a registered Dealer in Punjab) and the other is in Mumbai (possibly he is a an individual and not a registered dealer), third one is a registered dealer in Bangalore and the last one is an individual consumer just like you and me, and is not a registered dealer and stays in Mysore. The person wishes to bring the rest of the packed Roasted Coffee Powder back to Koraput, Odisha. The planter is a registered dealer under VAT in Odisha and has produced (manufactured) the coffee beans in his own gardens, and has applied for a CST Number but is yet to obtain the Number. We want to know: As to whether he can send the coffee beans to Bangalore for roasting without obtaining a CST Number beforehand. Or as to whether it is mandatory for him to get the CST registration first, before sending the Coffee beans to outside the state; As to how the person can generate the Way Bills from here and to send these to the transport carriers, for his sales to Chandigarh, Mumbai, Bangalore and Mysore. Tell me as to how he can do the necessary paper works and as to how he can pay the tax collected thus, As to how he can bring the rest of the roasted coffee powder back to Koraput that he can sell afterwards in the state and outside; He shall be sending samples of the Roasted coffee to Philippines and elsewhere, from Bangalore itself. May be in a subsequent times he might export, for which he has to send the roasted coffee powder to Mumbai; If the person wants to send the parchment coffee to Kushal Nagar in Karnataka to do the Curing Pre-Roasting) there, as to how he can send the processed coffee to the Roster at Bangalore. During Curing there is a loss of weight of about 20% too. Until the roasting is done, there will be no transfer of ownership, at any point of time, in between.

823


what is aom and how to add object repository? i am very new to QTP please help me

629


hi i got i 20 from sacred heart university u.s.a.i got good tofel score and my gre is score is very poor.my university requirement is only tofel.i completed my b.pharmacy in 2009 so i got 1 year gap is their chances to reject visa?what i have to do i was very tensed.how to sought out my problem

1044


I have an S Corporation called Trend Foods Inc. I would like to make a division of that company that services computers and call that Trend Computer Service. I do not want to set up another Corporation for Trend Computer Service. Can I just make a division of Trend Foods and what paperwork do I need to fill out to make that happen? Thanks for the help, Jim

749


Can any one give an example (Source Code) on virtual function implemetation in Java?

580


In Residential home construct footing,beam, column,lintel,rcc roofs which dia rod used how to self assumed

1698


1. What is maximum permissible distance between smoke detectors ? 2. How do we decide number of smoke detectors required in a large office, warehouse, hall etc ? 3. What should be maximum height of smoke detectors ? 4. Where do we use heat detector, optical smoke detector, temperature sensitive detector ?

1135


hi what is the difference between sap apo technical and functional?

2133


what are the different types of codes in thread in windows os?

1993


How many cylonders are there in 2stroke diesel engine?

647




Tech Mahindra SQL PLSQL Interview Questions
  • C (17)
  • OOPS (5)
  • C++ General (2)
  • MFC (1)
  • VC++ AllOther (1)
  • PHP (1)
  • Programming Languages AllOther (3)
  • VB Script (1)
  • JSP (1)
  • Shell Script (3)
  • Protocols AllOther (2)
  • Visual Basic (1)
  • C Sharp (7)
  • ASP.NET (11)
  • COM+ (2)
  • Dot Net Framework (1)
  • Dot Net Remoting (2)
  • Dot Net General (1)
  • Exchange Server (1)
  • WCF (1)
  • Database Management (2)
  • Forms Reports (1)
  • SQL Server (2)
  • MySQL (1)
  • DB Administration (1)
  • SQL PLSQL (14)
  • Windows AllOther (2)
  • Linux Commands (4)
  • Linux AllOther (2)
  • Unix Commands (1)
  • Solaris Commands (5)
  • Solaris General (2)
  • Solaris AllOther (5)
  • RTOS AllOther (1)
  • Load Runner (2)
  • QTP (16)
  • Selenium (1)
  • Automation Testing AllOther (1)
  • Manual Testing (34)
  • QA Concepts (2)
  • Test Cases (1)
  • Test Documents Reporting (1)
  • Testing AllOther (1)
  • Servers AllOther (1)
  • COBOL (3)
  • JCL (5)
  • DB2 (6)
  • IDMS (1)
  • Natural (3)
  • Assembler (3)
  • VSAM (5)
  • IBM MainFrame AllOther (4)
  • RPG400 (1)
  • COOLPLEX (1)
  • IBM AS400 AllOther (1)
  • Core Java (25)
  • Advanced Java (1)
  • EJB (5)
  • Servlets (3)
  • Struts (3)
  • J2EE (1)
  • Weblogic (2)
  • Middleware AllOther (1)
  • XML XSLT RSS (1)
  • Business Objects (14)
  • Cognos (6)
  • Informatica (11)
  • Ab Initio (2)
  • Data Stage (4)
  • SAS (1)
  • Micro Strategy (1)
  • ETL (3)
  • Data Warehouse General (1)
  • HR Questions (2)
  • Design Patterns (1)
  • Telecom Protocols (1)
  • SAP ABAP (6)
  • SAPScript (1)
  • SAP SD (5)
  • SAP MM (3)
  • SAP PM (1)
  • SAP FI CO (10)
  • SAP CRM (3)
  • SAP Business Warehouse (1)
  • SAP Security (7)
  • SAP Interfaces (1)
  • Siebel (1)
  • Oracle Apps Technical (10)
  • Oracle Apps Financial (7)
  • Oracle Apps HRMS (1)
  • Oracle Apps SCM (1)
  • ERP CRM AllOther (1)
  • Client Server General (1)
  • WebMethods (2)
  • Quality Analysis (1)
  • Civil Engineering (3)
  • Mechanical Engineering (12)
  • Electrical Engineering (12)
  • Electronics Communications (12)
  • Automobile Engineering (1)
  • Engineering AllOther (4)
  • Marketing Sales (1)
  • Banking Finance (1)
  • IT Management (1)
  • Taxation (1)
  • Accounting General (5)
  • Accounting AllOther (3)
  • Architecture Design AllOther (1)
  • Call Centre AllOther (64)
  • RRB (1)
  • Group I (1)
  • Group II History (1)
  • General Studies (2)
  • APPSC AllOther (1)
  • General Knowledge_Current Affairs (1)
  • Government AllOther (1)
  • Teaching (2)
  • Funny Interview Questions (3)
  • Everything Else AllOther (3)
  • English (1)
  • General Aptitude (9)
  • Puzzles (5)
  • Placement Papers (13)
  • CCNA (3)
  • CCDA (1)
  • CISA Certification (1)
  • Oracle Certifications (1)
  • ISTQB Certification (1)
  • Certifications AllOther (1)
  • USA Student Visa F1 Visa (1)
  • L1 Visa (2)
  • J2SE Code (3)
  • Shell Script Code (1)