=

LIKE

BETWEEN

NOT IN

Is

<>

SELECT TO_CHAR(2000, '$#,###.##') from dual

SELECT TO_CHAR(2000, '$0,000.00') from dual

SELECT TO_CHAR(2000, '$9,999.00') from dual

SELECT TO_CHAR(2000, '$9,999.99') from dual

SELECT TO_CHAR(2000, '$2,000.00') FROM dual;

SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;

It returns a single result row based on single rows

It returns a single result row based on groups of rows

It can only appear in ORDER BY clauses

It cannot appear in select lists

SELECT ABS(-33) "Absolute" FROM DUAL;

SELECT ABS(-33), Absolute FROM DUAL;

SELECT ABS("-33") Absolute FROM DUAL;

None of these

it has a syntax error, the AVG clause is not valid

it calculates the average of the maximum salaries of all the departments

it has a syntax error, the MAX clause is not valid

it has no error, but the GROUP BY clause is not effective

COMMIT

MERGE

UPDATE

DELETE

CREATE

DROP

NULLIF

LENGTH

CONCAT

INSTR

TAN

True

False

a) DELCARE and BEGIN

b) DECALRE and EXCEPTION

c) EXCEPTION and END

d) BEGIN and END

True

False

a) A stored procedure on the server.

b) A block of code in a PL/SQL library.

c) A standalone procedure on the client machine.

d) A block of code in the body of the program unit ORDERTOTAL.

e) A local subprogram defined within the program unit ORDERTOTAL.

a) Raise Application procedure

b) Raise Application Error procedure

c) Application Error procedure

d) None of the Above

SELECT *

FROM emp

WHERE comm = NULL

There is no error in this statement.

a) A comma has been left after the STATS_EXIST_EXCEPTION exception.

b) The STATS_EXIST_EXCEPTION has not been declared as a number.

c) The STATS_EXIST_EXCEPTION has not been declared as an exception.

d) none of the above

+

*

/

–

a) Only local or packaged sub programs can be overloaded.

b) Overloading allows different functions with the same name that differ only in their return types.

c) Overloading allows different subprograms with the same number, type and order of the parameter.

d) Overloading allows different subprograms with the same name and same number or type of the parameters.

e) Overloading allows different subprograms with the same name but different in either number or type or order of parameter.

a) Packages can be nested.

b) You can pass parameters to packages.

c) A package is loaded into memory each time it is invoked.

d) The contents of packages can be shared by many applications.

e) You can achieve information hiding by making package constructs private.

a) The package itself cannot be called, parameterized, or nested.

b) The format of a package is similar to that of a subprogram.

c) The contents can be shared by many applications once written.

d) None of the above.

a)Yes

b)No

c)

d)

VARCHAR2

CHAR

LONG

NUMBER