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.

1941

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10678

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 8933

how do u find least salary in a table

4 6586

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 7640

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

TCS, Thomson Reuters,

7 12569

agregator gives one to many records or many to one record

IBM,

1 4229

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

2 4219

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 10166

How to display First 4 rows From Database Table?

6 9931

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

2 4715

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

2549

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

2 5285

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

1 5244

Un-Answered Questions { Databases }

What do you understand by unique key?

1025

what is a crs resource?

1240

What is the difference between update lock and exclusive lock?

1028

What are character string data types in ms sql server?

1350

In which files does sql server actually store data?

954

Explain openquery function and openrowset function?

993

how to write the sub-queries in odi?

750

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1147

Does mongodb support sql server?

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2874

Mongodb uses bson to represent document structures. True or false?

What are the Types of Scd's?

629

What is java sql package?

1145

What methods do you follow to protect from sql injection attack?

1075

what happened to the global index when I truncate the data in one of the partition?

2067

For More Un-Answered { Databases } Questions Click Here