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

What is out parameter used for eventhough return statement can also be used in pl/sql?

1088

What packages are available to pl/sql developers?

1070

What does the base_object_type column shows in the user.triggers data dictionary view?

1057

What are the rules to be applied to nulls whilst doing comparisons?

1330

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1175

Explain two virtual tables available at the time of database trigger execution.

1 1681

What are database links used for?

1052

What are the uses of merge?

1172

How is a process of pl/sql compiled?

1172

Is it possible to create the following trigger: before or after update trigger for each row?

1296

Differentiate between syntax and runtime errors.

1197

What is an intersect?

1111

What is the difference between alter trigger and drop trigger statements?

1117

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1025

How would you convert date into julian date format?

1010

Un-Answered Questions { Databases }

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

543

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2245

How to use values from other tables in update statements in ms sql server?

1124

What is a postgres server?

935

How to store binary data in mysql?

1006

How do you create access?

898

What is the purpose of the partition table?

1049

Define transaction and transaction isolation levels?

991

What is the main difference between sql and pl/sql?

1105

How can you export the table as an xml file in mysql?

892

what are the differences between binary and varbinary? : Sql dba

1049

How do I update a variable in mysql?

947

What do you understand by a view? What does the with check option clause for a view do?

1010

What is scalar function?

1058

What are the features of database language?

1044

For More Un-Answered { Databases } Questions Click Here