Tag: technology

Questions Related to technology

Which operator will be evaluated first in the following SELECT statement? SELECT (2+3*4/2–5) FROM dual;

technology databases

  1. +

  2. *

  3. /

  4. –

Show answer
Correct Option: B

Which two statements about the overloading feature of packages are true? (Choose two)

technology databases

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

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

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

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

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

Show answer
Correct Option: A,E

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Only local or packaged subprograms can be overloaded. - This option is correct. Overloading can only be applied to subprograms that are defined either locally or within a package.

Option B) Overloading allows different functions with the same name that differ only in their return types. - This option is incorrect. Overloading allows different subprograms (procedures or functions) with the same name, but they must differ in either the number or type or order of parameters, not just the return types.

Option C) Overloading allows different subprograms with the same number, type, and order of the parameter. - This option is incorrect. Overloading requires the subprograms to have differences in either the number or type or order of parameters, not just the same.

Option D) Overloading allows different subprograms with the same name and the same number or type of the parameters. - This option is incorrect. Overloading requires differences in either the number or type or order of parameters, so subprograms with the same number and type of parameters cannot be overloaded.

Option E) Overloading allows different subprograms with the same name but different in either number or type or order of parameters. - This option is correct. Overloading allows subprograms with the same name but with differences in either the number or type or order of parameters.

The correct answer is A and E. These options are correct because overloading can only be applied to local or packaged subprograms, and it allows different subprograms with the same name but different in either the number or type or order of parameters.

What is the statement to create 2 files from 1 particular i/p file on specific conditions?

technology mainframe

  1. OUTREC

  2. INREC

  3. OUTFIL

  4. None of the above

Show answer
Correct Option: C

Which two statements about packages are true? (Choose two)
technology databases

  1. a) Packages can be nested.

  2. b) You can pass parameters to packages.

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

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

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

Show answer
Correct Option: D,E

Which of the following statements is false with respect to packages?
technology databases

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

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

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

  4. d) None of the above.

Show answer
Correct Option: D

Which of the following will enhance the efficiency of the jcl?

technology mainframe

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

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

  3. Order doesn't matter

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

Show answer
Correct Option: A

Private constructs in the package body are hidden and inaccessible. Is this an advantage of a package?
technology databases

  1. a)Yes

  2. b)No

  3. c)

  4. d)

Show answer
Correct Option: A

When you use the DEFINE variable command, what datatype is the variable?
technology databases

  1. VARCHAR2

  2. CHAR

  3. LONG

  4. NUMBER

Show answer
Correct Option: B

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;
technology databases

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

  2. where deptno = dept_no

  3. and count(*) > 5

  4. group by dept_name

  5. order by 2 desc;

Show answer
Correct Option: C

Which two program declarations are correct for a stored program unit? (Choose two)
technology databases

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

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

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

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

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

Show answer
Correct Option: A,C