Technology Questions

A collection just like an array is an ordered group of elements of the same type. Each elements position is determined by a unique subscript.

Index by tables:- They are similar to hash arrays that allows to search for subscript values using arbitrary numbers and strings.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL]

INDEX BY [BINARY_INTEGER | PLS_INTEGER | VARCHAR2(size_limit)];

INDEX BY key_type;

Example:

TYPE studenttyp IS TABLE OF emp%ROWTYPE

INDEX BY BINARY_INTEGER;

stud_tab studenttyp;

Nested tables:- they hold random number of elements and use sequential numbers as sub scripts.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL];

Example: TYPE employee_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);

Varrays: Holds a fixed number of elements which can be changed in run time. 

They can be declared as:

TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF element_type [NOT NULL];

Example: TYPE Calendar IS VARRAY(366) OF DATE;

APK stands for Android Application Package.

Android Package (APK) is the package file format used by the Android operating system for distribution and installation of mobile apps and middleware.

A database is used to store, modify, extract and to search for the data within it.

1. Initialization
2. At selection-screen
3. Start-of-selection
4. End-of-selection
5. Top-of-page
6. End-of-page
7. At line-selection
8. At user-command
9. At PF
10. Get
11. At New
12. At LAST
13. AT END
14. AT FIRST

boolean isFile();

We need to first login to the data base as: SQLPLUS followed by user_name/password. Then we need to execute the following query:

CREATE USER user_name IDENTIFIED BY abcd; in this query a user_name suggest the user that is created which has a password abcd which is required for login in database.

BDC ----> Batch Data Communication 

Methods of BDC-----> Direct Input method, Batch Input Session method, Call transaction method.