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

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

IBM,

6 10285

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

IBM,

6 10184

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

2032

WHAT IS OPM?(IN DETAILED)

L&T,

1 10604

what is difference between having and where clause ?

3 5750

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

ABC,

3 9436

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

IPEC, Satyam, SunTec,

2172

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

Satyam,

3 7069

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

4 9387

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

10 18150

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

5 8526

How the log writer writes the data into database

Baidu, Satyam,

4 7830

what is the role of archiever

Baidu, Satyam, TCS,

4 8663

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 3640

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

1 10816

Un-Answered Questions { Databases }

What is trigger in flip flop?

1021

What is oracle rownum?

966

Is crud a cuss word?

1042

Can we use where clause with group by?

920

Explain different types of collation sensitivity?

991

What is pl sql commands?

1059

What are the objects can be created using CREATE statement?

1003

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1144

What file will give you oracle instance status information? Where is it located?

632

What is percent sign in sql?

1301

What is the basic form of sql query?

958

What is sybase used for?

966

Why do we need integrity constraints in a database?

1045

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1999

Is oracle an open source?

1097

For More Un-Answered { Databases } Questions Click Here