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 data manipulation language? : Sql dba

1073

what is innodb? : Sql dba

1182

what are numeric data types? : Sql dba

1117

what is 'mysqld'? : Sql dba

1030

explain the options of myisamchk to improve the performance of a table. : Sql dba

1079

how many values can the set function of mysql take? : Sql dba

1048

what is myisam? : Sql dba

1176

what is recursive stored procedure? : Sql dba

1036

what is foreign key? : Sql dba

1113

what are the different type of normalization? : Sql dba

1083

how many sql ddl commands are supported by 'mysql'? : Sql dba

1076

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1015

explain advantages of myisam over innodb? : Sql dba

1131

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1062

how can we repair a mysql table? : Sql dba

1048

Un-Answered Questions { Databases }

Can a foreign key be a duplicate?

971

What are the uses of database management system?

1068

Define the mongodb aggregation?

How you can minimize the deadlock situation?

1094

According to you what goes into making the best database administrator? : sql server database administration

1031

How do I remove all records from a table?

1125

What is a database in business?

1012

How can you list all the columns in a database?

979

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1899

What is sparse columns of sql server 2008?

1103

Explain system rowset functions?

1053

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

661

How to create a table index?

1241

what is ora 24313?what is the procedure to exclude that error?

2623

How many categories of data types?

1047

For More Un-Answered { Databases } Questions Click Here