Tag: technology

A MERGE statement is used to merge the data of one table with data from another.

A MERGE statement replaces the data of one table with that of another.

A MERGE statement can be used to insert new rows into a table.

A MERGE statement can be used to update existing rows in a table.

binary data up to 4 gigabytes

character data up to 4 gigabytes

raw binary data of variable length up to 2 gigabytes

binary data stored in an external file, up to 4 gigabytes

a hexadecimal string representing the unique address of a row in its table

Chimera

Trojan

Hercules

Hydra

CREATE TABLE EMP9$# AS (empid number(2));

CREATE TABLE EMP*123 AS (empid number(2));

CREATE TABLE PACKAGE AS (packid number(2));

CREATE TABLE 1EMP_TEST AS (empid number(2));

You cannot use IN operator in a condition that involves an outer join

You use (+) on both sides of the WHERE condition to perform an outer join

You use (*) on both sides of the WHERE condition to perform an outer join

You use an outer join to see only the rows that do not meet the join condition

In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outer join

You cannot link a condition that is involved in an outer join to another condition by using the OR operator.

UNIQUE

NOT NULL

CHECK

PRIMARY KEY

a schema object

a subquery that can contain an ORDER BY clause

another name for a view that contains group functions

a subquery that is part of the FROM clause of another query

a space

an asterisk

The default value is not optional

None of the above

we can pass a numerical value in first parameter

we can pass a negative value in second parameter

Both a & b

None of the above

Oracle Flexible Architecture

Oracle Financials Applications

Optimal Flexible Architecture

None of the above