Which Git command is used to view the branches that have been merged into the current branch?
- git branch
- git branch --merged
- git log
- git merge
The git branch --merged command is used to view the branches that have been merged into the current branch. It helps identify which branches are safe to delete after merging.
In Google Cloud Platform, what service is used for big data analytics?
- BigQuery
- Cloud Storage
- Datastore
- Pub/Sub
BigQuery is the Google Cloud Platform service specifically designed for big data analytics. It enables super-fast SQL queries using the processing power of Google's infrastructure, making it suitable for analyzing large datasets.
What feature of collaboration tools allows multiple developers to work on the same codebase simultaneously without interfering with each other's changes?
- Version Control
- Code Dependency
- Code Synchronization
- Collaboration Sync
The correct option is Version Control. Version control systems, such as Git, enable multiple developers to work on the same codebase concurrently by managing changes, merging edits, and maintaining a version history. This ensures seamless collaboration without conflicts.
In Gitflow, the _______ branch is created from the master branch for emergency fixes.
- develop
- feature
- hotfix
- release
In Gitflow, the hotfix branch is created from the master branch for emergency fixes. Hotfixes are used to address critical issues in the production environment directly.
In a distributed database system, what challenges might arise in terms of consistency, and how would you address them?
- Consistency models
- Distributed transactions
- Eventual consistency
- Strong consistency
Challenges in consistency in distributed systems can be addressed through techniques like distributed transactions, ensuring data consistency across multiple nodes.
Granular recovery allows for the restoration of _______ components rather than the entire system.
- Fine-grained
- Individual
- Particular
- Specific
Granular recovery enables the restoration of specific components or data points, offering a more fine-grained approach instead of restoring the entire system. This is useful for targeted recovery needs.
What command is used to create a new branch in Git?
- git branch new-branch
- git checkout -b new-branch
- git create branch new-branch
- git new-branch
The correct command to create a new branch in Git is git checkout -b new-branch. This command creates a new branch and switches to it in one step.
In RESTful APIs, _______ is a mechanism used to control access to resources.
- Authentication
- Authorization
- Decryption
- Encryption
In RESTful APIs, Authorization is a mechanism used to control access to resources. It determines whether the authenticated user has the necessary permissions to perform a particular action on a resource.
A stored procedure is _______ in a relational database, which can be executed by invoking its name.
- a precompiled collection of one or more SQL statements
- a temporary table
- a trigger
- an index
A stored procedure in a relational database is a precompiled collection of one or more SQL statements. It is stored as a database object and can be executed by invoking its name.
Imagine a scenario where two users are trying to update the same record in a database concurrently. Describe the potential issues that may arise and propose a concurrency control strategy to address them.
- Issues: Deadlocks, Race Conditions
- Issues: Lost Updates, Inconsistent Data
- Strategy: Apply Pessimistic Locking
- Strategy: Use Timestamps for Versioning
Concurrent updates on the same database record may lead to issues such as lost updates and inconsistent data. Using timestamps for versioning is a strategy to address this, allowing the system to track and compare versions to ensure updates occur in a controlled and consistent manner, reducing conflicts.