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


Databases Interview Questions
Questions Answers Views Company eMail

issues involved in modeling and building data werahouses

 1561

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 10543

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 6925

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 8981

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 5425

how to send file attachment from oracle forms

HCL,

2140

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

 2 3397

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

6 12362

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

TVS,

2 4428

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 6964

how do you count the duplicate records in a table

Tech Mahindra,

10 16221

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?

 1601

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

HP,

1806

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

TCS,

5 6703

how to replace not in with not exist?

IBM,

3197

Un-Answered Questions { Databases }

What is system tablespace?

636

Mention what is cluster?

1

What is tuple with example?

495

What are the oracle differences between nvl and coalesce

518

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2260




You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99

What is the difference between a primary key and a composite key?

418

What is data directory in mysql?

487

Under which circumstance should you create an index on a table?

700

What is a distributed database system?

521

What is tabulation?

564

Can you tell a way to know the number of days between the two given dates in php?

592

What are trace flags and mention a few common trace flags used with sql server?

557

Is oracle a relational database?

524

What are a scheduled jobs or what is a scheduled tasks?

496

For More Un-Answered { Databases } Questions Click Here