adspace




Databases Interview Questions
Questions Answers Views Company eMail

What is a Database Schema and Why is It Important?

1 2495

Explain the Difference Between a Primary Key and a Foreign Key.

1 2065

What is CRUD Operations?

1 2076

What are the Different Types of Joins and How do They Work?

1 2304

How to Ensure Data Integrity in a Relational Database?

2270

Explain the Difference Between OLTP and OLAP Databases.

1 2568

What are the ACID Properties in a Database and Why are They Important?

1 2488

Describe the Process of ETL (Extract, Transform, Load).

1 2398

What is a Data Warehouse and How is it Different from a Traditional Database?

1 2355

10 How to Handle Data Migration Between Different Databases?

1 2509

What is a Relational Database and How does it Differ from a NoSQL Database?

1 3322

Explain the Importance of Data Normalization.

1 1031

How to Perform Data Cleaning and Preprocessing?

1 3278

What are the Common SQL Functions Used for Data Aggregation?

1 3141

Describe the Process of Connecting a Database to a Data Analysis Tool.

1 3215


Un-Answered Questions { Databases }

How to define array in mongoose schema?

78


What is normalization and what are the advantages of it?

1068


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?

1854


How to Change a users password from unix shell.

1228


Can we use distinct and group by together?

1148


Is it possible to have clustered index on separate drive from original table location?

1051


Any work done in oracle workflow builder. Did you customize or build a new workflow?

57


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1223


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1085


What is clustered index

1100


Does group by remove duplicates?

1122


Were you involved in any data conversion, which one?

69


what is dbms? : Sql dba

1072


what are all the common sql function? : Sql dba

1143


What are the advantages of database?

1025