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 5723

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 7041

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

4 9360

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 8495

How the log writer writes the data into database

Baidu, Satyam,

4 7800

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 3620

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

1 10798

Un-Answered Questions { Databases }

How to modify an existing stored procedure in ms sql server?

1082

What is the role of building blocks like nodes, relationships, properties and labels in neo4j?

What factors you will consider calculating the storage requirement for that view?

950

Explain sql data types?

1103

How to bring a tablespace online?

1080

what are the different index configurations a table can have? : Sql dba

997

What is the difference between local variables and global variables?

1125

How database are managed?

997

Why is oracle database so popular?

1006

What is resultset concur_updatable?

1021

what is the difference between Neo4j graph database and MySQL?

What are the security alerts while using mysql?

1038

How do you run a query in pgadmin 3?

749

What is meant by database system?

910

explain primary keys and auto increment fields in mysql : sql dba

980

For More Un-Answered { Databases } Questions Click Here