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

Oracle (3259)
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.

1903

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10607

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 8749

how do u find least salary in a table

4 6456

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 7432

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

TCS, Thomson Reuters,

7 12365

agregator gives one to many records or many to one record

IBM,

1 4154

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

2 4099

what is the difference between table and veiw?

IBM,

4 7254

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 10037

How to display First 4 rows From Database Table?

6 9712

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

2 4623

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

2497

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

2 5201

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

1 5170

Un-Answered Questions { Databases }

How to get a list all databases on the sql server?

1105

How to create a user to access a database in ms sql server using "create user" statements?

956

How to write character string constants or literals in ms sql server?

1027

How to specify default values in insert statement using oracle?

1111

What is varray in pl sql?

1078

Does postgres support clustering?

855

How many subqueries can be nested in a statement?

989

Does office 365 business premium include access?

764

What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?

How to execute postgres function in pgadmin?

1065

What is analysis service repository?

1025

Explain linked server in sql?

1226

Write a trigger example in oracle?

1068

What are the indexing methods?

1052

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1614

For More Un-Answered { Databases } Questions Click Here