Comcast Technical Architect Interview Questions and Answers

Basic aptitude and graduation based OS, CN, DAA and DBMS questions

Q1. Psychological warfare, to be honest
Add your answer

Q1. Questions on DBMS, CN and DAA
Add your answer

Q1. Project discussion
Add your answer
Q2. Hooks concept questions
Add your answer

Nodejs assignment was given

Q1. C# abstraction and encapsulation
Add your answer
Q2. Reflection and indexers in c#
Ans. 
Reflection and indexers in C#
• Reflection allows inspecting and manipulating metadata of types, objects, and assemblies at runtime

• Indexers provide a way to access elements of a class or struct using array-like syntax

• Reflection can be used to dynamically access and invoke indexers
Answered by AI
Add your answer
Q3. Difference between ienumerable and iqueryable
Ans. 
IEnumerable is read-only and forward-only while IQueryable is queryable and can be filtered.
• IEnumerable is used for in-memory collections while IQueryable is used for querying databases.

• IQueryable is more efficient for large datasets as it allows for server-side filtering.

• IQueryable extends IEnumerable and adds additional functionality for querying data sources.

• Example: IEnumerable numbers = new List { 1, 2, 3 }; IQuer...read more
Answered by AI
Add your answer
Q4. Difference between rank and dense rank in c#
Ans. 
Rank assigns unique numbers to each distinct value, while dense rank assigns consecutive numbers to each distinct value.
• Rank and DenseRank are used to assign a unique number to each distinct value in a sorted list.

• Rank assigns a unique number to each distinct value, but leaves gaps for ties.

• DenseRank assigns consecutive numbers to each distinct value, without leaving gaps for ties.

• In C#, Rank and DenseRank are availabl...read more
Answered by AI
Add your answer
Q5. Difference between function and Stored procedure
Add your answer
Q6. Difference between clustered and non clustered index
Ans. 
Clustered index determines the physical order of data in a table, while non-clustered index has a separate structure.
• Clustered index sorts and stores the data rows in the table based on their key values, while non-clustered index has a separate structure that contains the key values and a pointer to the data row.

• A table can have only one clustered index, while it can have multiple non-clustered indexes.

• Clustered index ...read more
Answered by AI
Add your answer
Q7. Difference between execute scalar and execute nonquery
Ans. 
ExecuteScalar returns single value while ExecuteNonQuery does not return any value.
• ExecuteScalar is used for retrieving a single value from the database, such as a count or sum.

• ExecuteNonQuery is used for executing SQL statements that do not return any value, such as INSERT, UPDATE, DELETE.

• ExecuteScalar returns the first column of the first row of the result set, while ExecuteNonQuery returns the number of rows affecte...read more
Answered by AI
Add your answer

Q1. Design pattern and basics
Add your answer
Q2. Java spring boot
Add your answer
Q3. Microservice architecture
Add your answer
Q4. Database architecture
Add your answer
Q5. Low level diagram
Ans. 
A low level diagram is a detailed representation of a system's components and their interactions.
• Low level diagrams show the specific details of how components interact within a system

• They often include detailed information such as data flow, control flow, and dependencies

• Examples include UML diagrams, network diagrams, and flowcharts
Answered by AI
Add your answer

Q1. What is the use of ref?
Ans. 
The 'ref' keyword in C# is used to pass arguments by reference instead of by value.
• Allows a method to modify the value of the argument passed to it

• Useful when you want to update the original value of a variable inside a method

• Can be used with value types and reference types

• Example: void UpdateValue(ref int num) { num = 10; }

• Example: int value = 5; UpdateValue(ref value); // value will be 10 after the method call
Answered by AI
Add your answer
Q2. What are React Hooks
Ans. 
React Hooks are functions that let you use state and other React features without writing a class.
• React Hooks were introduced in React 16.8.

• They allow you to use state and other React features in functional components.

• Some commonly used React Hooks are useState, useEffect, useContext, etc.

• Hooks are more lightweight and easier to understand compared to class components.
Answered by AI
Add your answer

Q1. What is functional testing
Add your answer
Q2. What is agile process
Add your answer