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 6069

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

1 5505

What is mutating table?

Saama Tech,

11 66511

How to call DDL statements from pl/sql?

5 33503

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

Evosys, MBT,

4 16863

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

3 15006

what are Dynamic SQL statements?

9 26345

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

TCS,

1 15402

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

4 15516

what is constraining table?

2 14209

How pl/sql source code can be protected?

3 11442

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

TCS,

22 51119

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

2 13106

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

ICICI, Saama Tech, Sail,

7 48746

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

3154

Un-Answered Questions { Databases }

What is 5nf in normalization form?

945

What is Relational Calculus?

817

How many scalar data types are supported in pl/sql?

985

What is difference between rank () row_number () and dense_rank () in sql?

1057

Explain the advantages of rdbms?

882

What is database development process?

849

What is openedge rdbms?

920

What is the purpose of indexing?

1006

Why does for update in oracle 8 cause an ora-01002 error?

945

Would you store your query in a ssrs report or a database server? State the reason why?

150

How do you check if ms access is installed?

854

How does index help in query performance?

973

What is variable and how many types of variable?

539

what is database black box testing? : Mysql dba

1063

What does currency type mean in database?

1142

For More Un-Answered { Databases } Questions Click Here