Which SQL command is used to add a new row to a database table?
- ADD
- INSERT
- MODIFY
- UPDATE
The INSERT SQL command is used to add a new row to a database table. It allows you to insert data into a specified table.
What is a common language used for defining infrastructure as code?
- HTML
- JSON
- XML
- YAML
JSON (JavaScript Object Notation) is a common language used for defining infrastructure as code. It is a lightweight and human-readable data interchange format, making it well-suited for configuration files. YAML is another popular choice for its simplicity and readability in configuration management.
Which cloud platform offers services like Google Compute Engine and Google Kubernetes Engine?
- Amazon Web Services (AWS)
- Google Cloud Platform (GCP)
- IBM Cloud
- Microsoft Azure
Google Cloud Platform (GCP) offers services like Google Compute Engine (IaaS) and Google Kubernetes Engine (Container Orchestration). GCP provides a range of cloud services and is known for its data analytics and machine learning capabilities.
Which principle suggests that infrastructure changes should be reversible?
- Consistency
- Idempotency
- Immutability
- Reversibility
The principle of reversibility suggests that infrastructure changes should be reversible. This means that any changes made to the infrastructure can be rolled back, providing a safety net in case of errors or unexpected issues.
In Agile methodology, what is the primary focus of the sprint retrospective?
- Continuous Improvement
- Daily Standup
- Product Backlog Refinement
- Sprint Planning
The primary focus of the sprint retrospective in Agile methodology is continuous improvement. It provides a dedicated time for the team to reflect on the just-concluded sprint, identify what went well, what could be improved, and collaboratively implement changes for the next sprint.
You're tasked with implementing a many-to-many relationship between two tables in a database. How would you achieve this using SQL?
- Create a Junction Table
- Use Foreign Keys and Triggers
- Implement Subqueries
- Utilize Views and Stored Procedures
To implement a many-to-many relationship in a database, creating a Junction Table is a common approach. This involves creating a separate table to represent the relationship between the two entities. The correct option suggests using a Junction Table.
When considering data migration, what is the significance of data mapping?
- Defining migration tools
- Estimating migration time
- Matching source and target data structures
- Verifying data integrity
Data mapping in data migration is significant for matching source and target data structures. It involves defining how data from the source system maps to the target system, ensuring a smooth and accurate migration process.
In Git, a merge conflict occurs when two branches have made changes to the _______ lines of code in a file.
- Different
- Important
- Same
- Specific
A merge conflict in Git arises when two branches have made changes to the same lines of code in a file. Git cannot automatically merge these changes, requiring manual resolution.