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 the order of sql select?

1 1105

What is the difference between union and union all command?

1 1170

What are the possible values that can be stored in a boolean data field?

1 1073

How to avoid duplicate records in a query?

1 1072

How to rename a column in the output of sql query?

1 1162

What are the types of dbms?

1 1050

Describe sql comments?

1 1138

What is a record in a database?

1 1127

How to display the current date in sql?

1 1147

How to get list of all tables from a database?

1 1224

Can a table contain multiple foreign key’s?

1 1076

How to rename a table?

1 1086

What is sql not null constraint?

1 1113

What is the difference between nvl function, ifnull function, and isnull function?

1 1174

How to add a column ‘salary’ to a table employee_details?

1 1074

Un-Answered Questions { Databases }

How to export data from database and import into another?

985

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?

1841

What versions of clipper does netlib support?

1077

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2345

Why use identity in sql server?

1189

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

1045

How to select all columns of all rows from a table in oracle?

1116

Do we need to rebuild index after truncate?

1126

Can we rollback truncate?

1070

What are wait types?

1230

Disadvantages of the indexes?

1216

What are the kinds of subquery?

1093

what are the advantages of sql ? : Sql dba

1136

Is inner join faster than left join?

1271

Equi join and non equi join is possible with sql server?

1119

For More Un-Answered { Databases } Questions Click Here