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

For web applications from which version of Oracle is suitable?

1 6231

What are the main diff. between oracle 7.3 and oracle 8i?

1 5702

What is mutating table?

Saama Tech,

11 67378

How to call DDL statements from pl/sql?

5 33889

How to perform a loop through all tables in pl/sql?

Evosys, MBT,

4 17259

How to maintain the history of code changes of pl/sql?

3 15334

what are Dynamic SQL statements?

9 26960

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 15618

What is pl/sql and what is it used for?

4 15948

what is constraining table?

2 14454

How pl/sql source code can be protected?

3 11780

What is the result, when NULL is compared with NULL?

TCS,

22 52676

What can be a size of a pl/sql block? Is there any limit?

2 13377

what are %TYPE and %ROWTYPE? what is the difference?

ICICI, Saama Tech, Sail,

7 49247

How to set the time zone for MySQL to particular country time?

3250

Un-Answered Questions { Databases }

What is mean by dml?

1060

State the acid rules?

1179

What are different types of data sources?

1082

List out the difference between commit, rollback, and savepoint?

1092

Why would you call update statistics? : sql server DBA

1039

What is pls integer?

1090

Can we join two tables without common column?

1058

What is the page protect in reports?

How do I edit a stored procedure in mysql?

971

What is difference between sid and service name in oracle?

1006

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

561

What is primary key and example?

997

What is the difference between hashed file stage and sequential file stage in relates to datastage server?

1136

Can we use bind variables in oracle stored procedure?

986

How do you concatenate in sql?

1086

For More Un-Answered { Databases } Questions Click Here