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 is out parameter used for eventhough return statement can also be used in pl/sql?

1 1141

What packages are available to pl/sql developers?

1 1135

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

1 1117

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

1 1384

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

1 1249

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

1 1765

What are database links used for?

1 1124

What are the uses of merge?

1 1252

How is a process of pl/sql compiled?

1 1275

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

1 1395

Differentiate between syntax and runtime errors.

1 1261

What is an intersect?

1 1171

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

1 1187

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

1 1077

How would you convert date into julian date format?

1 1061

Un-Answered Questions { Databases }

What is a scheduled job or what is a scheduled task?

1031

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

How did mongodb get its name?

What is the current mysql version?

1089

What is your daily office routine?

2340

Can sql servers link to other servers like oracle?

910

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

1045

Have you created fact table and dimension tables?

703

Can we shrink data file in sql server?

1123

What is an indexed view?

1018

What are wait types?

1238

Does view occupy space?

1005

Can we use distinct and group by together?

1130

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

define sql insert statement ? : Sql dba

1094

For More Un-Answered { Databases } Questions Click Here