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


Databases Interview Questions
Questions Answers Views Company eMail

find the 3rd max salary

 10 8927

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

Satyam,

10 11056

explain GROUPBY & HAVING clause with examples.

 1834

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

Zensar,

3 6773

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

Zensar,

1 4208

how can stop the sequence with mention the max value and with out mention the max value

Zensar,

1 5533

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

Zensar,

9 10111

How to Remove the 3rd highest salary person record from table?

HCL, IBM,

9 16398

How to Handle the exceptions in Sqlsrver 2005??

Value Labs, Wipro,

3 6429

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

 3 4272

date funciton

2 3112

What is a diffrence between SQL, MS access and SAS?

Genpact,

2 6641

What questions might be they ask in managerial round in capgemini.

Cap Gemini, iGate,

1 24033

What is best institute to Learn DotNET And SQL in chennai?

 1694

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

TCS,

2 3754

Un-Answered Questions { Databases }

What is back end and front end?

470

What is the difference between a view and a stored procedure?

565

What is bind variable in pl sql?

532

Explain how to convert a report into excel sheet.

1

What is dbms and its advantages?

516




How to transfer a table from one schema to another?

560

hiding item in report how like that properly,thats manually but at runtime i want to do

2553

What is the example of procedure?

525

What is the purpose of my sql?

510

Can I call a procedure inside a function?

556

What are the key characteristics of rac or why to use rac?

1

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1445

What are named parameters?

616

Where is database stored?

460

How do you update f as m and m as f from the below table testtable?

1091

For More Un-Answered { Databases } Questions Click Here