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 5438

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

ESS,

2327

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

2227

what is ora 600?

1 4669

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

IBM,

22 32959

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

2 5784

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 7080

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

2115

what is cardinality

CSC,

3 6829

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

7 12285

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

4361

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

2352

How to create Drill down report?

ABB, ESS, Infosys,

2148

How to call a report from Forms?

5 13195

why use cursors?

Oracle,

5 12880

Un-Answered Questions { Databases }

How to connect a sql*plus session to an oracle server?

1142

Explain a private synonyms?

1050

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2416

How do I drop a collection in mongodb?

Explain what is analysis service repository?

1012

What are the roles and responsibilities of oracle dba?

651

What is the “__v” field in mongoose?

Difference between the “verify” and “feedback” command?

1377

What is ordbms with example?

933

How does sql store data?

927

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2087

What is self referencing foreign key?

795

What is difference between database and dbms?

1012

What are the different tcl commands in sql?

1192

What are the different technologies used to access Database from Visual Basic?

980

For More Un-Answered { Databases } Questions Click Here