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

how to display last 5 letters from a name (take emp table ename )

IBM,

6 10608

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

IBM,

6 10425

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

2092

WHAT IS OPM?(IN DETAILED)

L&T,

1 10685

what is difference between having and where clause ?

3 5910

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage

ABC,

3 9588

How can we create the complete backup of data in the oracle.

IPEC, Satyam, SunTec,

1 2238

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

Satyam,

3 7250

Accidentally i deleted my table. How can i get that table?

4 9560

how can i view structure of table in sql server? tell me that query.

10 18529

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 8716

How the log writer writes the data into database

Baidu, Satyam,

4 8017

what is the role of archiever

Baidu, Satyam, TCS,

4 8851

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

Aviva,

1 3737

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 10912

Un-Answered Questions { Databases }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1043

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1066

What is a coalesce function?

1278

What is normalization and what are the advantages of it?

1054

What versions of clipper does netlib support?

1090

Is primary key always clustered index?

1094

How do I find the sql server version?

1100

List the ways in which dynamic sql can be executed?

1083

what are aggregate and scalar functions? : Sql dba

1125

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1985

What are the two main functions of queries in databases?

1526

If a cursor is open, how can we find in a pl/sql block?

1235

How to Change a users password from unix shell.

1214

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2090

Why we use the openxml clause?

1072

For More Un-Answered { Databases } Questions Click Here