Tag: technology

+

*

/

–

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.

OUTREC

INREC

OUTFIL

None of the above

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.

INCLUDE COND = (10,3,CH,EQ,C'YES') SORT FIELDS = (1,5,CH,A)

SORT FIELDS = (1,5,CH,A) INCLUDE COND = (10,3,CH,EQ,C'YES')

Order doesn't matter

INCLUDE COND = (10,3,CH,EQ,C'YES') SORT FIELDS = COPY

a)Yes

b)No

c)

d)

VARCHAR2

CHAR

LONG

NUMBER

select dept_name, avg(all salary), count(*) “number of employees"

where deptno = dept_no

and count(*) > 5

group by dept_name

order by 2 desc;

a) CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER

b) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER) RETURN NUMBER

c) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER)

d) CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER(10,2)

e) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER(10, 2))