Interview Questions

A subquery in an SQL SELECT statement is enclosed in parenthesis (...).

All the statements are equal because inside an interface a variable declared will be public static final by default 

A non-po is an invoice which does not have po(purchase order).However, these invoices requires approval for authorized person/persons to process for payment.

RDBMS is a database management system based on relational model defined by E.F.Codd. Data is stored in the form of rows and columns. The relations among tables are also stored in the form of the table.

Features:
- Provides data to be stored in tables
- Persists data in the form of rows and columns
- Provides facility primary key, to uniquely identify the rows
- Creates indexes for quicker data retrieval
- Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied.(views)
- Sharing a common column in two or more tables(primary key and foreign key)
- Provides multi user accessibility that can be controlled by individual users

Function prototyping is a function declaration statement that tells the compiler about the return type of the function and the number as well as type of arguments required by the function at the time of calling it.

Syntax:

return_type function_name( type1 arg1, type 2 arg2, ... );

Advantages of function prototype :

- It helps the compiler in determining whether a function is called correctly or not. Each time when a function is called, its calling statement is compared with its prototype. In case of any mismatch, compiler reports an error.

- A function must be defined before calling it. But prototyping allows a function to be called before defining it.