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

Mention what are different methods to trace the pl/sql code?

1227

What problem one might face while writing log information to a data-base table in pl/sql?

1178

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1160

What is the plv (pl/vision) package offers?

1066

What is the function that is used to transfer a pl/sql table log to a database table?

1033

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1019

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1005

How can you save or place your msg in a table?

1009

What are the benefits of pl/sql packages?

1120

What are different methods to trace the pl/sql code?

1136

What pl/sql package consists of?

1101

What does plv msg allows you to do?

1154

Mention what is the plv (pl/vision) package offers?

1122

What is the use of function "module procedure" in pl/sql?

1212

When you have to use a default "rollback to" savepoint of plvlog?

1215

Un-Answered Questions { Databases }

What is SKM and when we will use this SKM?

691

How do I start mysql server?

913

What is oracle block? Can two oracle blocks have the same address?

1028

What are different types of indexes?

1023

How does mongodb replica set work?

How does one load ebcdic data? : aql loader

1192

What is bcnf standard form in dbms?

1045

Can you please explain the difference between primary keys and foreign keys?

1132

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1466

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2042

What is the name of reporting services config file and what’s it’s used for?

149

Differentiate between delete and truncate.

1074

What is difference between Datepart() and Datename() in SqlServer?

1218

What is Transparent Data Encryption?

1018

Discuss row chaining, how does it happen? How can you reduce it?

550

For More Un-Answered { Databases } Questions Click Here