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

Oracle (3258)
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

How to define an anonymous procedure without variables?

789

How many data types are supported?

848

How to connect to the server with user account: sys?

817

How to define default values for formal parameters?

819

What are the restrictions on external table columns?

836

What privilege is needed for a user to insert rows to tables in another schema?

822

How to loop through data rows in the implicit cursor?

849

How to create additional tablespaces for an new database?

820

How many categories of data types?

784

Can you assign multiple query result rows to a variable?

787

How to use fetch statement in a loop?

808

Can dml statements be used in pl/sql?

836

Can variables be used in sql statements?

808

How to revise and re-run the last sql command?

895

How to process query result in pl/sql?

840

Un-Answered Questions { Databases }

What is a light scan in informix?

What is the purpose of sql profiler in sql server? : sql server database administration

877

Does truncate table reset auto increment?

775

What are joins in sql?

770

Explain transaction server implicit?

753

What is an Entity set?

740

What is sql profiling in oracle?

785

Explain the function of optimizer in oracle?

815

How do I partition a table in sql server?

781

Tell me the use of keyword with encryption. Create a store procedure with encryption?

822

How to read xml file in oracle pl sql?

721

How many sql statements are used? Define them.

828

What is the command used to fetch the first 5 characters of a string?

986

How configure sybase odbc connection?

662

How to link microsoft access to excel?

709

For More Un-Answered { Databases } Questions Click Here