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


Databases Interview Questions
Questions Answers Views Company eMail

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

HCL, Wipro,

1855

What is the difference between online clustering and Offline clustering?

IBM,

1920

When do u use clustered index and non-clustered index?

IBM,

3 7750

What is the diffrence between update_one and auto_fix?

IBM,

3 9881

what are the advanced features in sql 2008?

Wipro,

2 5386

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

 2 7047

what are the diffeenes between oracle 9i,oracle 10g

 2 5162

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

 1791

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

 2 12599

what is correlated subquery

3 3926

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

 1583

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

 7 8970

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

 1 3306

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

 4 5223

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

 4 5379

Un-Answered Questions { Databases }

How to use sql*plus built-in timers?

578

What is split brain syndrome in rac?

1

What is the purpose of ms access?

415

What is the purpose of database management system?

542

Why do we create views in sql?

562




Tell me the phases a transaction has to undergo?

553

Do indexes speed up queries?

453

In what three ways is the return statement used in a stored procedure?

517

How are extents allocated to a segment?

582

How to get execution statistics reports on query statements?

572

Explain what is log shipping?

583

How to insert multiple rows with one insert statement in oracle?

572

What does normalization do to data?

549

You are required to create a macro that can run action query. What steps will you take?

483

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2507

For More Un-Answered { Databases } Questions Click Here