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


Databases Interview Questions
Questions Answers Views Company eMail

issues involved in modeling and building data werahouses

 1549

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

TCS,

8 10465

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 6886

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 8931

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 5402

how to send file attachment from oracle forms

HCL,

2127

Can some one please help with a query which will take only max value of a column in a join.

 2 3378

what is the difference between rollback & commit? can a foreign key has null value?

6 12325

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

TVS,

2 4401

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

Tech Mahindra,

2 6941

how do you count the duplicate records in a table

Tech Mahindra,

10 16138

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

 1588

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

HP,

1800

which database is best to use in oracle and sql server? explain reasons?

TCS,

5 6664

how to replace not in with not exist?

IBM,

3187

Un-Answered Questions { Databases }

Is index automatically created on primary key?

426

Is it possible to replicate data from sql server to oracle? : sql server replication

540

Where is the mongodb database?

1

What are the advantages of MySQL when compared with Oracle?

533

What is an escape character in sql?

558




What is Collation Sensitivity ? What are the various type ?

493

What are the disadvantages of microsoft access?

410

How do I copy a table in mysql?

482

Can i create more than one Master Repository in ODI?

300

Is microsoft access an sql database?

429

How replication works in mongodb?

1

how would you convert a secondary server into a primary server ?

42

What is #table in sql server?

530

How can we view last record added to a table?

591

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

583

For More Un-Answered { Databases } Questions Click Here