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 come back in normal stage in Mutating Table if mutating table is locked or update data?

2 6615

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 10525

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 6601

If records are inserted into table without committing.How to refer to these values in a procedure?

2 7582

what is ref cursor in pl/sql?

3 22340

How to fetch the rows by dynamicaly passing table name through cursor?

3 10374

what is difference between "Primary key" and "Unique key"?

PreVator,

4 9332

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

Fujitsu,

2 13254

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

PreVator,

7 19491

How the execution will be done in exceptions?

2 7151

What is the difference between sql/pl-sql/embeded sql?

3 12597

what is the forward decleration in packages?

1 5927

In packages the source code is compiled into p code ? how do we describe the p code

3 7161

what is meant by tuning and tk proof?

2 13395

How would you hide a table in sql. ie the table can be only visible to its maker?

3 11014

Un-Answered Questions { Databases }

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

How to analyze tables with 'mysqlcheck'?

1207

Can we protect our pl/sql source code?

1048

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1950

What versions of clipper does netlib support?

1006

When should I execute an sp_recompile in sybase?

899

How bulk collect improves performance?

1011

What is the dba role in oracle?

577

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

1041

What are set operators?

1088

What is the difference between truncate and drop statements?

1192

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1116

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1146

How do I grant privileges to a user in mysql phpmyadmin?

955

How does a profiler work?

936

For More Un-Answered { Databases } Questions Click Here