Databases Interview Questions
Questions Answers Views Company eMail

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

CMS,

5 4027

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

TCS,

5 7463

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

1050




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?

IBM,

1236

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 ?

TCS,

3 17518

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

HP,

866

what is pragma ?

Polaris,

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.

Ericsson,

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?

HCL,

6 5902







Un-Answered Questions { Databases }

what is a Nested Loop join?

851


Write short notes on manual refreshes.

1682


what is data access layer?

1211


What is the Maximum size for a table in PostgreSQL?

405


What is the difference between online clustering and Offline clustering?

1260






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

925


Explain the Normalized Relations?

1612


What is the difference between NOROW and LOCKROW?

1341


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?

1568


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

1274


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

961


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

865


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

885


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: karthikgdv1206@yahoo.com. Thanks, Kartik T

1055


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

2225