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

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

What are advantages fo Stored Procedures?

1 3315

What are the uses of Database Trigger ?

1788

What is Database Trigger ?

1 3119

Can the default values be assigned to actual parameters?

1 2778

Can a primary key contain more than one columns?

2 3857

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3493

Differentiate between TRUNCATE and DELETE?

2 3136

What is difference between a formal and an actual parameter?

1 2757

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2732

What are different Oracle database objects?

1 2748

What is difference between SUBSTR and INSTR?

1 3139

Display the number value in Words?

1 3173

What is difference between SQL and SQL*PLUS?

1 3035

What are various joins used while writing SUBQUERIES?

2 4111

What a SELECT FOR UPDATE cursor represent.?

1 2981

Un-Answered Questions { Databases }

Differentiate CHAR_LENGTH and LENGTH?

1043

Is subquery faster than join?

1063

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

2190

What is the difference between oracle and postgresql?

1007

in the physical file layout, where should the transaction log be stored in relation to the data file?

1044

Tell us something about heap tables?

1048

Define a cross join?

1084

How to raise user-defined exception with custom sqlerrm ?

1182

What is the difference between integer and long integer in access?

971

How can I combine multiple rows into a comma-delimited list in oracle?

1119

What is the role of a limit in a mysql query?

1055

How many null values we can have in a unique key field in sql server?

1012

What does pl sql stand for?

1156

How do I become an administrator?

621

How can I see all tables in sql?

1148

For More Un-Answered { Databases } Questions Click Here