Topic : Architecture

What are the types of character data types?


Answer :

There are seven character datatypes that can be used for defining columns in a table :
CHAR
VARCHAR2
CLOB
LONG
NCHAR
NVARCHAR2
NCLOB

Show Answer Discuss

What is reports server?


Answer :

Reports server is also a component of the middle tier and is hosted in the same node of the concurrent processing server. Reports server is used to produce business intelligence reports.

Show Answer Discuss

What is Oracle HTTP server?


Answer :

Oracle HTTP server is the Web server which is used by Oracle Applications. It processes all the requests received from the clients. The Web server includes a couple of additional components like Web listener; Jserv (Java Servlet Engine) and Java Server Pages.

Show Answer Discuss

What is the difference between database management system and database application?


Answer :

Database Management System is the program that organizes and maintains the information. Database Application is the program that is used to view; retrieve and update information stored in the database.

Show Answer Discuss

What is recursion?


Answer :

Recursion means call to the same sub program within the subprogram.

Show Answer Discuss