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

True

False

having

group by

where

both 1 and 2

True

False

Gives the columns referred in select statement of view

Reports a error

Select only particular columns of view table

Outputs the whole view table

Long

Date

rowid

all above

GENERATE SEQUENCE SE START WITH 30 ADD BY 20;

CREATE SEQUENCE SE START WITH 30 ADD BY 20;

CREATE SEQUENCE SE START WITH 30 INCREMENT BY 20;

GENERATE SEQUENCE SE INITIATE WITH 30 INCREMENT BY 20;

Same value of Primary Key can appear in more than one row in the table

A Primary key defined column can be of type LONG

A column that is defined as Primary Key cannot contain NULL value

Both A. and B.

Table name can be an oracle reserved word

Table names must begin with a letter

Table names can contain in it numbers also

None of the Above

SELECT COLUMNS(*) FROM Persons

SELECT COUNT() FROM Persons

SELECT COUNT(*) FROM Persons

SELECT COLUMNS() FROM Persons

order

sort

order by

sort by

SELECT DIFFERENT

SELECT DISTINCT

SELECT UNIQUE

SELECT PRIMARY

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='%a%'