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.
In SQL, the ALTER TABLE command is used to _______ an existing database table.
- Add
- Delete
- Modify
- Update
The ALTER TABLE command in SQL is used to modify an existing database table. It allows you to add, delete, or modify columns and constraints of a table.
NoSQL databases are often used in scenarios where _______.
- ACID compliance is required
- Data is highly structured
- Scalability and high-performance are crucial
- Schema is predefined
NoSQL databases are often used in scenarios where scalability and high-performance are crucial. They excel in handling large volumes of unstructured or semi-structured data with a focus on horizontal scaling.
You're working on a team project, and your feature branch diverged significantly from the main branch. Which Git command would you use to integrate your changes without creating a messy merge history?
- git merge --no-ff
- git merge --squash
- git pull --rebase
- git rebase
The correct Git command to integrate changes from a diverged feature branch without creating a messy merge history is git rebase. It helps maintain a linear and cleaner history by incorporating the changes on top of the main branch.
What does the === operator do in JavaScript?
- Assignment
- Logical AND
- Strict equality comparison
- Type coercion equality comparison
The === operator in JavaScript performs strict equality comparison, meaning it checks both value and type. It returns true if the operands are equal without performing type coercion.
Which HTTP method is typically used for creating a new resource in a RESTful API?
- DELETE
- GET
- POST
- PUT
The HTTP method used for creating a new resource in a RESTful API is POST. It submits data to be processed to a specified resource.
What is the role of alerting in a monitoring system?
- Archive historical data
- Display real-time data
- Generate reports
- Notify stakeholders about abnormal conditions
The primary role of alerting in a monitoring system is to notify stakeholders about abnormal conditions or events. Alerts enable timely responses to issues, helping in proactive troubleshooting and maintaining system reliability.
The "Application" tab in Browser Developer Tools is used for managing _______.
- Application-related resources
- Code syntax
- Memory and storage
- Network requests
The "Application" tab in Browser Developer Tools is used for managing application-related resources. It includes features for working with local storage, session storage, cookies, and other application-specific data.