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

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

ESS,

1 5536

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

ESS,

1 2385

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

1 2280

what is ora 600?

1 4799

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

IBM,

22 33711

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

2 5894

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 7241

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

1 2171

what is cardinality

CSC,

3 6988

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

7 12552

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

1 4450

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

1 2404

How to create Drill down report?

ABB, ESS, Infosys,

1 2216

How to call a report from Forms?

5 13390

why use cursors?

Oracle,

5 13141

Un-Answered Questions { Databases }

what are aggregate and scalar functions? : Sql dba

1123

please send me oracle pl/sql exp resume. and also faqs...

2566

define sql insert statement ? : Sql dba

1094

Can we use distinct and group by together?

1131

Explain system functions or built-in functions? What are different types of system functions?

1060

How do I remove duplicates in two columns?

1178

How to put more than 1000 values into an oracle in clause?

1110

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

What is normalization and what are the advantages of it?

1054

What is current version of mysql?

1071

Can we shrink data file in sql server?

1123

How to export data from database and import into another?

993

Are you familiar with user exits in reports?

how to start mysql server? : Sql dba

1260

How to write a left outer join with the where clause in oracle?

1149

For More Un-Answered { Databases } Questions Click Here