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


Databases Interview Questions
Questions Answers Views Company eMail

One table how may column and Primary key

 3 4090

How to update salary of employees department wise?

 6 13167

what are the methods using performance tunning in sql and pl/sql

 2 5536

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

IBM, Loginworks, OFSS,

2 9645

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

 3 6133

How do you use collections in procedure to return the resultset?

 1776

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

 1828

Psudo colums

HP,

1 3643

how will you see when the database was started using sql prompt?

IBM,

2 5332

how to call forms in parametar forms

 2 4988

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

 2 4007

How to get second highest salary from a table

 3 5944

How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as 'ROWID'. Likewise in sybase which one is pseudo column?

 1 6118

In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries?

CTS,

1 3753

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

CTS,

3 4830

Un-Answered Questions { Databases }

What kinds of responsibilities does a dba have in a database environment?

265

Is mysql a programming language?

436

Can we commit in trigger?

537

Can you redefine a table online?

657

How many types of keys are there?

520




Why phpmyadmin is used for mysql?

494

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

371

What is microsoft access 2007?

443

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1565

What mysql -u john -p command does?

506

What is SubQuery in SQL Server 2008

537

Explain the scenarios or situations under which progress database creates new index entry for a record?

517

what do you understand by change data capture?

542

What are the uses of synonyms?

591

What is dbcc? Give few examples.

559

For More Un-Answered { Databases } Questions Click Here