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


Databases Interview Questions
Questions Answers Views Company eMail

find the 3rd max salary

 10 8886

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 10987

explain GROUPBY & HAVING clause with examples.

 1830

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 6752

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 4192

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

Zensar,

1 5521

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 10041

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

HCL, IBM,

9 16363

How to Handle the exceptions in Sqlsrver 2005??

Value Labs, Wipro,

3 6418

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 4254

date funciton

2 3101

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

Genpact,

2 6625

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

Cap Gemini, iGate,

1 24020

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

 1687

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

TCS,

2 3736

Un-Answered Questions { Databases }

How can we tune a sql query to optimize the performance of a database?

1

default triggers available for reports

1757

What is a select query statement in ms sql server?

578

what are the types of indexes? : Sql server database administration

595

what is a transaction? : Sql server database administration

471




What is regexp?

652

Can one improve the performance of sql*loader? : aql loader

585

How easy is netlib to use?

548

Will count(column) include columns with null values in its count?

666

Write a query for primary key constraint with identity key word?

571

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

499

What privilege is needed for a user to insert rows to tables in another schema?

560

What is the most common type of join?

524

Explain materialized views and how they are used.

1892

what is a tablespace? : Sql dba

560

For More Un-Answered { Databases } Questions Click Here