Add office photos
Filter interviews by
Assetsoft Consulting Database Developer Interview Questions and Answers
Assetsoft Consulting Database Developer Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. Stored procedure vs function
- Ans.
Stored procedures are used to perform a set of actions, while functions return a single value.
Stored procedures can perform multiple actions and can return multiple result sets.
Functions are used to return a single value based on input parameters.
Stored procedures can be called independently, while functions are typically called within SQL statements.
Stored procedures can contain DML statements, while functions cannot.
- Q2. Index and its difference
- Ans.
Index is a data structure that improves the speed of data retrieval in a database.
Indexes are used to quickly locate data without having to search every row in a database table.
They can be created on one or more columns in a table.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Examples of indexes are primary keys, foreign keys, and indexes created for frequently searched columns.
Interview questions from similar companies
(2 Questions)
- Q1. How to run parallel queries for multiple databases ??
- Ans.
To run parallel queries for multiple databases, use parallel processing techniques and tools.
Use parallel processing techniques such as multi-threading or distributed computing to run queries simultaneously on multiple databases.
Consider using tools like Apache Hadoop or Apache Spark for parallel processing of queries across multiple databases.
Ensure proper resource allocation and optimization to prevent performance is...
- Q2. What is normalisation technique used for database??
- Ans.
Normalization technique is used to organize data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy by storing data in a structured and organized manner.
Normalization ensures data integrity by minimizing data anomalies such as update, insert, and delete anomalies.
There...
Interview Preparation Tips
(1 Question)
- Q1. What are fear that you overcome
Python coding test that was baasic included panadas framework
(1 Question)
- Q1. Behavioural round
akshaya maisa
Selected
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
I have agreep on python basic
Interview Preparation Tips
- Python
Aptitude , reasoning, general questions
(2 Questions)
- Q1. What is spark architecture and partitions
- Ans.
Spark architecture refers to the structure of Apache Spark framework, while partitions are units of data distribution for parallel processing.
Spark architecture includes components like Driver, Executor, and Cluster Manager
Partitions are units of data distribution for parallel processing in Spark RDDs
Increasing the number of partitions can improve parallelism and performance
Example: In Spark, data is divided into parti...
- Q2. What is rdd, trsnsformations
- Ans.
RDD (Resilient Distributed Dataset) is a fundamental data structure in Apache Spark for distributed data processing. Transformations are operations that create a new RDD from an existing one.
RDD is a fault-tolerant collection of elements that can be operated on in parallel.
Transformations are functions that produce a new RDD by applying a computation on the existing RDD.
Examples of transformations include map, filter,
(2 Questions)
- Q1. Salary expectations
- Q2. Current ctc n expected ctc
- Ans.
The current CTC (Cost to Company) and expected CTC (Cost to Company) are typically discussed during salary negotiations.
Be honest about your current salary and provide a realistic expectation for your future salary.
Consider factors such as your experience, skills, industry standards, and the company's budget when discussing CTC.
It is important to have a clear understanding of your worth and negotiate accordingly.
Skills evaluated in this interview
Oracle Database Administrator Interview Questions & Answers
Tech Mahindra
amit aman
posted on 24 Jan 2024
Selected
I applied via Referral and was interviewed before Jan 2023. There were 2 interview rounds.
(1 Question)
- Q1. Basic questions
(2 Questions)
- Q1. Asking over past experience
- Q2. RAC and GG related questions. Data guard gap resolve. RMAN scenario based question. Oracle architecture.
MS SQL Server Database Administrator Interview Questions & Answers
Atos
Anonymous
posted on 23 May 2023
Selected
I applied via Company Website and was interviewed before May 2022. There were 3 interview rounds.
(1 Question)
- Q1. What purpose does the model database server what is replication what is dcl what are the recovery models for a data base what is dbcc
- Ans.
Answers to questions related to MS SQL Server Database Administration
The model database is used as a template for creating new databases
Replication is the process of copying and distributing data from one database to another
DCL stands for Data Control Language and is used to control access to data in a database
The recovery models for a database are Simple, Full, and Bulk-Logged
DBCC stands for Database Console Commands ...
(1 Question)
- Q1. What is the importance of recovery model what is transperent data encryption explain your sql server database expirence why would you use sql agent
- Ans.
Recovery model is important for database backup and restore. Transparent data encryption secures data at rest. SQL Agent automates tasks.
Recovery model determines the type of backup and restore strategy to be used.
There are three recovery models: Simple, Full, and Bulk-Logged.
Transparent Data Encryption (TDE) encrypts data at rest and protects against unauthorized access.
TDE uses a symmetric key called the database enc...
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. What major issues have you faced in your professional experience?
(1 Question)
- Q1. What are your salary expectations for this position?
(1 Question)
- Q1. What are fear that you overcome
Python coding test that was baasic included panadas framework
(1 Question)
- Q1. Behavioural round
I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.
(2 Questions)
- Q1. Database architecture
- Q2. Database backups wal files
Interview Preparation Tips
Assetsoft Consulting Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Database Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Mysql Database Administrator Interview Questions
- SQL Server Database Administrator Interview Questions
- Data Architect Interview Questions
- Show more
People are getting interviews through
Database Developer Interview Questions from Similar Companies
|
SQL Developer
6
salaries
|  ₹4 L/yr - ₹8.2 L/yr |
|
Business Analyst
4
salaries
| ₹6.3 L/yr - ₹16 L/yr |
|
Senior SQL Developer
4
salaries
| ₹5 L/yr - ₹9.4 L/yr |
|
QA
4
salaries
| ₹6 L/yr - ₹9 L/yr |
|
Software Developer
3
salaries
| ₹14 L/yr - ₹15.1 L/yr |
Infosys
TCS
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Assetsoft Consulting Interview Questions >
- Assetsoft Consulting Database Developer Interview Questions
