Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1942

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10683

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 8946

how do u find least salary in a table

4 6595

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

IBM,

6 7651

Delete duplicate records from the table?(Table must have unique id)

TCS, Thomson Reuters,

7 12577

agregator gives one to many records or many to one record

IBM,

1 4234

Why we are using the sql language?. What is the purpose of using this?

2 4221

what is the difference between table and veiw?

IBM,

4 7407

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

Hexaware,

4 10172

How to display First 4 rows From Database Table?

6 9938

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 4718

fact table and dimension table containg one to many relationship or many to one relastionship

2553

How do you connect 100 files as a flat file sources in one package of SSIS?

2 5288

Could you please provide oca (oracle 10g) dumps for my certification ?

1 5244

Un-Answered Questions { Databases }

How to convert string to objectid in mongoose?

Explain clause in sql?

1074

Which software is best for database?

930

How to convert character strings to dates?

1148

How to convert character strings into numeric values?

1153

What are the properties and different types of sub-queries?

1060

What is procedure and function in sql?

1049

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

1083

What do you mean by acid?

1060

What is database management definition?

977

What is a database connection string?

1172

What are two types of data in a database environment?

967

How many triggers are possible in mysql?

1013

What are the differences between char and varchar data types?

1191

How to execute a stored procedure in oracle?

1148

For More Un-Answered { Databases } Questions Click Here