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 10601

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

2091

WHAT IS OPM?(IN DETAILED)

L&T,

1 10682

what is difference between having and where clause ?

3 5909

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

ABC,

3 9584

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

IPEC, Satyam, SunTec,

1 2233

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

Satyam,

3 7248

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

4 9559

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

10 18511

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

5 8712

How the log writer writes the data into database

Baidu, Satyam,

4 8015

what is the role of archiever

Baidu, Satyam, TCS,

4 8843

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 3731

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

1 10910

Un-Answered Questions { Databases }

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1128

List out the different types of locks available in sql server?

1045

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

What are the advantages of database?

1009

Why and when do stored procedure recompile?

1054

Do we need to rebuild index after truncate?

1132

What is a scheduled job or what is a scheduled task?

1033

How to convert character strings into numeric values?

1186

How to define array in mongoose schema?

Can we shrink data file in sql server?

1123

Is primary key always clustered index?

1092

How do I find the sql server version?

1099

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

1149

How to remove duplicate rows from table except one?

1082

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

For More Un-Answered { Databases } Questions Click Here