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 6062

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

1 5501

What is mutating table?

Saama Tech,

11 66487

How to call DDL statements from pl/sql?

5 33495

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

Evosys, MBT,

4 16857

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

3 15002

what are Dynamic SQL statements?

9 26326

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

TCS,

1 15398

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

4 15508

what is constraining table?

2 14204

How pl/sql source code can be protected?

3 11434

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

TCS,

22 51081

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

2 13103

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

ICICI, Saama Tech, Sail,

7 48733

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

3151

Un-Answered Questions { Databases }

What is the latest version of microsoft access?

848

what is difference between delete and truncate commands? : Sql dba

1070

Which join is like an inner join?

964

What are inbuilt functions in sql?

998

What is the instance of a relation?

959

What will you do if a replication thread goes down?

928

What is materialized view. What are different methods of refresh?

1342

What do you mean by acid?

947

Illustrate physical database architecture in brief? : sql server architect

727

What is the difference between count (*), count (expression), count (distinct expression)?

968

What are the types of database schema? : sql server analysis services, ssas

1073

What are subquery and its properties?

986

When does checkpoint occur in dbms?

986

What's the best database software for mac?

882

what is the syntax for using sql_variant_property? : Transact sql

990

For More Un-Answered { Databases } Questions Click Here