Assetsoft Consulting Database Developer Interview Questions and Answers

Q1. What are fear that you overcome
Add your answer

Python coding test that was baasic included panadas framework

Q1. Behavioural round
Add your answer

I have agreep on python basic

Aptitude , reasoning, general 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...read more
Answered by AI
Add your answer
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,
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
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.
Answered by AI
Add your answer

Q1. Basic questions
Add your answer

Q1. Asking over past experience
Add your answer
Q2. RAC and GG related questions. Data guard gap resolve. RMAN scenario based question. Oracle architecture.
Add your answer

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 ...read more
Answered by AI
Add your answer

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...read more
Answered by AI
Add your answer

Q1. What is dba, explain the architecture of dba
Ans. 
DBA stands for Database Administrator. The architecture of DBA involves managing and maintaining databases to ensure data integrity and security.
• DBA is responsible for installing, configuring, and upgrading database software.

• They monitor database performance and troubleshoot issues.

• DBA designs and implements backup and recovery strategies to prevent data loss.

• They also manage user access and security permissions within...read more
Answered by AI
Add your answer
Q2. How you will maintain the database and what are the types of backup
Ans. 
Maintaining the database involves regular monitoring, performance tuning, applying patches, and ensuring backups are taken regularly.
• Regularly monitor database performance and usage

• Perform routine maintenance tasks such as applying patches and updates

• Take regular backups to ensure data integrity and disaster recovery

• Implement security measures to protect the database from unauthorized access

• Optimize database performanc
Answered by AI
Add your answer

Q1. What are fear that you overcome
Add your answer

Python coding test that was baasic included panadas framework

Q1. Behavioural round
Add your answer

Q1. What is CAP theorem What is column families What function are used in cassandra what is key value pair
Ans. 
CAP theorem states that in a distributed system, it is impossible to simultaneously guarantee consistency, availability, and partition tolerance.
• CAP theorem: Consistency, Availability, Partition tolerance - pick two

• Column families: A way to organize data in NoSQL databases like Apache Cassandra

• Functions in Cassandra: read, write, delete, update

• Key value pair: Basic data structure where each key is associated with a val
Answered by AI
Add your answer
Q2. What is Cloumn families
Ans. 
Column families are a way to organize related data in a NoSQL database, grouping columns together for efficient retrieval.
• Column families are a way to group related columns together in a NoSQL database.

• They are used in databases like Apache Cassandra to organize data efficiently.

• Column families can contain a large number of columns, each with a unique name and value.

• They are stored together on disk for faster retrieval...read more
Answered by AI
Add your answer
Q3. What are the functions in cassandra
Ans. 
Cassandra functions are used for data manipulation and retrieval in Cassandra database.
• Aggregate functions like COUNT, SUM, AVG, MIN, MAX

• Date and time functions like NOW, DATEOF, UNIXTIMESTAMP

• Mathematical functions like ABS, CEIL, FLOOR, SIN, COS

• String functions like LENGTH, SUBSTRING, CONCAT, LOWER, UPPER
Answered by AI
Add your answer
Q4. Fundamentels of cassandra
Ans. 
Cassandra is a distributed NoSQL database management system designed for handling large amounts of data across multiple servers.
• Cassandra is a highly scalable and fault-tolerant database system.

• It is based on a distributed architecture, with data spread across multiple nodes.

• Cassandra uses a masterless design, where all nodes are equal and can handle read and write requests.

• It uses a partitioning strategy called consis...read more
Answered by AI
Add your answer
Q5. What is key value pair
Ans. 
Key value pair is a data structure where each key is associated with a corresponding value.
• Key value pairs are commonly used in dictionaries, hash tables, and JSON objects.

• Keys are unique identifiers that are used to access the corresponding values.

• Examples include 'name: John', 'age: 30', 'city: New York'.
Answered by AI
Add your answer