MySQL Interview Questions and Answers
Ques:- 2.Write the Sql Query for Average Calculation?
Ques:- How to insert the data in to the data table from the database records?
Ques:- What is the main difference between PL/SQL and SQL
Ques:- What r steps to we need to fallow b4 kill the process?
Ques:- How to get the second max val for every group in a table
Ques:- Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Ques:- Difference between Unique and Primary key
Ques:- IF i write before / after insert / update trigger and i do rollback what will happen?
Ques:- Define Query Interface,Adref,Release
Ques:- DBMS – SQL (prepare for grilling), triggers, normalization (Most of these were “explain what is”….)
Ques:- A SQL query was given and was asked to find out what it does.
Ques:- Employee(Company Name, Employee name, Salary) is a table. You need to find out the company with maximum number of employees
Ques:- Which of the following statements is true about implicit cursors?
Ques:- What is the STUFF function and how does it differ from theREPLACE function?
Ques:- Write a Query to pull out the maximum unit price for each in the database. (Using Northwind database)
Ques:- Advantages and disadvantages of attributes.
Ques:- What are PL/SQL Cursor Exceptions
Ques:- Which of the following is not a feature of a cursor FOR loop?
Ques:- Is there more the two primary key in a single table?
Ques:- What does the following query do?SELECT SAL + NVL(COMM,0) FROM EMP;
Ques:- Explain UNION,MINUS,UNION ALL, INTERSECT ?
Ques:- What is the parameter substitution symbol used with INSERT INTO command?
Ques:- How to drop the index
Ques:- What operator tests column for the absence of data?
Ques:- What are the Restrictions on Cursor Variables?
Ques:- What are joins and subjoins in the data bases
Ques:- How do I replace a comma (,) with a blank in a select statement?
Ques:- The Concatenation Operator in TSL is?
Ques:- Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?
Ques:- Advantages and Disadvantages of Cursor?