HirePro DBMS Quiz 1

The first database designed primarily for data warehousing and corporate grid computing was Oracle.
Enterprise grid computing is the most flexible and economical method of handling data and applications.

The Oracle Database creates the PGA when an Oracle process is initiated. The PGA is a non-shared memory area that holds data and control information specifically for usage by an Oracle process.

Data blocks are the logical units used to allocate database space.

Tablespaces are the logical storage units that make up an Oracle database.

A DATABASE LINK value uses a URL to point to a resource that is not part of the underlying data source.

In order to avoid any failures, Oracle kept the files in Undo Data before the transaction occurred.

A DML statement does not take effect permanently until the transaction containing it is committed.
An Oracle Database transaction is a series of SQL statements that work together as a single entity.

A database table is created using the CREATE TABLE statement.
Rows and columns are used to structure tables, and each table needs to have a name.

The Data Control Language statement keyword GRANT is used with grants.

The SQL statement type known as Data Communication Language is not one.