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 need to provide size option on create collection?

1 17

Give any 6 data types of MongoDB?

1 14

How do you display the list of all collections of current database?

1 12

What is the symbol of logical OR operation in mongodb?

1 12

What are the different methods to insert document?

1 12

What is the difference between insert() and insertOne()?

1 15

What is the syntax of update document?

1 17

Who developed MongoDB and when?

1 12

What is the exist operator?

1 15

What is the default port of mongodb server?

1 16

What is the limitations to run mongodb on 32 bits OS?

1 13

What is the difference between min key and max key?

1 12

How do you delete a document from a collection?

1 14

Define the mongodb aggregation?

1 13

What is the difference between $lt and $lte?

1 12

Un-Answered Questions { Databases }

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

1930

What is the difference between for xml raw and for xml auto?

1095

What is standby servers? Explain types of standby servers.

1067

define sql insert statement ? : Sql dba

1086

what is schema? : Sql dba

1124

What are the properties of the transaction?

1059

How to convert numeric expression data types using the cast() function?

1133

How to write a left outer join with the where clause in oracle?

1136

Where can you add custom error messages to sql server?

1190

Have you created fact table and dimension tables?

694

What is clustered index

1069

What is sql server query analyzer?

1111

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

How can you append an identity column to a temporary table?

1050

What is temporary table in sql server? Why we use temp table?

1000

For More Un-Answered { Databases } Questions Click Here