_______ is a SQL command used to retrieve data from multiple tables simultaneously based on a specified condition.
- GROUP BY
- JOIN
- MERGE
- UNION
The JOIN command in SQL is used to retrieve data from multiple tables simultaneously based on a specified condition. It combines rows from two or more tables based on a related column.
How does "git reset" differ from "git revert"?
- git reset discards commits, and changes are lost
- git reset undoes a commit, preserving changes
- git revert discards commits, and changes are lost
- git revert undoes a commit, preserving changes
git reset discards commits and changes are lost, whereas git revert undoes a commit while preserving changes by creating a new commit that undoes the previous changes. Reset is more powerful and should be used with caution.
What are some advantages of using Gitflow over GitHub Flow?
- Centralized Workflow, Direct Commits, Fast Release Cycle
- Feature Branches, Strict Workflow, Well-defined Release Process
- Forking Workflow, Simplicity, Easy Collaboration
- Git Pull Requests, Loose Workflow, Continuous Deployment
Gitflow offers advantages such as Feature Branches for isolated development, a strict workflow for better control, and a well-defined release process, making it suitable for complex projects.
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.
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 is a composite key in Cassandra?
- A key formed by combining multiple columns
- A key formed by hashing
- Foreign key linking two tables
- Primary key of a table
In Cassandra, a composite key is formed by combining multiple columns. This key allows for more complex and flexible data modeling by including multiple attributes in the primary key.