You're designing a database for an e-commerce platform. What factors would you consider when choosing between MySQL and PostgreSQL as the database management system?

  • Scalability and Performance
  • Data Integrity and Concurrency
  • Community Support and Licensing
  • Transaction Isolation and ACID Compliance
When choosing between MySQL and PostgreSQL, factors like scalability, performance, data integrity, concurrency, community support, licensing, and adherence to transaction isolation and ACID compliance are crucial. The correct option emphasizes scalability and performance considerations.

Angular follows the _______ architecture for building applications.

  • MVA (Model-View-Adapter)
  • MVC (Model-View-Controller)
  • MVVM (Model-View-ViewModel)
  • MVW (Model-View-Whatever)
Angular follows the MVC (Model-View-Controller) architecture for building applications. It separates the application into three interconnected components to enhance modularity and maintainability.

MongoDB stores data in _______ format.

  • BSON (Binary JSON)
  • CSV
  • JSON
  • XML
MongoDB stores data in BSON (Binary JSON) format. BSON is a binary representation of JSON-like documents and is the primary data storage format used by MongoDB.

Which attribute is used to provide an alternative text for an image in HTML?

  • alt
  • href
  • src
  • title
The alt attribute is used to provide alternative text for an image in HTML. This text is displayed if the image file cannot be loaded or if the user is using a screen reader. It is important for accessibility and SEO purposes.

Which database indexing technique helps in optimizing query performance by storing data in a sorted order?

  • Bitmap Index
  • Clustered Index
  • Non-clustered Index
  • Unique Index
A Clustered Index is a database indexing technique that helps in optimizing query performance by storing data in a sorted order based on the indexed columns. This physical ordering of data on the disk allows for faster retrieval of rows, especially when queries involve range-based searches or sorting. However, it's important to note that a table can have only one clustered index.

The "git branch" command is used to _______.

  • Create a new branch
  • Delete a branch
  • List all branches
  • Merge branches
The "git branch" command, when used without any additional arguments, lists all existing branches in the Git repository. It's a handy command to see the available branches and the currently active branch.

Which of the following is a server-side language commonly used for web development?

  • CSS
  • HTML
  • JavaScript
  • PHP
PHP is a server-side scripting language commonly used for web development. It allows developers to create dynamic web pages and interact with databases on the server side.

What command is used to stage files for committing in Git?

  • git add
  • git commit
  • git push
  • git stage
The command used to stage files for committing in Git is git add. This command adds changes to the staging area, preparing them for the next commit. It allows for selective committing of changes.

What does SDLC stand for?

  • Software Development Life Cycle
  • Structured Design and Life Cycle
  • System Design and Life Cycle
  • Systematic Development Life Cycle
SDLC stands for Software Development Life Cycle. It is a systematic process for planning, creating, testing, deploying, and maintaining information systems.

Which AWS service is used for serverless computing?

  • AWS Lambda
  • Amazon EC2
  • Amazon RDS
  • Amazon S3
AWS Lambda is the AWS service used for serverless computing. It allows developers to run code without provisioning or managing servers. It's a cost-effective way to build applications that respond to events and scale automatically.