Database | MCQs

Explanation

Left Join: Returns all rows from the left table and the matched rows from the right table.

If there is no match, the result is NULL on the side of the right table.

In SQL, the syntax for a left join would look like this:

Explanation

A hierarchical database is a data model in which data is stored in the form of records and organized into a tree-like structure, or parent-child structure, in which one parent node can have many child nodes connected through links.

Explanation

Explanation

If the database operations do not update the database but only retrieve data, this type of transaction is called a read-only transaction.

If the database were in an inconsistent state before a transaction, it would remain in the inconsistent state after the transaction.

Explanation

A memorandum is a written message that is typically used in a professional setting.

Commonly known as a "memo," these messages are typically brief and easily understood.

Explanation

An integer  that can be positive, negative, or zero.

Explanation

Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information.

Explanation

A transaction log is a history of actions executed by a "Database Management System" (DBMS) to guarantee "ACID" properties over crashes or hardware failures.

Physically, a log is a file listing changes to the database, stored in a stable storage format.

Explanation

The relational database environment has all of the following components except separate files.

A relational database is a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

Explanation

A database is information that is set up for easy access, management and updating.

A bit is a binary digit and it is the smallest unit of data on a computer

AGM 24-12-2022