Tag: databases

DROP

DELETE

CASCADE

TRUNCATE

INSTR

SUBSTRING

SUBSTR

POS

System tablespace

Users tablespace

Default tablespace for the user

Oracle will give an error

*

/

-

@

5

4

3

There is no such criteria

TO_CHAR

LOWER

LPAD

MAX

INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);

INSERT INTO r4r_team VALUES (1, ‘r4r01’, ‘2’);

INSERT INTO r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

INSERT INTO table r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

True

False

BETWEEN -->>Used for range with in values

LIKE -->>Used for Search a pattern

IN -->>return east one of the columns in given set of values

1,2,3

True

False