Tag: databases

RAW

LONG

VARCHAR

LONG RAW

The statement will achieve the desired results

The statement will execute, but will NOT enable the PRIMARY KEY constraint.

The statement will execute, but will NOT verify that values in the ID column do NOT violate the constraint.

The statement will return a syntax error.

CONCAT

ROUND

TRUNC

RPAD

INSTR

The UNIQUE constraint does not permit a null value for the column.

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index

The NOT NULL constraint ensures that null values are not permitted for the column

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

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