Tag: science & technology

Questions Related to science & technology

Multiple choice general knowledge science & technology
  1. Cluster

  2. Client utility

  3. Engine

  4. Backup tool

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

InnoDB is a storage engine for MySQL, not a cluster, client utility, or backup tool. It has been the default storage engine since MySQL 5.5 and provides ACID-compliant transactions, foreign key support, and row-level locking. This is a fundamental MySQL architecture question.

Multiple choice general knowledge science & technology
  1. MySQL

  2. Postgres

  3. Both

  4. None of these

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MySQL supports unsigned integer datatypes like INT UNSIGNED, BIGINT UNSIGNED which allow only non-negative values and effectively double the positive range. PostgreSQL does not have native unsigned integer types - it uses signed integers with CHECK constraints for similar functionality.

Multiple choice general knowledge science & technology
  1. MySQL

  2. Oracle

  3. Both of these

  4. None of these

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle's MVCC is a core feature built into its architecture, providing non-locking reads and write consistency. MySQL's InnoDB storage engine also implements MVCC, but the question is likely testing knowledge that Oracle is synonymous with MVCC while MySQL requires specific storage engines.

Multiple choice general knowledge science & technology
  1. YES

  2. NO

  3. Cannot predict

  4. Not applicable

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

MySQL is not 100% ACID compliant because ACID properties depend on the storage engine being used. Only InnoDB provides full ACID compliance with transactions, foreign keys, and crash recovery. Engines like MyISAM lack transaction support entirely.

Multiple choice general knowledge science & technology
  1. Eucalyptus

  2. Azure

  3. Amazon

  4. IBM cloud

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Eucalyptus is an open-source software platform for implementing private cloud computing infrastructure. It provides AWS-compatible APIs and allows organizations to build their own cloud services. Azure, Amazon, and IBM Cloud are proprietary public cloud platforms.