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


Databases Interview Questions
Questions Answers Views Company eMail

Can somebody helps me to arrange these into ascending order depending on their sizes: 1)OLTP 2)ODS 3)DWH 4)DATA MART

Wipro,

2 4991

What is the maximum number of triggers,can apply to a single table?

 2 7928

What packages(if any) has oracle provided for use by developers?

 1 5039

What's dateware house and what's clustor with practicle example

 1643

what's query optimization and without use of IN AND Exist can we get another way data from query

 1672

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

 3 3877

Simple example for difference between select and cursor in sql

 1 3765

can we drop dual table

Metric Stream,

7 13969

25.67,-1 Trunc = 20 Round= 30 HOW????

Karrox,

2 6746

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

Sun Life,

2 4259

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

Oracle,

2 5106

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

Oracle,

1 4627

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

DELL, HCL, Oracle,

6 11475

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 4936

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

 6 6949

Un-Answered Questions { Databases }

Explain some of the uses of openedge architect features useful for a developer?

473

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1348

I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?

519

Where views are stored in sql server?

564

What is difference between materialized view and view?

494




Why myisam is faster than innodb?

492

Can multiple columns be used in group by in oracle?

553

How to run sql server 2005 books online on your local system?

521

Explain different types of self contained sub query?

546

Why oracle forms required?

565

Explain the microsoft sql server delete command? : sql server architect

439

Where the database is stored in mysql?

497

Is it possible to sort a column using a column alias?

609

How to display odd rows in student table in mysql?

473

What are the different types of failures that occur in Oracle database?

605

For More Un-Answered { Databases } Questions Click Here