Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

For web applications from which version of Oracle is suitable?

1 4679

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

1 4513

What is mutating table?

Saama Tech,

11 62113

How to call DDL statements from pl/sql?

5 31345

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

Evosys, MBT,

4 14800

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

3 13451

what are Dynamic SQL statements?

9 23197

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

TCS,

1 14029

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

4 13602

what is constraining table?

2 12747

How pl/sql source code can be protected?

3 9778

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

TCS,

22 45292

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

2 11685

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

ICICI, Saama Tech, Sail,

7 45809

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

2724

Un-Answered Questions { Databases }

How to drop an existing table in mysql?

553

What database should I learn first?

529

What is the contrast between sql and mysql?

592

How do we synchronize On-Premise SQL server with SQL Azure?

Explain different types of lock modes in sql server 2000?

521

What command is used to rename the database?

525

What gets stored inside msdb database?

762

What is stored procedure in database?

506

as a technical developer in oracle applications which type errors feced in your experience sofar

1905

Does transparent data encryption provide encryption when transmitting data across the network?

624

What happens if the update subquery returns no rows in ms sql server?

587

What is the difference between clustered and non-clustered index? : sql server DBA

545

What is the difference between char, varchar and nvarchar?

568

List some neo4j cql command.

Explain candidate key, alternate key, and composite key?

588

For More Un-Answered { Databases } Questions Click Here