1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

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

CMS,

5 6465

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

TCS,

5 10131

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

1673

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

 1 3246

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,

2006

how to know the tables in database having foreign key?

 2 3570

find the second highest salary of the emp table

 6 6668

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 20827

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

HP,

1524

what is pragma ?

Polaris,

1 6351

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

Cognizant, IBM,

7 7656

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

Ericsson,

2 6325

what is an sql server?

 1 3497

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

 2 3998

find 2nd highest salary of person using cursor concept?

HCL,

6 9859

Un-Answered Questions { Databases }

What is the command used to fetch the first 5 characters of a string?

705

What are the database administrators utilities available?

576

What is data directory in mysql?

480

Delete duplicate rows without using rowid.

1070

Does sqlite need a server?

539




How to list all user defined functions in the current database?

512

How to use rank function in mysql?

473

Mention the location of log files in couchdb?

1

can you elaborate on blob and text in mysql? : Mysql dba

472

Is sql free?

499

How can use stored procedures in sql?

580

Mention the different authentication modes in sql server.

534

How is mongodb used?

1

Why do we use bulk collect in oracle?

569

what is uncommittable transactions? : Transact sql

565

For More Un-Answered { Databases } Questions Click Here