G2 Technology Solutions Interview Questions and Answers

Q1. What is deadlocking in SQL
Ans. 
Deadlocking in SQL occurs when two or more transactions are waiting for each other to release locks, causing them to be stuck indefinitely.
• Deadlocking happens when two transactions each have a lock on a resource that the other transaction needs.

• It can lead to a situation where neither transaction can proceed, causing a deadlock.

• Deadlocks can be resolved by setting appropriate isolation levels, using timeouts, or redesi
Answered by AI
Add your answer
Q2. What is fact and dimension
Ans. 
Facts are measurable data points while dimensions provide context to the facts in a data model.
• Facts are quantitative data that can be measured or counted.

• Dimensions provide context to the facts and are descriptive attributes that help categorize or filter the data.

• For example, in a sales data model, the fact could be total revenue while dimensions could include product category, region, and time period.
Answered by AI
Add your answer

Q1. Ruby Patterns, DB, Perfomance Related
Add your answer
Q2. Design Patterns
Add your answer
Q3. System Design for the Scenario
Ans. 
Design a system for handling user authentication and authorization in a web application.
• Use OAuth for authentication to allow users to log in using their existing accounts from providers like Google, Facebook, etc.

• Implement role-based access control (RBAC) for authorization to define different levels of access for different users.

• Store user credentials securely using hashing algorithms like bcrypt.

• Use JSON Web Tokens (...read more
Answered by AI
Add your answer
Q4. Normalization and denormalization
Add your answer
Q5. Associations/relations in rails
Ans. 
Associations/relations in Rails refer to the way different models are connected to each other.
• Rails associations are used to define relationships between different models in a Rails application.

• There are different types of associations in Rails such as belongs_to, has_one, has_many, and has_and_belongs_to_many.

• Associations are defined using ActiveRecord macros in the model files.

• For example, a User model may have many ...read more
Answered by AI
Add your answer

Q1. Css basic like box model z index
Add your answer
Q2. Html js basic like tags
Add your answer

FRD preparation based on the provided case study