Which of the following is true about open source DBMS?

Which of the following is true about open source DBMS?

• Free software with proprietary source code
• Competitive with PC packages and not SQL compliant
• Not competitive with PC packages and SQL compliant
• Free software with publicly available source code 

EXPLANATION

Which of the following is true concerning open-source DBMS?

A. Is free or nearly free database software whose source code is publicly available
B. Is free or nearly free database software whose source code is not publicly available
C. Is not competitive against PC-oriented packages and is fully SQL compliant
D. Is competitive against PC-oriented packages and is not fully SQL compliant
Answer: Option A

 SOURCE

https://www.examveda.com/which-of-the-following-is-true-concerning-open-source-dbms-24525/

Read More

What is backward database recovery?

What is backward database recovery?

• Where after-images are applied to the database
• Switching to an existing copy of the database
• Where after-images and before-images are applied
• Where before-images are applied to the database 

EXPLANATION

 Backward Recovery. Backward recovery restores a journaled database to a prior state. Backward processing starts by rolling back updates to a checkpoint (specified by -SINCE or -AFTER) prior to the desired state and replaying database updates forward till the desired state.

Backward Recovery uses "BEFORE_IMAGE" journaling. With BEFORE_IMAGE journaling, GT.M captures the database updates, as well as "snapshots" of portions of the database immediately prior to the change caused by the update. Unlike forward recovery which works on a backup database, backward recovery works only on  production (current) database provided it is usable and BEFORE_IMAGE journaling is enabled.

 

Read More

What is a DMS-59 connector used for?

What is a DMS-59 connector used for?

• Connecting two high resolution displays to a computer
• Converting two molex connectors to a single 9-pin connector
• Connecting two male RJ45 connectors together
• Connecting two parallel port devices to a computer 

 

EXPLANATION

DMS-59, or Dual Monitor Solution (59 pins), is a connector found on older video cards. It allows for two high resolution displays to be connected via a single port.
The compact size is useful for allowing two displays on a single half-height video card. Monitors typically connect via a special adapter to split the 59 pin connection to dual DVI or dual VGA connectors.

SOURCE

https://en.wikipedia.org/wiki/DMS-59

Read More

Poor data administration in a database can result in…

Poor data administration in a database can result in…

• Missing data elements
• A poorly configured database
• Familiarity with existing data
• A single definition of the same data entity 

 

EXPLANATION

Poor data quality gives rise to poor decisions. A decision can be no better than the information upon which it's based, and critical decisions based on poor-quality data can have very serious consequences. ... Poor data quality can reflect adversely on your organization, lowering customer confidence.

 SOURCE

https://www.examveda.com/poor-data-administration-can-lead-to-which-of-the-following-24514/

 

Read More

Which of the following is true in a DBMS that uses encryption?

Which of the following is true in a DBMS that uses encryption?

• Special integrity constraint rules apply
• Data is stored as plain text
• Data is stored as cipher text
• Data is stored off site 

EXPLANATION

Database encryption uses an algorithm to transform data stored in a database into "cipher text" 
that is incomprehensible without first being decrypted. You encrypt the data using various algorithms.

Read More

What is the voltage input for a Standard Raspberry Pi 3

What is the voltage input for a Standard Raspberry Pi 3

• 5W
• 5mV
• 5V
• 5mW 

 

EXPLANATION

Raspberry Pi can accept 5v which is the output of any standardised mobile phone charger.

SOURCE

https://www.modmypi.com/blog/how-do-i-power-my-raspberry-pi

Read More

Which RAID set stripes data with parallel access and dedicated parity disk

Which RAID set stripes data with parallel access and dedicated parity disk

• 5
• 0
• 3
• 6 

 

EXPLANATION

Raid 0 =  Striped data with no fault tolerance. Good for applications needing high I/O throughput
Raid 5 = Striped set with independent disk access and distributed parity. Dedicated drive parity writes can become bottlenecks, RAID 5 distributes them to avoid. Good for random, read-intensive I/O applications
Raid 6 =  Striped set with independent disk access and dual distributed parity. Includes second parity in case two disks fail. Write penalty is higher. Rebuild time is higher.
Raid 3 =  Striped set with parallel access and a dedicated parity disk. No partial writes to update one strip in a stripe

SOURCE

http://docs.oracle.com/cd/E19247-01/817-3337-18/appa_raid_basic.html

Read More