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

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

ESS,

1 5414

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

ESS,

2311

aht is the difference b/w network & hierarchial & relational dbms????

2212

what is ora 600?

1 4653

how will I find the first 5 highest salaried employees in each dept in oracle.

IBM,

22 32800

how will I find the duplicate rows count from employees tablein oracle.

2 5770

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 7037

how to take backup bcp out for a column in table in sql server?

2105

what is cardinality

CSC,

3 6804

How many types of trigger can be used in a table at a time ?

7 12229

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4350

how to clone 9i Database on to 10g Database.

2339

How to create Drill down report?

ABB, ESS, Infosys,

2127

How to call a report from Forms?

5 13151

why use cursors?

Oracle,

5 12845

Un-Answered Questions { Databases }

Can we create foreign key without primary key?

985

Explain for xml explicit mode?

974

when would you go for denormalization? : Sql server database administration

870

What port does sql server use?

1061

what is 'mysqld'? : Sql dba

969

What are 3 types of databases?

960

How oracle handles dead locks?

1066

what are the different integrity rules present in the dbms?

982

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2232

What is xdr?

987

Explain the third normal form(3nf)?

943

Can I use a named pipe to bcp/dump data out or in in sybase?

1007

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3569

how you can move data or databases between servers and databases in sql server? : Sql server administration

963

What is $$ in sql?

990

For More Un-Answered { Databases } Questions Click Here