Tag: databases

Must begin with either a number or a letter.

Must be 1-30 characters long.

Should not be an Oracle Server reserved word.

Must contain only A-Z, a-z, 0-+, _, *, and #.

Must begin with a letter.

=

LIKE

BETWEEN

NOT IN

IS

<>

SELECT last_name FROM EMP WHERE last_name LIKE ‘_A%’;

SELECT last_name FROM EMP WHERE last name =’*A%’

SELECT last_name FROM EMP WHERE last name =’_A%’;

SELECT last_name FROM EMP WHERE last name LIKE ‘*A%’

TRIM

REPLACE

TRUNC

TO_DATE

MOD

ALL

BETWEEN...AND

LIKE

OR

IN

EXISTS

UNION

INTERSECT

INSERT

PROMPT

ACCEPT

DEFINE

Exiting from SQL*Plus

System crashing

Issue of GRANT or CREATE command

None of the above

A table name can duplicate the name of any other database object, if not owned by same user.

Table names are case-sensitive.

Table names begin with a letter.

Table names are not created in Uppercase by default.

CREATE VIEW empl_vu AS SELECT * FROM employee WHERE sal > 10000 WITH READ ONLY;

CREATE VIEW empl_vu AS SELECT * FROM employee WHERE sal > 10000 WITH CHECK OPTION;

CREATE VIEW empl_vu AS SELECT * FROM employee WHERE sal > 10000 WITH CHECK CONSTRAINT;

None of the above