Database Interview Questions and Answers
Question - 61 : - What do you understand by database testing?
Answer - 61 : -
Database testing is also known as backend testing and features three categories:
- Testing of data integrity and validity
- Performance of database
- Testing of procedure, functions, and triggers
Question - 62 : - What do you understand by a data-driven test?
Answer - 62 : -
The data-driven test checks the multiple numbers of data in a table. It replaces the parameters from distinct locations at the same time.
Question - 63 : - What do you understand about Joins? Mention the types of join
Answer - 63 : -
Joins exhibit two or more than two tables and are primarily of four types:
- Inner Join
- Outer Join and this further categorized into two types - right outer join and left outer join
- Natural Join
- Cross Join
Question - 64 : - What are indexes and their different types?
Answer - 64 : -
The database objects are indexes and are generated on columns. Different types of indexes are:
- Clustered index
- Covering index
- Bitmap index
- Unique index
- Non-unique index
- B-Tree index
Question - 65 : - How can we check SQL queries in QTP without utilizing database checkpoints?
Answer - 65 : -
We should write a scripting process in VBScript to connect with the database and test the SQL queries.
Question - 66 : - What do you understand by data modeling?
Answer - 66 : -
Data modeling involves a process of producing a visual representation of an overall information system or its part to connect structures and data points.
Question - 67 : - What are the types of design schemas in data modeling?
Answer - 67 : -
There are two types of design schemas, snowflake, and star schema, in data modeling.
Question - 68 : - What do you mean by NameNode?
Answer - 68 : -
NameNode stores information and checks multiple files across clusters. The actual data is not collected here and is stored in DataNodes.
Question - 69 : - What do you understand about Hadoop streaming?
Answer - 69 : -
It is a feature of Hadoop distribution that allows software developers to write Map-Reduce programs by utilizing various multiple programming languages such as Peal, Python, C++, etc.
Question - 70 : - What do you understand by block and block scanner in Hadoop Distributed File System?
Answer - 70 : -
Hadoop splits large files into the smallest data units, known as blocks. Block scanner checks the list of blocks available in DataNode to identify checksum errors.
Want to become a senior developer? Then consider going through the following database interview questions for senior developers.