Q11. What is the difference between a star schema and a snowflake schema?
Both are dimensional models. A star schema has one central fact table surrounded by denormalized dimension tables. Each dimension is a single table, so joins stay simple ...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (34 available).
Active:
Tag: ll ×
Q12. What does Babel do and how does it relate to bundlers?
Babel is a JavaScript compiler that transforms modern syntax into code older environments can run. It parses source into an AST, applies plugins that each handle a transf...
Q13. Explain equals and hashCode contract.
Rules: - If a.equals(b) is true then a.hashCode() == b.hashCode() must be true. - If two objects are unequal, their hash codes may still collide (allowed). - equals must ...
Q14. Walk me through how you would model a business process.
I model a process to create a shared, accurate picture of how work actually flows, not how people think it flows. I start by defining the scope and boundaries, where it b...
Q15. Compare top-down and bottom-up parsing.
Parsing turns tokens into a parse tree. Two broad families exist. Top-down parsers start at the root and predict productions. Recursive descent, and its table-driven form...
Q16. How does the Java memory model and garbage collection work?
Memory is divided into heap (shared objects) and per-thread stacks (frames, locals). The heap has a young generation (Eden plus two survivor spaces) and an old generation...
Q17. Explain precision and recall and when to prefer each.
Precision is the fraction of predicted positives that are truly positive: TP / (TP + FP). Recall, or sensitivity, is the fraction of actual positives that were found: TP ...
Q18. Explain canary deployments.
A canary releases the new version to a small slice of traffic before a full rollout. Process: 1. Deploy the new version alongside the stable one. 2. Route a small percent...
Q19. Explain VPC networks and firewall rules in GCP.
A GCP VPC is a global, software-defined network. Subnets are regional, and instances in different regions can communicate over the internal network. - VPC networks come i...
Q20. If all roses are flowers and some flowers fade quickly, can we conclude some roses fade quickly?
No. The premises are: - All roses are flowers (roses are a subset of flowers). - Some flowers fade quickly (a non-empty overlap exists between flowers and things that fad...