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 will you get by the cursor attribute sql%notfound?

1 1156

What is the use of pl/sql table?

1 1134

What is pl/sql table? Why it is used?

1 1097

What is the difference between the implicit and explicit cursors?

1 1137

Write a unique difference between a function and a stored procedure.

1 1067

What is the usage of when clause in trigger?

1 1123

Which command is used to delete a package?

1 1270

What is a trigger in pl/sql?

1 1819

What are the different schemas objects that can be created using pl/sql?

1 1106

What is the maximum number of triggers, you can apply on a single table?

1 1069

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1 1172

What is the main reason behind using an index?

1 1085

Explain the commit statement.

1 1240

Explain the rollback statement?

1 1088

What is exception? What are the types of exceptions?

1 1143

Un-Answered Questions { Databases }

how to escape special characters in sql statements? : Sql dba

1113

Who proposed the relational model?

1029

How to export data from database and import into another?

995

Can one drop a column from a table?

1083

how to start mysql server? : Sql dba

1265

What is the current version of postgresql?

1174

How to connect php with different port numbers?

1181

How to convert character strings into numeric values?

1187

Is microsoft getting rid of access?

885

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

1057

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1847

What is the difference between upgrade and migration in sql server?

1180

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2293

Can we do dml on views?

1032

For More Un-Answered { Databases } Questions Click Here