UST Interview Questions, Process, and Tips

Spring/Spring Boot is a popular Java framework for building enterprise applications.

• Spring is a lightweight framework for building Java applications

• Spring Boot is an extension of the Spring framework that simplifies the setup and configuration of Spring applications

• Spring provides features like dependency injection, aspect-oriented programming, and more

• Spring Boot includes embedded servers like Tomcat, Jetty, etc. for ...read more

Annotations are used to provide metadata about classes, methods, or fields in an API.

• Annotations can be used to provide information about how a method should be handled, such as whether it is deprecated or should be ignored by a compiler.

• Annotations can also be used to provide information about how a class should be serialized or deserialized, such as specifying the format of JSON data.

• Examples of annotations include @...read more

RestController is used for RESTful web services while Controller is used for general web requests.

• RestController is a specialization of Controller annotation in Spring framework.

• RestController is used to create RESTful web services that return JSON or XML data.

• Controller is used for handling general web requests and returning views (HTML).

• RestController is typically used for APIs while Controller is used for traditiona

Rank assigns unique rank to each row, while dense rank assigns consecutive ranks without gaps.

• Rank leaves gaps in rank sequence if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each row based on a specified column

• Dense rank function is used to assign consecutive ranks to rows without any gaps

• Example: If there are two rows with rank 1 in a dataset, rank function will assign 1

Use Google Cloud Storage to load CSV data into BigQuery

• Upload the CSV file to Google Cloud Storage

• Create a BigQuery table with the appropriate schema

• Use the 'bq load' command to load the data from the CSV file into the BigQuery table

I have worked on automating CI/CD pipelines, infrastructure as code, and monitoring solutions.

• Automated CI/CD pipelines using tools like Jenkins, GitLab CI, or CircleCI

• Implemented infrastructure as code using Terraform or CloudFormation

• Set up monitoring solutions with tools like Prometheus, Grafana, or ELK stack

Terraform and CDK are both infrastructure as code tools used for provisioning and managing cloud resources.

• Terraform is a popular open-source tool by HashiCorp that allows you to define and provision infrastructure using declarative configuration files.

• CDK (Cloud Development Kit) is an AWS-specific tool that allows you to define cloud infrastructure using familiar programming languages like TypeScript, Python, and Java...read more

Java is a high-level programming language known for its portability and versatility. Its architecture is based on the concept of platform independence.

• Java is an object-oriented language with a syntax similar to C++.

• Java programs are compiled into bytecode that can run on any Java Virtual Machine (JVM).

• The Java architecture includes the Java Development Kit (JDK), Java Runtime Environment (JRE), and JVM.

• Java applicatio...read more

Adapting to rapidly changing technologies and requirements.

• Keeping up with new technologies and trends

• Balancing priorities and deadlines

• Managing team dynamics and conflicts

• Adapting to changing project requirements

• Ensuring scalability and maintainability of solutions

Use SQL query with ORDER BY clause to get result based on highest salary

• Use SELECT statement to retrieve data from the table

• Use ORDER BY clause with DESC keyword to sort salaries in descending order

• Use LIMIT or FETCH FIRST clause to limit the result to only one row

Bulk collect is used to fetch multiple rows into collections at once, while bulk binding is used to bind collections to SQL statements for improved performance.

• Bulk collect fetches multiple rows into collections in a single operation, reducing context switches and improving performance.

• Bulk binding binds collections to SQL statements, reducing the number of context switches between the PL/SQL engine and SQL engine.

• Bulk...read more