What are various joins used while writing SUBQUERIES?



Question: What are various constraints used in SQL?



Question: What are different Oracle database objects?



Question: What is difference between Rename and Alias?



Question: What is a view ?



Question: What are various privileges that a user can grant to another user?



Question: What is difference between UNIQUE and PRIMARY KEY constraints?



Question: Can a primary key contain more than one columns?



Question: How you will avoid duplicating records in a query?



Question: What is difference between SQL and SQL*PLUS?



Question: Which datatype is used for storing graphics and images?



Question: How will you delete duplicating rows from a base table?



Question: What is difference between SUBSTR and INSTR?



Question: There is a string 120000 12 0 .125 , how you will find the position of the decimal place?



Question: There is a % sign in one field of a column. What will be the query to find it?



Question: When do you use WHERE clause and when do you use HAVING clause?



Question: Which is more faster - IN or EXISTS?



Question: What is a OUTER JOIN?



Question: How you will avoid your query from using indexes?



Question: What is a pseudo column. Give some examples?


Question: Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?



Question: Display the records between two range?



Question: Find out nth highest salary from emp table



Question: Display the number value in Words?



Question: Display Odd/ Even number of records



Question: How do you find the numbert of rows in a Table ?



Question: minvalue.sql Select the Nth lowest value from a table



Question: maxvalue.sql Select the Nth Highest value from a table



Question: What is the purpose of a cluster?



Question: What is a cursor?



Question: Difference between an implicit & an explicit cursor.



Question: What are cursor attributes?



Question: What is a cursor for loop?



Question: Difference between NO DATA FOUND and %NOTFOUND



Question: What a SELECT FOR UPDATE cursor represent.



Question: What WHERE CURRENT OF clause does in a cursor?



Question: What is use of a cursor variable? How it is defined?



Question: What should be the return type for a cursor variable.Can we use a scalar data type as return type?



Question: How you open and close a cursor variable.Why it is required?



Question: How you were pa...

Show full text: 4,220 characters