Technology Questions

SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly.

SELECT  ISDATE('1/08/13') AS "MM/DD/YY";

It will return 0 because passed date is not in correct format.

%type is used to declare a field of a table while %rowtype is used to declare a record with the same type as specified in that table, view or cursor.

Example of %type:

DECLARE

         v_EmployeeName emp.ename%TYPE

Example of %rowtype

DECLARE

          v_empployee emp%ROWTYPE;

Constructors use this to refer to another constructor in the same class with a different parameter list.

Constructors use super to invoke the superclass's constructor. If a constructor uses super, it must use it in the first line; otherwise, the compiler will complain.

In this program, we have declared the values as integer instead of character, So it is printing as d99 but it will not arise an error.

In this program, We are dividing the values of a and b, printing it.

All indicate dataset out of space. SD37 - no secondary allocation was specified. SB37 - end of vol. and no further volumes specified. SE37 - Max. of 16 extents already allocated.

Security is one of the major aspects which come with any application and service used by the user. Companies or organizations remain much more concerned with the security provided with the cloud. There are many levels of security which has to be provided within cloud environment such as:

• Identity management: it authorizes the application service or hardware component to be used by authorized users.

• Access control: permissions has to be provided to the users so that they can control the access of other users who are entering the in the cloud environment.

• Authorization and authentication: provision should be made to allow the authorized and authenticated people only to access and change the applications and data.