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 6153

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

1 5619

What is mutating table?

Saama Tech,

11 66950

How to call DDL statements from pl/sql?

5 33729

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

Evosys, MBT,

4 17081

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

3 15176

what are Dynamic SQL statements?

9 26697

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 15761

what is constraining table?

2 14330

How pl/sql source code can be protected?

3 11622

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

TCS,

22 51886

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

2 13256

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

ICICI, Saama Tech, Sail,

7 48997

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

3199

Un-Answered Questions { Databases }

How to rollback the current transaction in oracle?

1054

How do you open a cluster administrator?

1053

How to change the data type of an existing column with "alter table" statements in ms sql server?

982

How different is ms access and oracle?

1038

How many dba can you have?

544

What is rank function?

1030

How do I recompile a procedure in oracle?

964

What is sql server profiler trace data file?

1109

List the different type of joins?

1061

The select into statement is most often used to create backup copies of tables or for archiving records?

1064

How can I insert images into a Mysql database?

1051

how may join possible between (requisition with purchase order)

2250

What is a good example of a transaction in sybase?

1019

What is factless fact table? : sql server analysis services, ssas

1028

What are the different types of triggers in mysql?

963

For More Un-Answered { Databases } Questions Click Here