In multi-version concurrency control (MVCC), each transaction sees a _______ snapshot of the database.
- Consistent
- Current
- Historical
- Isolated
In multi-version concurrency control (MVCC), each transaction sees a historical snapshot of the database. This means that each transaction sees a version of the database as it existed at the start of the transaction, ensuring consistency and isolation.
Your team is working on a project where images are a significant part of the content. How would you optimize image loading to improve overall website performance?
- Compress images without significant quality loss
- Implement lazy loading
- Use responsive images with the srcset attribute
- Utilize Content Delivery Networks (CDN)
Using responsive images with the srcset attribute allows the browser to select the most appropriate image based on the user's device, improving performance. It tailors the image delivery to the user's screen size and resolution.
The command "git log --graph" displays a _______ representation of the commit history.
- Graphical
- Tabular
- Text-based
- Visual
The command "git log --graph" displays a text-based representation of the commit history with a graphical structure. It helps visualize the branching and merging of commits in a more readable format.
Which tab in Browser Developer Tools is used to inspect and manipulate HTML and CSS?
- Console
- Elements
- Network
- Sources
The 'Elements' tab in Browser Developer Tools is used to inspect and manipulate HTML and CSS. It provides a visual representation of the document's structure, allowing developers to view and modify the HTML and CSS code.
Minifying _______ and _______ files can significantly reduce load times by removing unnecessary characters.
- HTML and CSS
- JavaScript and CSS
- JavaScript and HTML
- XML and JSON
Minifying JavaScript and CSS files involves the process of removing unnecessary characters such as white spaces and comments. This reduces the file size, leading to faster load times for web pages.
What does SQL stand for?
- Sequential Query Language
- Simple Query Language
- Standard Question Language
- Structured Query Language
SQL stands for Structured Query Language. It is a domain-specific language used to manage and manipulate relational databases.
CSS preprocessors like _______ and _______ provide features to streamline responsive design workflows.
- AJAX, JSON
- Bootstrap, Foundation
- SASS, LESS
- jQuery, Angular
CSS preprocessors such as SASS and LESS are widely used in the industry to enhance and streamline responsive design workflows. They offer features like variables, mixins, and nesting that facilitate more efficient and maintainable stylesheets.
What is the primary difference between SQL and NoSQL databases?
- Both SQL and NoSQL databases have the same structure.
- SQL databases are faster than NoSQL databases.
- SQL databases are non-relational and use a flexible schema. NoSQL databases are relational and use a structured schema.
- SQL databases are relational and use a structured schemNoSQL databases are non-relational and use a flexible schema.
The primary difference is that SQL databases are relational and have a structured schema, while NoSQL databases are non-relational and use a flexible schema, allowing for easier scalability and handling of unstructured data.
Continuous Deployment refers to the automatic release of changes to _______.
- development
- production
- staging
- testing
Continuous Deployment refers to the automatic release of changes to the production environment. It involves automatically deploying code changes to the live environment after passing all necessary tests.
In data migration, what is meant by "ETL"?
- Enhance, Transfer, Load
- Enhance, Transform, Link
- Extract, Transfer, Link
- Extract, Transform, Load
"ETL" stands for Extract, Transform, Load in data migration. It is a process that involves extracting data from source systems, transforming it into a suitable format, and loading it into a target system for analysis or storage.