Sql Operation

Memory updated
I’ll provide AWS interview questions tailored to 1 year of experience, along with topics like SQL operations, Express middleware, EventEmitter, Clustering, Streams, Normalization, Partitioning, Replication, Sharding, Indexing, and performance optimization for JavaScript and databases.

AWS Interview Questions (1-Year Experience)

1. AWS Basics What is AWS, and how does it work? What are the core AWS services? What is IAM (Identity and Access Management)? What are EC2, S3, and RDS? What is an AWS Region and Availability Zone?
2. Compute & Storage What is the difference between EC2 and Lambda? What is Auto Scaling in AWS? What is the difference between EBS (Elastic Block Storage) and S3? What are the different storage classes in S3? How does AWS CloudFront work?
3. Database & Networking What is Amazon RDS, and how is it different from DynamoDB? What is a VPC (Virtual Private Cloud)? What is AWS Route 53? What is an Elastic Load Balancer (ELB)? What are security groups and network ACLs?
4. Serverless & Monitoring What is AWS Lambda, and how is it used? What is Amazon CloudWatch used for? What is AWS SNS (Simple Notification Service)? What is AWS SQS (Simple Queue Service)? What is AWS CloudFormation? SQL Operations What are JOIN types in SQL? (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN) What are stored procedures, and why are they used? What is the difference between HAVING and WHERE? What is a primary key and a foreign key? What is the difference between GROUP BY and ORDER BY? What is an index, and how does it improve performance? How do you optimize SQL queries? What is a database transaction, and what are ACID properties? What is normalization, and what are its types (1NF, 2NF, 3NF, BCNF)? What is partitioning in databases, and how does it work?