Databases Interview Questions
Questions Answers Views Company eMail

What is the SQL?????????????????????????????


5 4027

What is the Query to print out the individual total number of duplicate row in sql.


5 7463

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,


How to display the hierarchy of employee and managers without using connect by prior.

1 2174

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?



how to know the tables in database having foreign key?

2 2385

find the second highest salary of the emp table

6 4248

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?


3 17518

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i



what is pragma ?


1 5080

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

IBM, Cognizant,

7 4627

What is the Query Optimizer. How you optimize your qeury.


2 4643

what is an sql server?

1 2389

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 2486

find 2nd highest salary of person using cursor concept?


6 5902

Un-Answered Questions { Databases }

what is a Nested Loop join?


Write short notes on manual refreshes.


what is data access layer?


What is the Maximum size for a table in PostgreSQL?


What is the difference between online clustering and Offline clustering?


Explain how you would restore a database using RMAN to Point in Time?


Explain the Normalized Relations?


What is the difference between NOROW and LOCKROW?


what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?


In what script is "snap$" created? In what script is the "scott/tiger" schema created?


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g


If user is owning any SQL Objects, can we drop that user


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: Thanks, Kartik T


What are the built-in functions used for sending Parameters to forms ?