DNEG CREATIVE SERVICES IT Analyst Interview Questions and Answers

Q1. Explaining oops
Ans. 
OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPs focuses on creating objects that interact with each other to solve complex problems

• Key principles of OOPs include encapsulation, inheritance, and polymorphism

• Encapsulation allows objects to hide their internal state and require all interaction to be performed through an object's methods

• Inhe...read more
Answered by AI
Add your answer
Q2. What design pattern you used
Ans. 
I have used the Singleton design pattern in my previous projects.
• Used to ensure a class has only one instance and provides a global point of access to it

• Helps in managing global resources efficiently

• Example: Database connection manager in a web application
Answered by AI
Add your answer
Q3. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL

• Example: 'ID' column in a 'Users' table
Answered by AI
Add your answer
Q4. What is foreign key
Ans. 
Foreign key is a field in a database table that links to a primary key in another table.
• Foreign key ensures referential integrity between related tables

• It helps maintain relationships between tables

• Foreign key constraints can be used to enforce data integrity
Answered by AI
Add your answer
Q5. What is unique key
Ans. 
A unique key is a field or combination of fields in a database table that uniquely identifies each record in the table.
• A unique key ensures that no two records in a table have the same values for the specified key fields.

• It can be a single field or a combination of multiple fields.

• Unique keys are used to enforce data integrity and prevent duplicate records.

• Examples: Primary key, Unique constraint
Answered by AI
Add your answer
Q6. Different types of dbs
Ans. 
Different types of databases include relational, NoSQL, graph, and document databases.
• Relational databases store data in tables with rows and columns (e.g. MySQL, PostgreSQL)

• NoSQL databases are non-relational and can handle unstructured data (e.g. MongoDB, Cassandra)

• Graph databases use graph structures for semantic queries (e.g. Neo4j, Amazon Neptune)

• Document databases store data in documents (e.g. Couchbase, Firebase)
Answered by AI
Add your answer

Q1. Microcontroller architecture Arm, Tms320
Add your answer
Q2. Embedded C, Coding standards
Add your answer

Q1. RTOS, State machine
Add your answer
Q2. Peripherals like DMA, ADC, DAC
Add your answer

Q1. You willing to relocate to Pune
Add your answer
Q2. They ask you about family background
Add your answer

Q1. Embedded Linux internal
Add your answer
Q2. Process and thread difference
Ans. 
Processes are independent entities while threads are lightweight sub-processes within a process.
• Processes have their own memory space while threads share the same memory space within a process.

• Processes are heavyweight in terms of resources while threads are lightweight.

• Processes communicate with each other through inter-process communication mechanisms like pipes or sockets, while threads can communicate directly thro...read more
Answered by AI
Add your answer

Q1. Cpp concepts coding question
Add your answer

Q1. This was manager round, mainly on the projects I have worked before
Add your answer

Q1. Its about your project mentioned in your CV
Add your answer
Q2. System level questions, req Analysis
Add your answer

Q1. System level questions
Add your answer

Q1. Salary ,relocation
Add your answer

Q1. Questioning skills in relevant technology
Add your answer

Q1. Project related questions
Add your answer

Q1. Process and employee nature
Add your answer

Q1. Not remember it was 5Years ago
Add your answer

Q1. Not remember it was 5 year ago
Add your answer

Not remember more than 5 year ago

Not remember it was 5 year ago