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

What is store procedure?and how do u take the values from database and run in scripts?

Polaris,

2 5778

how can db_files > maxdatafiles since db_files is for instance and the later is for database

CTS,

1 2697

how to implement locking in sql server

Satyam,

3 9091

What is the difference between a Application Server and a Database

Oracle,

3 13439

What is the difference between 2-Tier architecture and 3-Tier architecture

CTS, MCN Solutions, Oracle,

15 69213

What are the composite date types in oracle?

HCL,

6 18339

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 6782

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 11035

in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

1 4410

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 5217

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

which will fire first ? Trigger or Constraint

i2, IBM,

24 52447

how to use sequence and what use of sequence cache

1 4593

what is difference between where clause and having clause?

13 37130

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

Covansys,

2100

Un-Answered Questions { Databases }

Suppose database is running slow, what will you do?

2591

What versions of clipper does netlib support?

1090

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1296

what is collation? : Sql dba

1229

How to Change a users password from unix shell.

1215

How efficient you are in oracle and SQL server?

1255

What are the kinds of subquery?

1103

How did mongodb get its name?

please send me oracle pl/sql exp resume. and also faqs...

2569

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2178

define sql insert statement ? : Sql dba

1097

Is it possible to have clustered index on separate drive from original table location?

1037

How to rebuild the master database?

1161

What is self contained sub query?

1138

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

1067

For More Un-Answered { Databases } Questions Click Here