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 anonymous block in sql?

1 1187

What is dml statement?

1 1018

Can we call dml statement in function?

1 1122

What is cursor in pl sql with examples?

1 1115

Is sql a programming?

1 1048

Can we use ddl statements in stored procedure sql server?

1 1079

What is set serveroutput on?

1 1204

What is the use of %rowtype?

1 1109

How to write pl sql program in mysql command prompt?

1 1185

Which type of cursor is used to execute the dml statement?

1 1021

What is pl sql record in oracle?

1 1113

Why do we need pl sql?

1 1047

How long does it take to learn pl sql?

1 1127

What is rowtype?

1 1088

What is dml and ddl?

1 1028

Un-Answered Questions { Databases }

Suppose database is running slow, what will you do?

2586

Which statement is used in a select query for partial matching?

1237

What is the difference between case version and decode version?

1097

What are the two main functions of queries in databases?

1518

What are the types of database explain each of them briefly?

1042

What are the different subsets of sql?

1641

what is bcp? When does it used? : Sql dba

1051

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

What are different types of constraints?

988

Is there some bulk load or other way to import a lot of data fast?

925

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1938

Can you index views?

951

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1059

what are all the common sql function? : Sql dba

1120

Have you created fact table and dimension tables?

696

For More Un-Answered { Databases } Questions Click Here