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

For web applications from which version of Oracle is suitable?

1 6152

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

1 5619

What is mutating table?

Saama Tech,

11 66947

How to call DDL statements from pl/sql?

5 33729

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

Evosys, MBT,

4 17080

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

3 15176

what are Dynamic SQL statements?

9 26696

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

TCS,

1 15526

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

4 15760

what is constraining table?

2 14329

How pl/sql source code can be protected?

3 11621

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

TCS,

22 51883

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

2 13255

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

ICICI, Saama Tech, Sail,

7 48994

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

3199

Un-Answered Questions { Databases }

What are the technical features of MySQL?

1011

What is ddl in dbms?

986

Why is sql better than hql?

992

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2183

Why is the use of dbms recommended? Explain by listing some of its major advantages.

1687

What do you understand by hotfixes and patches in sql server?

991

What's the difference between file and database? Can files qualify as a database?

966

Explain the syntax of named procedure?

1000

Name the sql joins that are available in informix.

What is session variable in mysql?

979

How do I connect to mysql database?

1041

What is data in mysql?

904

What are system databases into sql server (2005/2008)?

999

What are federated tables?

1185

What query language does mongodb use?

For More Un-Answered { Databases } Questions Click Here