Which operator will be evaluated first in the following SELECT statement? SELECT (2+3*4/2–5) FROM dual;
+
*
/
–
Which two statements about the overloading feature of packages are true? (Choose two)
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.
What is the statement to create 2 files from 1 particular i/p file on specific conditions?
OUTREC
INREC
OUTFIL
None of the above
Which two statements about packages are true? (Choose two)
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.
Which of the following statements is false with respect to packages?
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.
Which of the following will enhance the efficiency of the jcl?
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
Private constructs in the package body are hidden and inaccessible. Is this an advantage of a package?
a)Yes
b)No
c)
d)
When you use the DEFINE variable command, what datatype is the variable?
VARCHAR2
CHAR
LONG
NUMBER
The following statement will raise an exception on which line? select dept_name, avg(all salary) ,count() “number of employees” from emp , dept where deptno = dept_no and count() > 5 group by dept_name order by 2 desc;
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;
Which two program declarations are correct for a stored program unit? (Choose two)
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))