Cloudangles Microsoft Dynamics CRM Developer Interview Questions and Answers

Q1. You have a hotel and how will you create a complete schema for hotel
Ans. 
To create a complete schema for a hotel, you need to consider various entities like rooms, guests, reservations, staff, amenities, etc.
• Entities to include: rooms, guests, reservations, staff, amenities, invoices, payments

• Relationships between entities: guest stays in a room, staff manages reservations, amenities are available in rooms

• Attributes for each entity: room number, guest name, reservation date, staff ID, ameni...read more
Answered by AI
Add your answer

Q1. Explain joins in SQL
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• ...read more
Answered by AI
Add your answer
Q2. What are object and class in OOPs?
Ans. 
Objects are instances of classes in OOPs. Classes are blueprints for creating objects with attributes and methods.
• Objects are instances of classes

• Classes are blueprints for creating objects

• Classes define attributes and methods for objects

• Example: Class 'Car' with attributes like 'color' and methods like 'drive'
Answered by AI
Add your answer

What is javascripts, html and css

Apti round took place in online mode but it is not proctored

This one is technical GD and shortlisted people will be divided into batches and will asked technical qns for which ppl has to answer

People who got shortlisted will be having another technical GD and the same process will be continued

Q1. 1.What is paging? Ans: it is used by Operating system to page the process
Ans. 
Paging is a memory management technique used by the operating system to store and retrieve data from secondary storage.
• Paging divides the memory into fixed-size pages and stores them in secondary storage.

• When a process needs a page, the operating system retrieves it from secondary storage and loads it into memory.

• Paging allows for efficient use of memory and helps prevent fragmentation.

• Examples of operating systems tha...read more
Answered by AI
Add your answer
Q2. 2.what is the best sorting algorithm? Ans: Quick sort since it will be using the address of the variable,no additional memory is needed
Add your answer
Q3. 3.what are all the various searching methods? Ans: BFS,DFS,binary search,linear search
Ans. 
Various searching methods include BFS, DFS, binary search, and linear search.
• BFS (Breadth-First Search) explores all the vertices at the same level before moving to the next level.

• DFS (Depth-First Search) explores as far as possible along each branch before backtracking.

• Binary search is a divide and conquer algorithm that searches a sorted array by repeatedly dividing the search interval in half.

• Linear search checks ea...read more
Answered by AI
Add your answer
Q4. 4.How does quick sort works? Ans: Quick sort works by having a pivot element and sorts by divide and conquer
Ans. 
Quick sort works by selecting a pivot element and sorting the array by divide and conquer.
• Select a pivot element from the array

• Divide the array into two sub-arrays, one with elements smaller than the pivot and the other with elements greater than the pivot

• Recursively apply the above steps to the sub-arrays

• Combine the sorted sub-arrays to get the final sorted array
Answered by AI
Add your answer
Q5. 5.What is Min heap and Max heap Ans: Heap in which the root element or parent node is larger than the child it is called Max heap and vice viresa is called Min heap
Ans. 
Max heap has the largest element at the root while Min heap has the smallest element at the root.
• Max heap is a complete binary tree where the parent node is greater than or equal to its child nodes.

• Min heap is a complete binary tree where the parent node is less than or equal to its child nodes.

• Heaps are commonly used in sorting algorithms like Heap Sort and Priority Queues.

• Insertion and deletion operations in heaps ta...read more
Answered by AI
Add your answer

OOPS , DBMS , OS , and DSA concepts

Q1. DBMS related concepts
Add your answer
Q2. Networking and Network Security
Add your answer

Os,c,ds,aptitude(quants and logical)