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 10244

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

IBM,

6 10130

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

2021

WHAT IS OPM?(IN DETAILED)

L&T,

1 10584

what is difference between having and where clause ?

3 5724

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

ABC,

3 9413

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

IPEC, Satyam, SunTec,

2161

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

Satyam,

3 7042

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

4 9361

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

10 18105

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

5 8496

How the log writer writes the data into database

Baidu, Satyam,

4 7801

what is the role of archiever

Baidu, Satyam, TCS,

4 8625

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 3621

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

1 10800

Un-Answered Questions { Databases }

What is index, cluster index and nonclustered index?

997

What does cursor do in sql?

1029

When should you consider denormalization?

982

What pl/sql package consists of?

1089

How to read data in a table with "select" statements?

970

in mongodb, What is crud?

What is StandAlone Agent and default port number?

700

What is difference between hadoop and mongodb?

What is difference between 2 tier and 3 tier architecture?

782

How does postgresql compare to oracle/db2/ms sql server/informix?

1038

Is keyword pl sql?

1011

What are truncate options available in sql server? : sql server database administration

1036

Does group by sort data?

905

What is the symbol of logical OR operation in mongodb?

Is oracel sql developer written in java?

1115

For More Un-Answered { Databases } Questions Click Here