Tag: technology

Questions Related to technology

NA
technology web technology

  1. a) %ROWTYPE

  2. b) %TYPE

  3. c) AS_COLUMN

  4. d) None of the above

Show answer
Correct Option: A

SQL has facility for programmed handling of errors that arise during the manipulation of data.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

In a PL/SQL block structure, which parts are optional?
technology databases

  1. a) DELCARE and BEGIN

  2. b) DECALRE and EXCEPTION

  3. c) EXCEPTION and END

  4. d) BEGIN and END

Show answer
Correct Option: A,B

A Rollback statement cannot be used to close transaction.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?
technology databases

  1. a) A stored procedure on the server.

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

  3. c) A standalone procedure on the client machine.

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

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

Show answer
Correct Option: E

Which is the procedure used to issue User-Defined error messages from stored Sub-Programs?
technology databases

  1. a) Raise Application procedure

  2. b) Raise Application Error procedure

  3. c) Application Error procedure

  4. d) None of the Above

Show answer
Correct Option: B

How to remove the last record from the i/p file?
technology mainframe

  1. SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE LAST = 1

  2. SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE LAST(1)

  3. SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE TRAILER

  4. All of the above

Show answer
Correct Option: B,C

Which line of the following code has an error? SELECT * FROM emp WHERE comm = NULL ORDER BY ename;
technology databases

  1. SELECT *

  2. FROM emp

  3. WHERE comm = NULL

  4. There is no error in this statement.

Show answer
Correct Option: D
  1. Examine this procedure: CREATE OR REPLACE PROCEDURE DELETE_PLAYER(V_IDIN NUMBER) IS BEGIN DELETE FROM PLAYER WHERE ID = V_ID EXCEPTION WHEN STATS_EXIST_EXCEPTION THEN DBMS_OUTPUT.PUT_LINE(Cannotdeletethisplayer, childrecordsexistin PLAYER_BAT_STAT table); END; What prevents this procedure from being created successfully?
technology databases

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

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

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

  4. d) none of the above

Show answer
Correct Option: C
Explanation:

To understand what prevents this procedure from being created successfully, we need to examine the given procedure. The procedure DELETE_PLAYER takes an input parameter V_IDIN and attempts to delete the corresponding record from the PLAYER table. It also has an exception block that handles the STATS_EXIST_EXCEPTION exception and outputs an error message.

Now, let's go through each option and see if it affects the creation of the procedure:

A. a) A comma has been left after the STATS_EXIST_EXCEPTION exception. This option is incorrect. There is no comma after the STATS_EXIST_EXCEPTION exception, so this cannot be the reason why the procedure cannot be created.

B. b) The STATS_EXIST_EXCEPTION has not been declared as a number. This option is incorrect. The STATS_EXIST_EXCEPTION is not being used as a number, so it does not need to be declared as such. It is being used as an exception.

C. c) The STATS_EXIST_EXCEPTION has not been declared as an exception. This option is correct. The STATS_EXIST_EXCEPTION exception has not been declared in the procedure. Without a declaration, the procedure does not know what to do when the exception is raised. To fix this, the STATS_EXIST_EXCEPTION should be declared as an exception before the BEGIN keyword.

D. d) none of the above This option is incorrect. As explained above, option C is the correct answer.

Therefore, the correct answer is:

The Answer is: C

Find the i/p file records as below: Student A - Max = 100 Min = 60 Student B - Max = 60 Min = 50 Student C - Max = 80 Min = 75 How to format the file to the following o/p data? Student A - Maximum = 100 Minimum = 60 Student B - Maximum = 60 Minimum = 50 Student C - Maximum = 80 Minimum = 75
technology mainframe

  1. OPTION COPY INREC FINDREP=(INOUT=(C'Max',C'Maximum',C'Min',C'Minimum')

  2. OPTION COPY INREC FINDREP=(C'Max',C'Maximum',C'Min',C'Minimum')

  3. Both a and b

  4. None of the above

Show answer
Correct Option: A