Hogarth Worldwide Senior Digital Designer Interview Questions and Answers

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Q1. Your tech related questions
Add your answer

MCQs on hdfs, sql and spark. One data structures coding test

Q1. Kafka architecture
Add your answer
Q2. HDFS namenode features
Add your answer

Q1. Oops concepts, angular, SQL, design patterns questions
Add your answer

Q1. Scenario based technical questions design patterns n real world problems
Add your answer

Q1. Casual discussion on compensation
Add your answer

Q1. Explain oops concepts, difference b/w abstraction and interface,MVC architecture,stored procedure,joins
Ans. 
OOPs concepts, abstraction vs interface, MVC architecture, stored procedures, joins
• OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction

• Abstraction is hiding the implementation details while interface is a contract that defines the methods that a class must implement

• MVC architecture separates the application into Model, View, and Controller components for better organization and maintenance

• Sto...read more
Answered by AI
Add your answer

SQL queries, ddl,dml TCL commands, primary key and foreign key differences,what is composite key,hash table in c#,generics in c#.

Q1. Salary discussion,
Add your answer

Q1. Question based on your experience. Mine was mostly design questions on AWS and how to use try and catch
Add your answer
Q2. Javascript using async/await with try catch block
Ans. 
Using async/await with try catch block in Javascript
• Use async keyword before the function declaration to make it asynchronous

• Use await keyword before the function call to wait for the promise to resolve

• Wrap the async/await code in a try catch block to handle errors
Answered by AI
Add your answer

Q1. Technical with design questions on web technology
Add your answer