Tag: databases

returns all the matching rows from 2 tables.

returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

returns all rows from 2 tables.

returns all rows that have matching value in the field on which the 2 tables are joined.

An index is the same as alias.

An index is a special way to join 2 or more tables.

An index is a database table attribute, which speeds-up data search within a table.

An index is a database row attribute, which speeds-up data search within a table.

There is no default value.

DESC

Random

ASC

TRUNCATE Sales TABLE

TRUNCATE * FROM TABLE Sales

TRUNCATE TABLE Sales

TRUNCATE * FROM COLUMN Sales

Removal of data redundancy

The introduction of data redundancy

The introduction of non-first normal form relations

The introduction of SQL*Plus

Access. Constant. Information. Data.

Atomicity. Consistency. Isolation. Durability.

Access. Constraint. Index. Data.

Access. Consistency. Isolation. Data.

UPDATE, DELETE, INSERT and SELECT statements.

UPDATE statements only.

DELETE statements only.

INSERT statements only.

NOT NULL

NULL

Function NVL2 is not defined

None of the above

TRUE

FALSE

UNDEFINED

NULL

%rowtype, %toomanyrows, %found

%found, %notfound, %rowcount

%rowtype, %rowcount, %notfound

None of the above