SQL faqs

What is scrollable cursor?
The use of HAVING, WHERE and GROUPBY in one SQL?
What is SORTING and GROUPING?
What are the different types of OUTER JOINS?
Explain the UNION operation in SQL . What is meant by OUTER JOIN?
What is a non-correlated subquery?
What is a correlated subquery?
What do you know about subqueries?
What is the theory behind the JOIN statement in DB2?
What are the different types of SQL?
How to drop the column in a table?
How to drop the index?
What are the different tablespaces in database?
What is the maximum number of triggers, can apply to a single table?
What is the output of SIGN function?
What are the more common pseudo-columns?
Other way to replace query result null value with a text?
What are PL/SQL Cursor Exceptions?
Any three PL/SQL Exceptions?
Any three PL/SQL Exceptions?
Which date function returns number value?
Display Odd/ Even number of records?
Display the number value in Words?
To view installed Oracle version information?
Find out nth highest salary from emp table?
Implicit Cursor attributes?
Explicit Cursor attributes?
Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text Not Applicable want to display, instead of blank space. How do I write the query?
How do I display row number with records?
How do I eliminate the duplicate rows?
If a view on a single base table is manipulated will the changes be reflected on the base table? If Yes - under what conditions?
Can a view be updated/inserted/deleted?
What are the advantages of VIEW?
What is CYCLE/NO CYCLE in a Sequence?
Is it possible to access the current value in a session before accessing next value?
How to access the current value and next value from a sequence?
What is a database link?
If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
How will you activate/deactivate integrity constraints?
Where the integrity constraints are stored in data dictionary?
What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?
Is it possible to use LONG columns in WHERE clause or ORDER BY?
How many LONG columns are allowed in a table?
What is the maximum SIZE allowed for each type?
What is difference between CHAR and VARCHAR2?
What are the data types allowed in a table?
What is ON DELETE CASCADE?
What is the usage of SAVEPOINTS?
What is referential integrity constraint?
What is an integrity constraint?
What is the fastest way of accessing a row in a table?
What is ROWID?
Explain UNION, MINUS, UNION ALL and INTERSECT?
Difference between SUBSTR and INSTR?
Explain CONNECT BY PRIOR?
What is correlated sub-query?
What is the sub-query?
Explain the different types of joins?
What is a join?
What is difference between TRUNCATE & DELETE?
What is a transaction?
What are the types of SQL statement?
Which datatype is used for storing graphics and images?
LONG RAW data type is used for storing BLOB’s (binary large objects)?
What is a pseudo column. Give some examples?
It is a column that is not an actual column in the table? eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL?
What are the differences you have seen while installing Oracle on NT and Unix platform?

No comments: