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

Why should one not prefix user stored procedures with ‘sp_’?

1064

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1013

What are the new data types are introduced in sql 2000?

921

List some of the rules that apply to creating and using a ‘view’

902

Explain active/passive and active/active cluster configurations?

1069

Can a database be shrunk with users active?

1156

How you can change a cross join into an inner join?

996

How you can add messages to the nt event log from within a stored procedure?

1087

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1089

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1021

Can a rule be bound to any column of any data type?

984

can an order by clause be used in a creation of a view?

1196

Define constraints and give an example of their use?

1060

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

953

How can a user-defined datatype be created?

1001

Un-Answered Questions { Databases }

What is the reports view in oracle sql developer?

1005

What is maximum size for an access database?

935

How do you run a trace?

920

How does cross join work?

971

Can we write ddl in trigger?

932

What is the difference between stored procedures and stored functions in oracle?

962

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

976

List out the different types of locks available in sql server?

995

What are the main features of a database?

1051

What are the types of database lock?

1071

how to present a past time in hours, minutes and seconds? : Sql dba

1030

What are views used for?

1028

How to load data with sql*loader?

1066

How to reaname table name without using sp_Rename in sql server..?

1010

Show how functions and procedures are called in a pl/sql block.

1147

For More Un-Answered { Databases } Questions Click Here